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 |
|
annac
Starting Member
8 Posts |
 Posted - 2004-05-05 : 17:33:42
|
| Much is made in books online of the advantages of using Windows Authentication in NT or 2000. I have a bunch of networked PCs running 2000, but no domain. In this situation, can I use Windows Authentication? I would have thought not, and had no success using sp_grantlogin, but possibly I am doing something wrong.Could someone enlighten me please?Many thanks,Anna-------------------------------------------------------------If at first you don't succeed destroy all evidence that you tried. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-05 : 18:11:29
|
| Yes you can still use Windows Authentication. Pass ServerName\UserName to sp_grantlogin instead of DomainName\UserName.Tara |
 |
|
|
annac
Starting Member
8 Posts |
Posted - 2004-05-06 : 03:35:16
|
| Sorry, I didn't make it clear. This is a peer to peer network, not client-server. One of the machines is running Windows 2000 server, but just so we can run SQL Server developer edition. Users are set up on the individual machines only. If I try sp_grantlogin 'pcname\username' it returnsServer: Msg 15401, Level 11, State 1, Procedure sp_grantlogin, Line 41Windows NT user or group 'pcname\username' not found. Check the name again.Is this a case for SQL Server logins? |
|
|
|
tonyshukal
Starting Member
7 Posts |
Posted - 2004-05-06 : 08:01:32
|
| In peer to peer netowrk it is best to use SQL Login. However if you really want to use Windows Authentication then;1. Make computer account in SQL Server Machine2. Make user account in windows3. then use SP_GrantLogin |
|
|
|
|
|
|
Windows Authentication