Access to SQL server via Domain Group

  • Hi,

    I have users in multiple regions who access a database (replicated to each region) via an application.

    Access is controlled via a domain group which has data reader/writer permissions.

    My problem is that the last 3 users added to the Domain Group are unable to access their local database. They can connect to the DB in other regions however. More specifically the new users are unable to login to the Replication Publisher DB.

    Does anyone have any thoughts on this?

    Error message: Cannot open database 'X' requested by login. The login failed. Login failed for the user domainX\userX

    Setup is as follows:

    -Replication Publisher/Distributor (same server): SQL server 2005

    -Subscribers :SQL server 2000

    -Windows Server 2003 on all servers

    -All servers are VM ware virtual servers

  • I had something similar once. Turned out that the user's logins were disabled on one server somehow. Never did figure out the cause, but we were having odd server problems at the time. If in the GUI, go to LOGINS -> Properties -> Status and make sure they're "enabled" and have permission to connect.

  • On closer inspection it turns out that the SQL login on the problem server was actually a system user group and not a Domain group like on the rest of the servers ...

    Not sure how I pulled that one off : P

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply