Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 authentication for multiple instances of sqlserver

Author  Topic 

newsqlbee
Starting Member

3 Posts

Posted - 2009-07-29 : 04:44:24
Hi Gurus!!

i am installing multiple instances of sqlserver on my laptop, so can i use built-in account(only windows authentication) for all instances including named and default ? i dnt have any domain account, only local system account is there.

please reply to my query and do explain the how can i use single account for multiple instances?

thanks

mcrowley
Aged Yak Warrior

771 Posts

Posted - 2009-07-29 : 13:12:56
Do you mean a single account to run the MSSQL Services? Or to log into each instance?+
Go to Top of Page

wshawnmelton
Starting Member

17 Posts

Posted - 2009-07-30 : 15:03:43
If the account you are logging on with is a local adminstrator on the SQL server then it will have access to all instances on that server/laptop by default.

w s melton
Go to Top of Page
   

- Advertisement -