MS SQL Server - Windows authentication and SQL login roles

Author

Windows authentication and SQL login roles

ChemFinder

2006-10-25, 6:00 am

I configured SQL Server 2005 Express to use Windows authentication. I
want to give ordinary users sysadmin privileges. How do you map
Windows groups to SQL Server logins? There appears to be one Login,
BUILTIN\Users. Members of the Administrators group of the machine have
full access, but members of the Power Users Groups are logged into SQL
Server as 'guest.' How are Windows Authentication logins mapped to SQL
Server logins?
--

Paul Ibison

2006-10-25, 6:00 am

CREATE LOGIN & #91;domainname\group
name] FROM WINDOWS;
GO

(see http://msdn2.microsoft.com/en-us/library/ms189751.aspx for more info)

Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Arnie Rowland

2006-10-25, 6:00 am

You might find the Management Studio 'Express' useful. Download a copy at:

SQL Server 2005 Express Edition (Advanced/SSMS)
http://msdn.microsoft.com/vstudio/e...re/default.aspx
http://msdn2.microsoft.com/en-us/library/ms365247.aspx

SQL Server 2005 SSMS Express Tutorial
http://tinyurl.com/nqsca

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf

"ChemFinder" <jkatz@compucyte.com> wrote in message
news:1161625647.887433.72310@m7g2000cwm.googlegroups.com...
>I configured SQL Server 2005 Express to use Windows authentication. I
> want to give ordinary users sysadmin privileges. How do you map
> Windows groups to SQL Server logins? There appears to be one Login,
> BUILTIN\Users. Members of the Administrators group of the machine have
> full access, but members of the Power Users Groups are logged into SQL
> Server as 'guest.' How are Windows Authentication logins mapped to SQL
> Server logins?
> --
>

Sponsored Links