Instead of having to create individual accounts and grant permissions to the individual account, you can grant access to the AD Group in SQL Server and as long as the AD account resides in the AD group, the permission to the SQL Server will be allowed. Take, for example, you have a team of DBAs. Plus, you can enforce your company’s security policies on the account (Password complexity, password expiration, etc.).Īnother handy feature is you can grant access to an instance of SQL Server using a group defined in AD. This helps with account management since the account and password only need to be defined once. SQL Server knows to check AD to see if the account is active, password works, and then checks what level of permissions are granted to the single SQL server instance when using this account. Windows authentication means the account resides in Active Directory for the Domain. A common question asked from super users of applications is, “What is the difference between Windows Authentication and SQL Server Authentication?” While there are many details under the covers of SQL Server and Windows Authentication, the differences can be summed up as follows.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |