MS SQL Server :: Can Not Attach Msde2000 Db Into Sql Express

Upgrade From Msde2000 To SQL 2005 Express

May 19, 2006

Has any one had experience with upgrading MSDE2000 with no instance to SQL2005 Express?

Thanks

ZS

Can You Install MSDE2000 After You Have Installed SQL Server Express?

Jul 26, 2006

I am aware that instances of both can exist on the same machine.

But I assume that is when a different instance of SQL Server Express is installed with an existing instance of MSDE2000

Many moons ago, when the various flavours and betas of SQL Express became available, I upgraded from MSDE2000 - didn't think I would need it again.

I now have an application, Sony Vegas 6, which uses MSDE2000 for it's Media Manager. According to their support it won't install to SQL Server Express 2005.

When I try to install MSDE2000, it always fails with "Setup failerd to configure server..." and rolls back.

In the event log, there is an entry

The description for Event ID ( 19011 ) in Source ( MSSQL$SONY_MEDIAMGR )
cannot be found. The local computer may not have the necessary registry
information or message DLL files to display messages from a remote
computer. You may be able to use the /AUXSOURCE= flag to retrieve this
description; see Help and Support for details. The following
information is part of the event: (SpnRegister) : Error 1355.

I have down all the usual things like uninstalling SQL Server Express 2005 (using control panel and msiexec /x {GUID}), patching the registry etc etc

The result is always the same.

The Sony Media Manager is not important and I probably won't use it but it's annoying the hell out of me - I've always claimed, over a good few years, that there was no computer problem that I couldn't finally solve, but presently this has got me beat and I feel undone!!!!!!! :-)

regards

Stuart

www.mckears.com

View 3 Replies View Related

Attach Db To Sql 2005 Express Edition

Sep 13, 2007

My dog ate my sql2000 installation disk! After a recent xp installation I remembered that.
Now I'm in a hurry to get up and running with SQL again. I've installed SQL server 2005 express, but I can't attach any databases, or really do anything for that matter. I have a copy of SQL Server 2005 enterprise edition but that won't install on my development machine, Xp Sp2. Which way should I go, install SQL 2005 enterprise on a Win 2003 server or can I download something to administer the express version?
As always thanks for any and all replies!
/Eskil

View 1 Replies View Related

Unable To Attach SQL Express Database

Apr 19, 2008

Hello,
I have a SQL Express database created with VWD 2005 and I want to attach it to the server using the SQL Server Management Studio. It is not the first time when I attach a database, but now, I don't know from what reason, it is not working anymore. So, I copy/paste the mdf and ldf files from the website location (the SQL Server Management Studio is not opening the folder C:usersmyuser in Vista Home Premium, don't know why) to a new location and try to attach. The error message is:
TITLE: Microsoft SQL Server Management Studio Express------------------------------
Attach database failed for Server 'GEORGE-PCSQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476
------------------------------ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
Unable to open the physical file "E:SQLaria.mdf". Operating system error 5: "5(error not found)". (Microsoft SQL Server, Error: 5120)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=5120&LinkId=20476
------------------------------BUTTONS:
OK------------------------------
The file location is OK, what can I do?

Thanks.

View 1 Replies View Related

Can't Attach Database Both Sql 2000/2005 Express ?

Oct 17, 2007

Hi All

I try to attach MobileShop_Data.MDF database by using SQL server 2000 and SQL 2005 Express, but It's impossible . I don't know why .

Someone can help me bypass this problem ? this is my database .

http://www.4shared.com/file/26729050/17b56825/Database.html

Many thanks in advance .
...
regards,
Quachnguyen

View 6 Replies View Related

Management Studio Express Will Not Attach Database

Mar 25, 2008

Hi All,

I created a database in SQL Server Management Studio Express. I since detached the database and consequently now I get the below error message when trying to attach it.

Anyone have any ideas? The database is preety much brand new and very small. I can open the database with Visual Studio.

Thanks in Advance.

Error:

TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
CREATE FILE encountered operating system error 5(error not found) while attempting to open or create the physical file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataS.A.M..mdf'. (Microsoft SQL Server, Error: 5123)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=5123&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------

View 4 Replies View Related

Attach Network Database Sql Server Express

Oct 18, 2006

I am trying to attach a network database to my sql server express

After some reading I "Enabled" tcp/ip, named pipes, and shared memory in sql server confiuration manager.

But when I go to "Attach Database" in Sql Express managemnent studio. It does not show the network drives much less allow me to attach anything on a network drive.

What am I missing here?

If I install sql server on the network machine will my local Sql express recognize it?

View 3 Replies View Related

SQL Express On Vista Cannot Attach The Database Says It Is Already Attached

Mar 8, 2007

I am supposed to be documenting the SQL Express 2005 SP2 installation and connection to our application on Vista. I have installed and uninstalled the application several times in trying to create the connection and document the process. I thought I was done but now the database will not attach because it thinks the databasse is already attached. The database is not attached. I even uninstalled it again thinking something was left over.

Among the possibilities are that the database we are trying to attach is from SQL Server 2003 on a Server 2003. I tend not to think it is a server issue but have no reason to make that statement.

I tend to think it is a Vista issue because I have encountered and circumvented several. Our applications work fine on the full version of SQL. I can connect my Vista computer to the servers without issue. We have no Vista Servers other than the workstation I am trying to get SQL Express running on.

I am about out of ideas. Any suggestion will be tried at this point. Brian

View 1 Replies View Related

Error - Express Create Database For Attach

Apr 3, 2007

Hi Guys,This is my first post and I hope I'm not going to embarrass myself to much.I am currently writing a pseudo install package for SQL Server Express, it is written in VB.Net 2.0.

I have created an *.exe that fires the SQL Server Express install package silently with command line options, once complete the *.exe copies an *.MDF and an *.LDF to the newly created data directory. Once the data has been copied I fire a "CREATE DATABASE FOR ATTACH" using a SQLClient.SQLCommand to attach my DB. I am using Windows Authentication for SQL Server Express.This all works beautifully when the *.exe is being run from a local hard disk - complete success.When I move the *.exe to a CD it fails . SQL Server is installed correctly, the files are copied to the local hard disk in the correct location. I then fire the "CREATE DATABASE" command - its here I get the error.The error details are:Unable to open the physical file "c:....Exchange.LDF". Operating System error 5:"5(error not found)". Cannot create file "c:....Exchnage.ldf" because it already exists. Change the file path or file name, and retry the operation. Could not open new database 'Exchange'. CREATE DATABASE is aborted. File activation failure. The physical file name "c:....Exchange.LDF" may be incorrect.Remember this works perfectly when run from the local hard disk, this only occurs when running from a CD-ROM.Now from the research I have done I believe it may be a permissions error. The setup *.exe is being run from a Administrator account and the SQL Server DB Engine Service Account is System. I'm under the impression that this should provide more than enough permissions.

Thanks for any help you guys may be able to provide...
Matt.

View 11 Replies View Related

Attach Database Failed For SQL Server 2005 Express

Apr 5, 2008

I have installed a sample from the web and put it in my localhost inetpub folder, then i open up my SQL Server 2005 Express to attach the database from the App_Data directory, it throws an error below:

errors occur in both window and sql authentication login.
Error:
Attach database failed for Server '...SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)
Additional Information An exception occcured while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
Directory lookup for the file "C:Documents and SettingsmirtariqMy DocumentsWorksStarterKitVSI smallbusiness_csApp_DataSmallCompanyDB_log.LDF" failed with the operating system error 3(The system cannot find the path specified.).(Microsoft SQL Server, Error:5133)

View 4 Replies View Related

Attach Database Problem - SQL Server Express 2005.

Dec 17, 2007

I m facing a strange phenomenon.
Please refer to below points.

environment:
------------------
windows XP sp2
SQL Server 2005 express [log on as 'network service'(by default)]

programming language: VC++(MFC)

There is a sample database in .mdf format which to be attached to SQL Server.

Ist case:
------------
I add MASTERDSN (for master databse) to ODBC by calling API SQLConfigDataSource() and then attach the sample DB to SQL Server by calling stored procedure 'sp_attach_db' through VC++ code.
On verification from SQL Server management studio express, the DB attached is in read only mode.

II case:
----------
I add MASTERDSN using ODBC data source administrator manually.
Now I add MASTERDSN (again with same name) by calling API SQLConfigDataSource() and then attach the DB to SQL Server by calling stored procedure 'sp_attach_db' through VC++ code.
Now on verification, the DB attached is not in read-only mode.

The problem is that why there is difference in behavior in both cases?
I want to get the sample DB attached in read-write mode in Ist case.

Hopefully waiting for ur response.
Thanks & Regards

View 2 Replies View Related

HOW TO LOGIN IN TO SQL EXPRESS AND HOW TO ATTACH DATABASE PLZZ ITS URGENT

May 23, 2006

Hi

i am developing an installer for our produce where there is a need to install sqlexpress and then i have to attach the database to that but i am unable to understand how to do that , i any one can help in this issue plss

View 1 Replies View Related

Can't Attach Database Using SQL Server Management Studio Express

Apr 15, 2006

I am having a problem Attaching, well actually not being able to see a database when attempting to attach it. I suspect this is more of a security issue rather than a problem with Management Studio, but I can't figure out what is happening.

If I copy a database to Documents and SettingsAll Users... and attempt to attach I can see the file in the selection tree. This also is the case if I copy it to Documents and SettingsDefault User... But if I copy it to Documents and SettingsADynarski... which is the account I normally log into, when I expand the folder in the selection tree, nothing is visible. And the same thing occurs if I copy the file to Documents and SettingsGuest...

I've looked at the security settings and everything appears to be normal. This is on a box with XP Home and SQL Server Express. Can anyone tell me what I'm missing?

Thanks,

Al

View 9 Replies View Related

Attach Error In Sql Server Express Management Studio

Mar 14, 2006

tried to attach a database in sse-ms, and for some reason the database name is changing to G:someFoldersomeFolderdb.mdf, even tho i dont have a drive g:,

during "attach as" screens inside sse-ms, , ie attach>add> then select the database the mdf loction is what it is suppose to be ie C:inetpubwwwrootapp_datachp11wroxunited.mdf but the database name in the same screen shot is G:someOtherFolderAndPathwroxunited.mdf and the attach as is also the G:someOtherFolderAndPathwroxunited.mdf.

pretty confused, could use a clue, thanks

View 3 Replies View Related

Can I Attach To My 2005 Express DB Using The 2005 Mgt Studio (NOT EXPRESS) Client?

Jan 11, 2007

I have a 2005 Express DB I wish to attach to using the 2005 Mgt Studio Client (Not the express version, but the full blown 2005 Mgt Studio Client from the SQL 2005 Standard Edition Install disk). Can this be done, or can I only use the 2005 Mgt Studio Express Edition Client?

Thanks in advance.
M. Scott Blalock

View 1 Replies View Related

How To Attach/deattach A Express Database To A Fullblown SQL Server 2005

Feb 15, 2006

Hi. I would like to if its possible to take a Express ".mdf" file and attach it to a full blown SQL Server 2005?, to "attach" it to a real SQL Server 2005?. And how do i do this?. or do i have to do it since there is a "DataDirectory" directive that manage this for me in the connectionstring?, im a little newbie about this :)

View 1 Replies View Related

NEWBIE.. SQL EXPRESS Attach During VB.NET Windows Application Install - Oneclick

Oct 16, 2006

Here's what I'm going for:

I have an 05 VB.NET windows application that will be used as a smart client for our folks in the field. The windows application includes 05 SQL Server Express. I have included in the Data Sources of my project and attached file going through the wizard Microsoft SQL Server Database File (SqlClient) ='s (myfile.mdf) and then selected all tables, views, stored procedures, and functions... the corresponding myfileDataSet.xsd with the myfile.mdf are now located in the root of the project. I now recompile the project without error and go to the properties section Publish tab... select the Application Files button and myfile.mdf Publish Status is set to Include and the Download Group set to Requried. With this in place I right click on the myfile.mdf from the Soultion Explorer and under the properties section have set the build action to compile and use the copy always setting for the Copy to Output Directory.

