Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Remove sql srv 2000 registration from SQL SRV 2012

Author  Topic 

DevMan
Starting Member

5 Posts

Posted - 2012-12-20 : 16:42:24
Just installed SQL SRV 2012 Express. Opened Server Management Studio and created a server registration to my old SQL SRV 2000 databases for testing.

Everytime I create a new database it is created in 2000. I have tried deleting the registration and adding a new registration. Closed management studio and retried steps above. No matter what I do, when I add a new registration, it connects to the old 2000 databases.

Have searched helps docs but find nothing pertinent.

Can somebody suggest the steps to delete the 2000 registration and create a new 2012 registration?

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-12-20 : 17:13:53
The server name for SQL 2012 Express would be something like (local)\SqlExpress. However, I am only guessing here - to find out for sure, Start -> Run -> Services.msc and look for the SQL Server process. It would say something like SQL Server (SQLEXPRESS). That thing in the brackets - SQLEXPRESS in this example - is what you should use as the server name - (local)\SQLEXPRESS in this example.
Go to Top of Page

DevMan
Starting Member

5 Posts

Posted - 2012-12-20 : 17:27:26
I installed 2012 with default name (SQLEXPRESS). There was already a 2000 installation running, so 2012 was installed as a named instance MAINPC

Still can't remove connection to the old 2000 version.
Go to Top of Page

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-12-20 : 19:03:04
Are you able to register the SQL 2012 Express even if not able to remove the SQL 2000 registration?
Go to Top of Page

DevMan
Starting Member

5 Posts

Posted - 2012-12-20 : 23:38:48
No. When any new registration is created it contains the old 2000 databases. New 2012 Express installation was created with the same administrator name and password. Could that be causing any issues?
Go to Top of Page

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-12-21 : 07:58:52
What is the name of the server name you are using in the New Registration dialog? Can you list the exact steps you are going through?
Go to Top of Page

DevMan
Starting Member

5 Posts

Posted - 2012-12-21 : 10:08:04
2012 server name is MAINPC. Old 2000 instance was installed on (local).

I right-click New Server Registration and type MAINPC for the server name. A registration is created but it is populated with the old 2000 databases.

It seems to have something to do with the port that is assisgned.
Go to Top of Page

DevMan
Starting Member

5 Posts

Posted - 2012-12-21 : 12:19:00
Problem solved. Due to conflict with SQL2000 on port 1433, SQL Server Browser was disabled. Enabled and started that service and was able to add a new server registration to SQLExpress.

Thanks for your help.
Go to Top of Page

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-12-21 : 12:43:19
Thank you for posting back with the solution. Unfortunately many people do not do that - so, much appreciated.
Go to Top of Page

Rasta Pickles
Posting Yak Master

174 Posts

Posted - 2012-12-21 : 15:39:43
Gotta love Microsoft..........
Go to Top of Page
   

- Advertisement -