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?
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.
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?
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.
Remove sql srv 2000 registration from SQL SRV 2012
Posted - 12/20/2012 : 16:42:24
