sql-serversql-server-2008windowsdomainaccount

Can I give access to sql server+reporting services without creating a login/user for each domain account?


In our sqlserver 2008 database each user has a sqlserver login and sqlserver database user. When a new person joins the company the system admins set up their domain accounts but we then have to go in and create a sqlserver login with the same name as the domain user.

Is there any way to make sqlserver let people authenticated to the domain login with some given default access?


Solution

  • Create a Windows Domain Group (such as Domain\SQLReportingUserReaders) and add it to the relevant Reporting Services Roles.

    See Setting Permissions in Reporting Services for more details.