Understanding Multiple-Instances of SQL Server?

[fixthebug2003]

Hi,
I am just trying to understand named-instances of SQL Server 2000.
If I have 2 named-instances of SQL Server in a machine, then if I connect to that machine using SQL server Enterprise manager, will I see the 2 named-instances of the database...how does it look like..like 2 groups, and under each group list of all the databases?

Fixthebug2003

 

[ClaireHCM]

You should add both instance into your client network utility first, then only your SQL Server registration list will present both server instances to you. And yes, it's like 2 group, and under each group list of all the databases

 

[fixthebug2003]

Thanks Dude !! Another Question:
So if we have a client application accessing a database in this server..we need to provide the instance name also..right??

 

[ClaireHCM]

better use server IP address with instance name example: 68.72.102.34\SQL1, sometimes the port number may not be default 4133, you should ask network admin about it.

 

[JayKusch]

Also as a side note ... when you are generating queries w/ named instances, you sometimes need to encompass the instance\database name with brackets as [68.72.102.34\SQL1]

Thanks

J. Kusch

 

[SQLBill]

another side note, Claire has a typo in her last post...it's port 1433, not 4133.

-SQLBill

 

[ClaireHCM]

oops, sorry about it. Thanks Bill!