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. |
|
|
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 MAINPCStill can't remove connection to the old 2000 version. |
|
|
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? |
|
|
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? |
|
|
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? |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
Rasta Pickles
Posting Yak Master
174 Posts |
Posted - 2012-12-21 : 15:39:43
|
Gotta love Microsoft.......... |
|
|
|