SQL Server Error: 18456

• Ben Wiens

  Grasshopper

  Points: 17

  More actions

  June 13, 2005 at 4:59 pm

  #88666

  I am getting this error when creating a DSN connection from a client workstation:

  Connection failed:SQLState: '28000'

  SQL Server Error: 18456

  [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'XXX\xxxxx'

   

  Server:

  Windows 2003 Server

  SQL 2000 SP4

  SQL and Windows Authentication

   

  Client:Windows XP SP2

   

  Network:

  All Windows 2003 servers with AD

   

  The issue I am having only happens when I try to use a group when adding permission to the databases. Adding the domain user explicitly works just fine and so does creating a local group on the SQL server and adding the domain user to the group. If I use a global domain group or add a global domain group to the local group, the above error is received by the client.

  Any help is appreciated,

  Ben Wiens

• Paul Hallett

  Grasshopper

  Points: 15

  More actions

  August 19, 2005 at 3:32 am

  #583453

  It's a matter of having orphaned users.

   

  I believe the user may have detached and attached a new database and affected the sysusers table.

   

  see this article:

  http://vyaskn.tripod.com/troubleshooting_orphan_users.htm