SQL Server Error 18456

  • Thread starter Thread starter rsbutterfly16 via AccessMonster.com
  • Start date Start date
R

rsbutterfly16 via AccessMonster.com

I'm running an Access 2000 Database on Windows 2000. The Access Database
links to SQL Server 2000 tables. The error occurs when the users login with
their windows login (my sql server is mixed authentication) and open the
database to open the tables or forms. The connection will fail with the
following:

Connection failed:
SQLState '28000'
SQL Server Error 18456
[Microsoft][ODBC SQLServer Driver][SQL Server]Login failed for
user 'xy'.





I used in the Data Source set up and tested the connection and I have as
WindowsNt authentication using the network login ID. All these users are in
added to sql server as users for these database using windows authentication.


The users belong to the group in sql server "users" , when i add the
"administrator" group to their login then they can login without anyproblems
but for obvious security reasons i have to take them out of the
administrator's group.

Is there anything else to check for?

Thanks in advance.
 
rsbutterfly16 said:
I'm running an Access 2000 Database on Windows 2000. The Access Database
links to SQL Server 2000 tables. The error occurs when the users login with
their windows login (my sql server is mixed authentication) and open the
database to open the tables or forms. The connection will fail with the
following:

Connection failed:
SQLState '28000'
SQL Server Error 18456
[Microsoft][ODBC SQLServer Driver][SQL Server]Login failed for
user domain/xy'.
Click to expand...

domain being my sql server database name , xy being the user login
I used in the Data Source set up and tested the connection and I have as
WindowsNt authentication using the network login ID. All these users are in
added to sql server as users for these database using windows authentication.

The users belong to the group in sql server "users" , when i add the
"administrator" group to their login then they can login without anyproblems
but for obvious security reasons i have to take them out of the
administrator's group.
Click to expand...

things i already checked:
sql server is mixed authentication
odbc conection to sql server database is windows authentication
user has read and write access to the sql server database.
user is part of the user group in sql server
 
Back
Top