The Windows Server group is your premier resource for objective technical discussion and peer-to-peer support on the Microsoft Windows Server family of products including Windows Server 2003, IIS Server, ISA Server, and SMS Server.

Client can't access SQL Server database in domain (Server2008)

Here I have Domain Network Where Users can't access SQL server Database but Before users access same thing on workgroup.So I want to know what changes I should do so user can access SQL Database in Domain.

1.You need to add all the systems to domain first
2. Create a username and password in ADS
3. Then create a profile in Local System.
4. Add sql server in server and give permission to access only sql server.

You should add them to an AD group. Then you need to go into SQL
Management studio and check that you add it as a security group. From
there you can add the AD group to the databases and check the job
roles and tick the access you want to give em.

You should add them to an AD group. Then you need to go into SQL
Management studio and check that you add it as a security group. From
there you can add the AD group to the databases and check the job
roles and tick the access you want to give em.

You should add them to an AD group. Then you need to go into SQL
Management studio and check that you add it as a security group. From
there you can add the AD group to the databases and check the job
roles and tick the access you want to give em.

Copyright 1998-2015 Ziff Davis, LLC (Toolbox.com). All rights reserved. All product names are trademarks of their respective companies. Toolbox.com is not
affiliated with or endorsed by any company listed at this site.