Multiple instances and users

[jdgonzalez]

Hello everyone,

Most of my SQL Server experience has been on the programming side rather than the administration side so I'm hoping someone can help me out. If two instances are created on the same server does the can one domain login have two different levels of access to the instances?

Any help provided would be greatly appreciated.

J.D.

 

[JamesLean]

Yes. When you install an instance it functions as a completely separate "instance" of SQL Server, ie the same as if it had been installed on a separate machine.

Therefore a login that is created on one instance has no permissions on another instance. If a user needs access to both instances they need to have a login and permissions configured on both.

--James

 

[jdgonzalez]

Thanks James. Do you know if that in BOL? I tried finding it but couldn't.

 

[Catadmin]

It sure is. Click the Index tab and type "Multiple Instances of SQL Server".

Also, check out "instance names" for a popup box with 3 different attached articles.



Catadmin - MCDBA, MCSA
Beware the error of pre-emptive poultry inventory!