[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

MSSQL Windows Authentication Permissions on Win2k3 SBS

Posted on 2008-01-30
1
Medium Priority
?
372 Views
Last Modified: 2012-05-05
Ive got a Windows 2k3 SBS with MSSQL on it with Windows Authentication enabled.  There is a database which programA uses and it all works correctly.  ProgramA uses individual windows auth to connect to the db and has its own internal security permissions for users built in to the app/db.

4 out of 5 users can access the DB fine using win auth and the program has no issues, the 5th users cannot.  4 users are a member of Domain Admins, the 5th is not.

How can I tell MSSQL to allow Domain Users to access the DB's/SQL Server?
0
Comment
Question by:sc230
1 Comment
 
LVL 15

Accepted Solution

by:
Faiga Diegel earned 2000 total points
ID: 20781038
USE Master
GO
CREATE LOGIN [DomainName\UserAccount]
FROM WINDOWS
WITH DEFAULT_DATABASE = [databaseName]
,DEFAULT_LANGUAGE = [us_english]
GO

USE [DatabaseName]
GO
CREATE USER [DomainName\UserAccount]
FOR LOGIN [DomainName\UserAccount]
WITH DEFAULT_SCHEMA = [dbo]
GO

--then enroll role membership

USE [databasename]
GO
EXEC sp_addrolemember 'sysadmin', [DomainName\UserAccount]

Plan how to set database roles and memebership.

http://msdn2.microsoft.com/en-us/library/ms189612.aspx
http://msdn2.microsoft.com/en-us/library/ms189121.aspx
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

612 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question