July 10, 2011 at 9:46 pm
Dear.
Here I am trying to Add all the Users of the Active Directory as SQL server Users so that they can log in as sql users and as well as i don't need to create another user on the sql server to login into...
Thankyou.....
July 10, 2011 at 11:07 pm
was this a question/dairy entry/ statement? i dont see the question realy.
anyway, why add all the users as SQL Accounts? they are not linked to AD users.
Rather create an AD group, add all your users to that group, and grant permissions to the group in SQL, it makes management so much easier than a long list of accounts in SQL Server...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 11, 2011 at 4:27 pm
desertrosenp (7/10/2011)
Dear.Here I am trying to Add all the Users of the Active Directory as SQL server Users so that they can log in as sql users and as well as i don't need to create another user on the sql server to login into...
Thankyou.....
It's an odd request, but if you really want everyone in AD to be able to access a SQL Server instance you can simply add the local Users group, which should contain your Domain Users group and grant everyone access.
CREATE LOGIN [BUILTIN\Users] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
GO
Now as far as what server and databases permissions you want to grant the SQL Login that's a different story. What are you trying to accomplish?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply