June 5, 2008 at 2:55 am
hi,
We installed the server in Named instance, but my query is
i'm able to connect the server using default instance (ServerName) as well as the named instance (Servername\sqlExpress) , but both are showing the same databases.
Both the instance the server properties should be, General -> name shows the Servername\SQLEXPRESS.
Please clarrify whether the server having two instance (default & named) ?
thanks & regards
Saravanakumar.R
June 5, 2008 at 6:24 am
Go to Start - run - type 'Sqlservermanager.msc' and hit enter which will open Sql Server configuration manager. Click Sql Server 2005 services and in the right side it will display the list of services available. From that you can find it. In any server there can be only one default instance and multiple named instances. Sql Express will by default be installed as named instance i.e with the name Servername\SqlExpress..
[font="Verdana"]- Deepak[/font]
June 5, 2008 at 10:41 pm
[font="Verdana"]Hi,
In this case since default instance doesn't exist in the server, and sql browser service will allocate dynamic port to sql service and hence when you use the servername it will check for default instance and if it not there then it will point the named instance (this is possible if you have only one named instance)[/font]
Regards..Vidhya Sagar
SQL-Articles
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply