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 2012 Forums
 SQL Server Administration (2012)
 SQL Server on different Windows User accounts

Author  Topic 

dgs009
Starting Member

3 Posts

Posted - 2014-03-23 : 09:53:08
Let's say that I have two Windows Users accounts. We'll call them account A account B. I have installed SQL Server on Windows User account A. What do I do in order to get SQL Server on Windows User account B? Do i need to re-install SQL Server completely or is there something that I have to do with permissions so that I can access the same installation that is on Windows User account A?

Dan

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2014-03-23 : 18:13:31
You will need to add a login on the SQL Server for account B. See here: http://technet.microsoft.com/en-us/library/aa337562.aspx I you have never done it before, using SQL Server Management Studio method would perhaps be easier.

The SQL Server login is different from the Windows login (although you can use the windows login to create a login on the SQL Server as well in the so-called integrated login).
Go to Top of Page
   

- Advertisement -