SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Remove sql srv 2000 registration from SQL SRV 2012
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

DevMan
Starting Member

USA
5 Posts

Posted - 12/20/2012 :  16:42:24  Show Profile  Reply with Quote
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?

Edited by - DevMan on 12/20/2012 17:19:45

sunitabeck
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 12/20/2012 :  17:13:53  Show Profile  Reply with Quote
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

USA
5 Posts

Posted - 12/20/2012 :  17:27:26  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 12/20/2012 :  19:03:04  Show Profile  Reply with Quote
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

USA
5 Posts

Posted - 12/20/2012 :  23:38:48  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 12/21/2012 :  07:58:52  Show Profile  Reply with Quote
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?

Edited by - sunitabeck on 12/21/2012 07:59:09
Go to Top of Page

DevMan
Starting Member

USA
5 Posts

Posted - 12/21/2012 :  10:08:04  Show Profile  Reply with Quote
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

USA
5 Posts

Posted - 12/21/2012 :  12:19:00  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 12/21/2012 :  12:43:19  Show Profile  Reply with Quote
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

United Kingdom
171 Posts

Posted - 12/21/2012 :  15:39:43  Show Profile  Reply with Quote
Gotta love Microsoft..........
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000