SQL 2008 R2 Connectivity / Permissions Issues

I'm sure this will be a simple question for someone.  I have a new Sql 2008 R2 server with a database running on it.  My domain administrator account has rights to the databse.  I need to be able to create an ODBC connection from a workstation to the database.  When I log in as administrator i can connect fine.  When I log in as my domain admin account it will not let me connect.  How do I add domain users to the list of accounts than can access this database?

Thanks!
MohonkAsked:
Who is Participating?
 
jorgedeoliveiraborgesCommented:
>> Where in the management studio would i grant domain users permission?  <<
start > All Programs > Microsoft SQL Server 2008 > SQL Server Management Studio

How to: Create a SQL Server Login
http://msdn.microsoft.com/en-us/library/aa337562.aspx
0
 
Richard QuadlingSenior Software DeveloperCommented:
Within SQL Server Management Studio, you need to make sure you have windows authentication enabled for the server.

You can then add users/groups to the logins for the server.

You can then add those logins to the database.
0
 
MohonkAuthor Commented:
Where in the management studio would i grant domain users permission?
0
 
Richard QuadlingSenior Software DeveloperCommented:
Windows only authentication :
USE [master]
GO
EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 1
GO

Open in new window


Windows and SQL authentication :
USE [master]
GO
EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2
GO

Open in new window


Create domain group user with public access to a database :
USE [master]
GO
CREATE LOGIN [RICHARD-TOSH\HomeUsers] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[British]
GO
USE [ReportServer]
GO
CREATE USER [RICHARD-TOSH\HomeUsers] FOR LOGIN [RICHARD-TOSH\HomeUsers]
GO

Open in new window


These scripts are generated by the MSSMS (I'm using SQL 2008 R2 Dev Ed - excellent value for money for a sole developer).
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.