MSDE upgrade to SQL Server 2005

I have a Software product that installed the MSDE database engine with its
product. The database this software product created is a SQL Server 7.0
database. The database is now causing some issues due to size and performance
issues so I trying to upgrade to SQL SERVER 2005 and create a new database
that i can use. I loaded SQL Server 2005 Enterprise Edition on this server
that had only one SQL instance running on it(MSSQLSERVER). SQL Server 2005
loaded successfully but never queried me for what type if instance to install
(default or named). I still only have one SQL instance running(MSSQLSERVER).
When I open SQL Server Management Studio I get this message "This version of
MSSMS can only be used to connect to SQL Server 2000 and SQL Server 2005
servers. Do I just need to detach and reattach the databases. If I were to
copy the databases to the 2005 instance, I read it should be copied into the
folder C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data. However this
folder does not exist. Under C:\Program Files\Microsoft SQL Server I only
have two folders "80" and "90". Did my SQL Server 2005 load correctly? My
original SQL instance was loaded on E:\MSSQL7 would my SQL 2005 installation
have updated these files instead?

hi,
MelGu32 wrote:
> I have a Software product that installed the MSDE database engine
> with its product. The database this software product created is a
> SQL Server 7.0 database. The database is now causing some issues due
> to size and performance issues so I trying to upgrade to SQL SERVER
> 2005 and create a new database that i can use. I loaded SQL Server
> 2005 Enterprise Edition on this server that had only one SQL instance
> running on it(MSSQLSERVER).

as per http://msdn.microsoft.com/en-us/library/ms143393(SQL.90).aspx,
the desktop engine/MSDE 1.0 version should be supported in upgrade path to
Standard\Workgroup\Express editions and not to Enterprise..

>SQL Server 2005 loaded successfully but
> never queried me for what type if instance to install (default or
> named). I still only have one SQL instance running(MSSQLSERVER).
> When I open SQL Server Management Studio I get this message "This
> version of MSSMS can only be used to connect to SQL Server 2000 and
> SQL Server 2005 servers.

this seems to indicate the instance you are trying to connect is not
supported by SSMS, which does not connect to SQL 7.0 code based versions..

> Do I just need to detach and reattach the
> databases. If I were to copy the databases to the 2005 instance, I
> read it should be copied into the folder C:\Program Files\Microsoft
> SQL Server\MSSQL.1\MSSQL\Data. However this folder does not exist.
> Under C:\Program Files\Microsoft SQL Server I only have two folders
> "80" and "90". Did my SQL Server 2005 load correctly? My original
> SQL instance was loaded on E:\MSSQL7 would my SQL 2005 installation
> have updated these files instead?
this seems to indicate you did not install a SQL Server 2005 instance..
verify in the services applet as well, but to me, you still have your
original MSDE 1.0 instance installed and you only added the SQL Server 2005
client tools..
regards
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://www.hotelsole.com
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
--------- remove DMO to reply