Re: SQL 2005 not associated with connection

Script can look like this:

USE [master]
GO
CREATE LOGIN [<DOMAINNAME>\<GROUPNAME>] FROM WINDOWS WITH DEFAULT_DATABASE=[BeheerDB]
GO
USE [<DATABASENAME>]
GO
CREATE USER [<DOMAINNAME>\<GROUPNAME>] FOR LOGIN [<DOMAINNAME>\<GROUPNAME>]
GO
USE [<DATABASENAME>]
GO
EXEC sp_addrolemember N'db_datareader', N'<DOMAINNAME>\<GROUPNAME>'
GO
USE [<DATABASENAME>]
GO
EXEC sp_addrolemember N'db_datawriter', N'<DOMAINNAME>\<GROUPNAME>'
GO

Change <DOMAINNAME>\<GROUPNAME> with your domainname and groupname
Change <DATABASENAME> with your database name
Without the < and > of course ;)

"MarcH" <marcharms_ditweghalen_@xxxxxxxxx> wrote in message news:OAQrKQ31IHA.2068@xxxxxxxxxxxxxxxxxxxxxxx
I hope you can give me some details on the steps.

1) Create a Windows AD group for all the users that need access to the object (table/view) and put all the users to that group

I created a group (SQL users).

2) Create a login on SQL Server based on the AD group you just created

where can i create a login on SQL ? Is this a user refered to the group (SQL users)?

3) Create a user in the database based on the login you just created

Where can i create that user?

4) Give the appropiate rights on the objects for the user you just created.

That i will find when i know where to create the user

5) Now you can use Windows Authentication when connecting from the client to the SQL Server.




.

Loading