I was using SQL server 2005 express edition and therefore was limited by a database 4GB in size. I decided to install SQL server 2005 developer (64bits) in order to be able to go beyond 4 gigabytes data base size. The installation program run with no error message on a Windows 7 64 bit, but did not install the SQL server Management Studio.
After searching around, I found out and ran the installation program on CD2 SqlRun_Tools.msi which installed the missing tools. I then installed the SQL server SP3 package. When I opened the Management Studio, the 3 instances of SQL 2005 Express were there but no SQL 2005 developer edition (new) instance was shown.
I restored the system, then removed each one of the SQL server Express instances, then fully reinstalled the SQL 2005 developer edition with its default instance name. But again no SQLserver 2005 Developer instance was listed on the SQL Server management studio. Surprise! the 3 instances from SQL 2005 Express edition (which were all previously uninstalled) were still there, but not accessible.
I have tried to access the new SQL server Developer through my code but the instance has not been found either. All connection strings have been working for a long time with SQL Express edition and are correct. I have also checked that SQl server and SQl browser were started.
I would really appreciate your help.
Thanks a lot.
