2

I would like to add an Active Directory Group to the SQL Server, so that I do not have to provide windows authentication o the server to every user. Is this possible?

Another thing is how do I enable my .NET application to connect to the database using this Active Directory credential?

Thanks in advance Nishant

Nishant
  • 905
  • 1
  • 16
  • 36

1 Answers1

1

Both your questions can be answered by searching!

  • Adding AD group to SQL server logins is here
  • Connection strings to SQL server with Windows Auth is here
Community
  • 1
  • 1
Bridge
  • 29,818
  • 9
  • 60
  • 82
  • I am able to add the AD group, but unable to login from my application based on this AD group. The connection string I am using is Persist Security Info=False;Integrated Security=SSPI;database=TestDatabase;server=TestServer;Connect Timeout=60 – Nishant Feb 21 '12 at 11:42
  • You asked for "Login" originally, but I'm guessing you mean you need database users too - see [here](http://stackoverflow.com/questions/1134319/difference-between-a-user-and-a-login-in-sql-server) for an explanation – Bridge Feb 21 '12 at 11:54
  • Thanks Bridge. I should not be an user in the database. Not even disabled. Only then the active directory group will considered. – Nishant Feb 21 '12 at 12:29