PC Review


Reply
Thread Tools Rate Thread

Cannot Connect to Database by NT User Group

 
 
Scott
Guest
Posts: n/a
 
      16th Jan 2008
I am using SQL Express SP2 with Windows Authentication and Windows XP SP2.

Assigned a Windows user "UserSomeone" to an NT User group as "MyUserGroup".

Set server role members in SQL server for NT User group "MyUserGroup" as
db_creator and public.

Created a database "MyDatabase" as admin who is also a member of
"MyUserGroup".
Set role members of database for NT User group "MyUserGroup" as
db_backupoperator, db_datareader and db_datawriter.

Switched to user login that is assigned to NT User group "MyUserGroup".

With C# .NET attempted to open database using SqlConnection.Open().
Recieved error:
Cannot open database "MyDatabase" requested by the login. The login failed.
Login failed for user 'MACHINENAME\UserSomeone'.

Does anyone now why I cannot connect to this database?
Am I missing some other permission?
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
connect excel user form to access database sam Microsoft Excel Programming 5 8th Jul 2009 04:09 PM
New domain pc and user can't connect to BCM database outlook 2003 AL Microsoft Outlook BCM 5 24th Nov 2008 04:36 PM
set group policy to allow user to connect/disconnect from LAN Struwwwelpeter Windows XP General 0 17th Dec 2007 09:39 PM
Connect drives according to user group membership? Martin Schneider Microsoft Windows 2000 Group Policy 3 6th Jan 2007 11:41 AM
Connect secured access database as current user with ADO Jiøí Pa¹ek Microsoft Access Security 0 16th Dec 2003 10:47 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:02 AM.