December 20, 2012 at 9:29 pm
Installed SQL Server 2012 Express using default name - SQLExpress on sserver MAINPC. Opened Management Studio and created a server registration to an existing SQL Server 2000 instance that was created as (local).
Now whenever I create a database, it is created in the old 2000 instance. I have tried to create a new server registration, but it is always created as a 2000 registration.
How can I create a 2012 server registration? Do I have to uninstall 2012 express and reinstall?
December 21, 2012 at 5:08 am
Both instances cannot be the default instance. It sounds like your 2000 instance was already running on port 1433 so you need to figure the port for the Express instance. See this article for information on how to find which port your instance is running on using the SQL Server Configuration Manager :
Configure a Server to Listen on a Specific TCP Port (SQL Server Configuration Manager)
Once you identify which port number your SQL Express 2012 instance is running on you can connect to the instance using that port number. In the connection dialog on SSMS, instead of supplying only MAINPC you can also supply the posrt number like so:
<servername>,<portnumber>
For example:
MAINPC,1713
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
December 21, 2012 at 7:59 am
Below are the steps in the document you mentioned. All ports are set to 0. I tried to right-click as instructed in step 2, but nothing happens. I do not get any dialog box to select Properties from.
In step 4, how would I know which port to assign?
1.In SQL Server Configuration Manager, in the console pane, expand SQL Server Network Configuration, expand Protocols for <instance name>, and then double-click TCP/IP.
2.In the TCP/IP Properties dialog box, on the IP Addresses tab, several IP addresses appear in the format IP1, IP2, up to IPAll. One of these is for the IP address of the loopback adapter, 127.0.0.1. Additional IP addresses appear for each IP Address on the computer. Right-click each address, and then click Properties to identify the IP address that you want to configure.
3.If the TCP Dynamic Ports dialog box contains 0, indicating the Database Engine is listening on dynamic ports, delete the 0.
4.In the IPn Properties area box, in the TCP Port box, type the port number you want this IP address to listen on, and then click OK.
5.In the console pane, click SQL Server Services.
6.In the details pane, right-click SQL Server (<instance name>) and then click Restart, to stop and restart SQL Server.
December 21, 2012 at 9:08 am
Sanity check before you change anything. You are trying to connect to MAINPC\SQLExpress through SSMS 2012, corrrect? Have you verified SQL Browser service is running?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
December 21, 2012 at 9:27 am
Yes - I am using MAINPC\SQLExpress.
SQL Server Browser says - Disabled
December 21, 2012 at 9:28 am
Enable and start that service first. Then try connecting to MAINPC\SqlExpress using SSMS 2012.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
December 21, 2012 at 9:45 am
Did not have an "Enabled" selection, so I used "Manual" and started the service. In SSMS I was able to add a new registration to MAINPC/SQLEXPRESS. Now I show 2 reghistrations in the object tree:
MAINPC (SQL Server 8.0.19a - sa)
MAINPC\SQLEXPRESS (SQL Server 11.0.3000 - sa)
Looks like it "Might" be working now.
In the mean time you might look at the "Side-by-Side Installation with SQL Server 2000" section of the document at: http://msdn.microsoft.com/en-us/library/ms181087(v=SQL.105).aspx
WOW - thanks for you great help. I will do some testing and let you know what I determine.
December 21, 2012 at 9:49 am
"Enabled" = (Not Disabled) 🙂 , i.e. service start type = Manual or Automatic. I like Automatic so I do not need to remember to start it each time after a reboot when I want to connect to a local named instance instance.
Happy you got it sorted 🙂
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
December 21, 2012 at 9:59 am
I have created a new development database and have created several tables and inserted the master control entries.
Everything seems to be working OK. Now comes the learning process for the new 2012 features.
Thanks again.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply