Using windows authentication on multiple computers

Question

Using windows authentication on multiple computers

Viewing 7 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 1

Nathan

Create a Windows group containing all the users that need access to the database. Then grant that group access to the server, that is, make it a login on the server.

John

Nathan Baker-397860 Valued Member Points: 67 More actions · Answer 2

Ok I had tried to do that going into My Computer>Manage>Local Users and Groups>New Group

When I did this I could only add the user on the computer I was doing it on which I will call computer 1. How can I take the user on Computer 2 and also add him to the same group. I was unable to see anything except the local computer when I was adding users to the group. Could you explain what I did wrong and how to do it correctly.

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 3

Nathan

I think I'm right in saying that you can't put local users from one computer in a local group on another. If you have a domain, create a global group (are they still called that?) instead. If you don't have a domain, I don't think you can do what you're trying to do and you'll have to use SQL authentication instead.

John

Nathan Baker-397860 Valued Member Points: 67 More actions · Answer 4

How would I check on the domain and possibly set one up if I dont have one. Since I am just developing the application I have not actually put it on a server which might be part of the problem. Right now I am testing on 2 XP PRO machines with one having SQL Server 2005 developer installed. I know the server is going to have SMB 2003 R2 but right now that doesnt help me for testing.

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 5

Nathan

To get a domain set up, you'll need to speak to your network administrator. In the meantime, your best bet is probably to do all your testing on one computer.

John

Nathan Baker-397860 Valued Member Points: 67 More actions · Answer 6

Well I am the network admin since it is a small company but as I am just out of college and focused primarily on programming I dont have much networking background to know how to go about setting up a domain.

Nathan Baker-397860 Valued Member Points: 67 More actions · Answer 7

Ok from doing a little searching on the web it looks like I cant set up a domain for testing so I guess that will have to wait for right before implementation. I have to test having multiple users at the same time so it would have been a lot simpler than modifying my connection for each computer in my application but oh well.