December 26, 2001 at 2:28 pm
Dears,
I have set up a MS SQL 7.0 server, in a win2K server, and have put several databases in it.
Although I have set up "Windows Integrated Authentication", meaning
that everybody who can access the local LAN has the right to use the
database, no one except me (Administrator of the SQL) is able to use
the tables. They can't log in it.
Can anybody on this list please tell me what is wrong with my settings?
Thanks in advance,
Mohammed
December 26, 2001 at 2:30 pm
Mohammed,
you still need to grant rights by adding the NT groups to the SQL Server.
Steve Jones
December 26, 2001 at 2:51 pm
Thanks Steve,
But please explain more for me how to add NT groups to SQL server. Sorry, but I'm a newbie in this field, with only a few months work.
Thanks again,
Mohammed
December 26, 2001 at 3:02 pm
np, happy to help.
In enterprise Manager, select the Security item, then the logins. Right click or use the Action menu to add someone. You can then accept a NT group or a SQL login. When you add them, you also give them database access on the third tab. On this tab, you select the roles in the database.
personally, I'd avoid Public and create a role in each db, then add rights to this role. Do this before adding users, then when you add the users/groups, you can just add them to the role.
HTH, post if you have more questions.
Steve Jones
December 26, 2001 at 4:25 pm
I've got a short walk through posted:
http://www.sqlservercentral.com/columnists/awarren/loginsusersandrolesgettingstarted.asp
Just a wordier example of what Steve explained!
Andy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply