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.
| Author |
Topic |
|
senthilaa
Starting Member
12 Posts |
 Posted - 2008-01-24 : 01:30:23
|
| Hi, I have Windows XP Pro OS with SP2 and SQL Server 2005 installed.I want to give Windows Authentication to my colleague sitting next to me, we are into same LAN. Is it possible to give access to my friend and if so can I create a seperate Security Group and add multiple users to them and give access.-Senthil |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-01-24 : 04:12:07
|
| are you part of a workgroup or a domain?-ec |
 |
|
|
senthilaa
Starting Member
12 Posts |
Posted - 2008-01-24 : 04:20:43
|
| I'm a part of domain-Senthil |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-01-24 : 04:24:56
|
| add your friends domain login to the security section in sql server. then grant the appropriate database access to that login. there is a section in books online dealing with windows authentication that you can reference for more information. It is pretty straightforward.btw, windows auth only works in a domain environment. if you are part of a workgroup windows auth won't work.-ec |
|
|
|
|
|
|
To connect to remote SQL Server