My app.config looks like this:

<configSections>
<sectionGroup name="userSettings" type="System.Configuration.UserSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" >
<section name="myfile.My.MySettings" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowExeDefinition="MachineToLocalUser" requirePermission="false" />
</sectionGroup>
</configSections>
<connectionStrings>
<add name="myfile.My.MySettings.ffgscrmConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|myfile.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>

After the publish is completed on the client machine... install for WIndows Installer 3.1, SQL Server Express, and the Windows Application contains no data but everything else works fine.

My problem is that I need to attach the myfile.mdf to the new SQL Server Express instance on the client machine during the installation process so that when the application fires it will be pointed to the above location on the client.

Anyone have any ideas... scripts... includes for an ApplicationEvents.vb, source code on how to do this correctly?

Kind regards,

BillB

View 6 Replies View Related

How Can I Attach AdventureWorks Database To SQL Server Management Studio Express?

Sep 25, 2006

Hi all,

I just downloaded AdventureWorks_Data.mdf, AdventureWorks_Data.ldf, AdventureWorksDW_Data.mdf, and AdventureWorksDW_Data.LDF files to the C:Program FilesMicrosoft SQL ServerMSSQL.1|MSSQLData folder of my Windows XP Pro PC. I tried to attach the AdventureWorks database in my SQL Server Management Studio Express in the following way: I clicked on SQL Server 2005 Express=>SQL Server Management Studio Express=>Right clicked on Databases=> clicked on "Attach..."=> "Attach Databese" showed up. But I can not type in anything under the MDF File Location, Database Name, Attach As, Owner, Status, Message!!!??? What is wrong in my way of doing the attachment of AdventureWorks database (described above)? Please help and advise.

Thanks,

Scott Chang

P. S. I do not have Microsoft Visual Studio 2005. Walkthrough: Install the AdventureWorks Database (http://msdn2.microsoft/en-us/library/ms31035.aspx) : To confirm your SQL Server data directory (Start=>All Programs, Microsoft Visual Studio 2005, Visual Studio Tools, Visual Studio 2005 Command Prompt) steps 1 thru 4 can not be applied to my SQL Server Management Studio Express. I read an SQL Express post dated 19 April 2006 and learned the above-mentioned way to attach the AdventureWorks database in the SQL Server Management Studio Express. But that way does not work for me.

View 4 Replies View Related

Failed To Attach AdventureWorks_Data.mdf Into SQL Server 2005 Express Database In Local

Mar 19, 2008

After i reinstall SQL Server 2005 Express on my local machine, and then tried to attach AdventureWorks_Data.mdf into Database, it gives me the following error:
Mark up:

I tried to reinstall the Adventureworks.msi installer and reattach again in SQL Server 2005 Express, it gave me the same error.
I then deleted both SQL Server 2005 Express & Adventureworks, and then restart my pc and reinstall again, it still gave me the same error.
Error:
Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)
Additional Information:
An Exception occurred while executing a Transact-SQL Statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'C:Program FilesMicrosoft SQL ServerMSSQL.1DataAdventureWorks_Data.mdf' (Microsoft SQL Server, Error:5123)

View 5 Replies View Related

Attach Aspnetdb.mdf Failed, But I Can't Find Attach Statement In The Web.config

Nov 21, 2007

An attempt to attach an auto-named database for file C:WebApp_Dataaspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
My web.config file, the connection strings
<connectionStrings>
<add name="POAdatabaseConnectionString1" connectionString="Data Source=sss;Persist Security Info=True;Initial Catalog=POAdatabase.mdf;Integrated Security=SSPI" providerName="System.Data.SqlClient" />
</connectionStrings>
I cann't really find the statement for attaching aspnetdb.mdf. I don't where to find it. Is there any other web.config file in the C drive? Thanks for help!

View 3 Replies View Related

.mdf File In Virtual Directory And Physical Folder, Which One Should I Attach To Sql Server Management Studio Express

Jun 26, 2007

I have a an asp.net application running under IIS. this application is using two folders, the virtual directory under C:Inetpubwwwroot and the application phisical folder at C:.
I want to manage this applications .mdf database using microsoft sql server management studio express(iam running sql express with advanced services) which means i have to attach the database to Ms sql server managemet studio express tool.
What i dont know is if i should attach the .mdf file in the physical folder's App_Data folder at C:myapplicationFolderApp_data or the .mdf file in the virtual directory under C:InetpubwwwrootMyapplicationFolderApp_Data
I dont know which of the two i should attach. Where exactly is the running database, the .mdf file in the physical folder or the .mdf file in the virtual directory under wwwroot.

View 3 Replies View Related

SQL Server Express: Restore, Backup And Attach Do Not Work Anymore && Database Locations Fault

May 7, 2008

Hello there,

I've some really big problems with SQL Server 2005 Express. I Recently, I had 2 instances on my machine, one was a SQL Server 2000 Developer and the other a 2005 Express Version. The 2000 version was not necessary anymore, so I unstalled it, since then, the Express version keeps having probems.

Under the Server Properties -> Database settings -> Database Locations I've changed the path to D:sqldatamssql, but now, the programm always takes the "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData" to store and load the databases, no matter what I do.

And there are more problems see here:

Restoring does not work=======================
I wanted to restore a database called "fw40_admin" from a backup file (.bak), but that didn't work at all, it always says this as an error:

"System.Data.SqlClient.SqlError: The operating system returned the error '5(error not found)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'D:sqldatamssqlfw40_admin.mdf'. (Microsoft.SqlServer.Express.Smo)"

But as soon as I type in the installation path "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData" inside the "Restore As" under "Options", it works.

Why does the backup only work in "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData", BUT the database locations under the server properties is indicated with "D:sqldatamssql"????

Attaching does not work=======================
Attaching an existing database does not work either. Most databases (mdf) are located on the path D:sqldatamssql, but as soon as I press

Attach Databases -> Add

The dialog window appears with the "D:sqldatamssql" path, but it is unable to find any *.mdfs altough THERE ARE .mdfs in this directory. But Express can find databases in the selected installation: "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData".
Why can't Express see the directory on the D: partition???

What is wrong? Here? Can anybody help me?

View 5 Replies View Related

SQL Server Management Studio Express: Object Explorer - How To Re-attach The Content Of User-defined Database

Nov 21, 2007

Hi all,

I just found that the content of my Database "ssmsExpressDB" is gone, but the name "ssmsExpressDB" remains in the Object Explorer of SQL Server Management Studio Express. If I delected the name "ssmsExpressDB" and executed the following .sql:

exec sp_attach_db @dbname = N'ssmsExpressDB',

@filename1 = N'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDatassmsExpressDB.mdf',

@filename2 = N'C:Program filesMicrosoft SQL ServerMSSQL.1MSSQLDatassmsExpressDB_log.LDF'

GO

I got the following error message:

Msg 5120, Level 16, State 101, Line 1

Unable to open the physical file "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDatassmsExpressDB.mdf". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)".

And I have closed all my projects and I do not know what " The process cannot access the file because it is being used by another process" is all about!? Please help and tell me how I can re-attach the content of my "ssmsExpressDB" in the Object Explorer of SQL Server Management Studio Express.

Thanks in advance,

Scott Chang

====================================================================================

I found the "ssmsExpressDB" is being used by my VB 2005 Express project "Hello-SQLCLR-1": in the Database Explorer, Data Connections place. How can I put it back to the Object Explorer of SQL Server Management Studio Express? Please help and advise.

=======================================================

View 6 Replies View Related

Can Multiple Workstations Running SQL 2005 Server Express Attach To The Same Database Files On A Shared Network Location?

Mar 15, 2007

Can multiple instances of SQL 2005 Express attach to the same database files on a network share? I have seen this done before with MSDE where the database files are stored on the server, but instead of having a SQL server running on the network and then connecting to it, only the database files exist on the network share and the users connect through MSDE running on the local machine. Is this possible with SQL2005Express? I do not have the ability to share an SQL instance from one workstation to another nor do I have the ability to install an instance on the corporate server. Is it as simple as creating the database and storing the files on the share then attaching the database to the SQL Instance on each workstation?

View 3 Replies View Related

Migrating From Sql2000 MSDE Database To Sql2005 Express - Attach Database Errors

Apr 23, 2006

I have a medical records system, SoapWare v4.90, that uses MSDE (SQL2000) databases. Due to the 2gb limitation, I am trying to migrate over to SQL 2005 (Standard or Express) which I have heard works fine. The SoapWare has a datamanager that allows me to log in to the MSDE instance, detach the SoapWare databases from msde (as well as do backups, etc) which I can confirm are detached.

Then I log back into a SQL2005 database instance using the datamanager and try to attach the database. This is what their pictured instructions demonstrate. However, I get the following error:

Database 'sw_charts' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery.

Of course, some of the entries will be read only, since doctors have to sign off the charts and are not allowed to subsequently change them. But I should still be able to switch over to sql 2005?!?!?!?

Or... is there a way to attach the databases to SQLExpress manually?

Help pls?

View 1 Replies View Related

Attach An Sql Express Edition Database File To Sql Developer Edition Instanse

Mar 17, 2007

Hi i have two version of SQL server express (with Visual Studio 2005) and developer edition i am trying to access an sql database file -created by the express edition integrated with Visual studio- using a developer edition instance can i just attach it and access it. and can i use BI and reporting services on that file

View 1 Replies View Related

Installing MSDE2000

Aug 26, 2004

Hi,
I've been trying to follow Microsoft's instructions on installing MSDE2000 for Visual Studio. I do instancename=VSDOTNET SECURITY=SQL SAPWD=XXXX and all that. When I reboot, I notice that I have no services in the SQL Service Manager, nor can it find my computername.

Anybody know why this is?

View 1 Replies View Related

Need Help Setting Up Msde2000

May 23, 2005

hey guys heres my problem iam trying to install SQL server2000 but i keep on running into problems....??
here is what iam having problems with
setup SAPWD="AStrongSAPwd" SECURITYMODE=SQL
it keeps saying the instance name specified is invalid there has to be an easyer way to run the program...??
i have all ready set up an instance name and the SAPWD.
any suggestions?? please help

View 2 Replies View Related

MSDE2000 And SQL ExpressCTP

Sep 11, 2005

Hi,

I have a problem with the database that I created using MSDE 2000 SP4. I tried to attached the database into the new SQL Express using the sp_attach_db and it worked. The message mentioned is that the DB has been upgraded. When I tried to attach back the DB back to my MSDE, it can't be done.

My PC is XP pro SP2. Before I reattach the DB back to MSDE, I detach the DB from my SQL express.

Is it because once the SQL express upgraded the DB, it cannot be supported by MSDE or SQL 2000 ?

Thanks. Any help is greatly appreciated.

View 1 Replies View Related

Msde2000 Installation

Jan 23, 2007

Hi

Im installing MSDE2000 on new Machine Pentium IV LGA Processor HT technology; OS Windows 2000 Professional. Its getting roll Back after some installation.

The same setup if im installing on my other new Machine With Scoket 478 Processor OS Windows2000 Professional. Its installing completly.

Is there any compatibilty problem.

Please Advice me what to do. Thanks In advance

View 2 Replies View Related

Uninstalling Msde2000

Oct 23, 2006

Ii have installed msde 2000 now all my Access files are in 2000 format how do i change back to 2003?

View 1 Replies View Related

Noob Question For Msde2000

Apr 20, 2004

looks like a noob question but how can i manage msde2000...i can see sql is runnin but how can i create database , attach/detach database, write functions and so on...

thanx alot for the reply :)

View 2 Replies View Related