Active Directory Users Syncronize to SQL Server 2005

myanilkumar

Hi,

Is there any option when i create User ID's in Active directory automatically create in SQL Server.

Please let me know.

Regards,
Anil

ara3n

you can create groups. Assign the new user to the group.

In sql allow the AD group to access the db.

myanilkumar

Hi Rasheed,

Thanks for your reply. Can you explain me in detail where should i must create groups and assign?

Regards,
Anil

ara3n

In active directory you create a global group and then assign users to it.

In nav you add the group to the windows users.

Make sure your security model is simple.

File->database->Alter->advanced tab_>security model.

myanilkumar

Thanks Rasheed for help.

David_Singleton

ara3n wrote:

you can create groups. Assign the new user to the group.

In sql allow the AD group to access the db.

=D> Oh that is so simple. Why aren't I doing that? .... I will in the future though.

ara3n

On my dev server. I have only one group called Developers. That way everybody in the company I work for can access the db. I don't have to worry about new hires etc, because the AD administrator will be managing that.