January 16, 2007 at 8:30 am
Is it possible to create a windows authentication login for each of the computers on my network that will connect to sql server. I am developing a program that will be installed on multiple computers and we do not want to actually have to log in to sql server since we will have to log in to the server before opening the program and we dont want to have 2 logins. I would like to use windows authentication so that I do not have to program multiple connection strings in my program so that if more than 1 person accesses the database at the same time it will not cause a problem with using the same login. Is this possible and if so how would I go about setting up the logins. Please give me detailed instructions as I am very new at this and am not having any luck figuring this out on my own. I am using SQL Server 2005 and XP SP2
January 16, 2007 at 8:56 am
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
January 16, 2007 at 9:02 am
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.
January 16, 2007 at 9:12 am
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
January 16, 2007 at 9:15 am
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.
January 16, 2007 at 9:28 am
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
January 16, 2007 at 9:31 am
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.
January 16, 2007 at 9:45 am
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.
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply