Multiple Instances - SQLSERVER
-
Hello I have a computer with sql server 2000 and sql server 2005. for some reason the instance of sql server 2005 is not published in the network appropriately. When I try to connect to the database engine I am going to the server name and I browse. I go to network servers and I can find the instance of SQL Server 2000 but I cant find the instance of sql server 2005. Does any one know what are all the options for registering the sqlserver instance ? Clint
-
Hello I have a computer with sql server 2000 and sql server 2005. for some reason the instance of sql server 2005 is not published in the network appropriately. When I try to connect to the database engine I am going to the server name and I browse. I go to network servers and I can find the instance of SQL Server 2000 but I cant find the instance of sql server 2005. Does any one know what are all the options for registering the sqlserver instance ? Clint
Can't you connect to it? Or you just can't find it in the list of servers in connection dialogs? for MS SQL Server 2005 to be browsable, you must run the SQL Server browser service. Start->SQL Server Configuration Tools->SQL Server Configuration manager make sure that the SQL Server browser service is running. I Hope this helps.
Hesham A. Amin blog