rsbutterfly16
Registered User.
- Local time
- Today, 08:36
- Joined
- Jun 5, 2006
- Messages
- 77
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 domain/'user"
I used in the Data Source set up and tested the connection and I have as WindowsNt authentication using the network login ID from (Access) 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.
things i already checked:
sql server is mixed authentication
odbc conection to sql server database is windows authentication (from access i used the link table option to sql server and created a conection to sql server)
user has read and write access to the sql server database.
user is part of the user group in sql server
Is there anything else to check for?
Thanks in advance.
Connection failed:
SQLState '28000'
SQL Server Error 18456
[Microsoft][ODBC SQLServer Driver][SQL Server]Login failed for domain/'user"
I used in the Data Source set up and tested the connection and I have as WindowsNt authentication using the network login ID from (Access) 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.
things i already checked:
sql server is mixed authentication
odbc conection to sql server database is windows authentication (from access i used the link table option to sql server and created a conection to sql server)
user has read and write access to the sql server database.
user is part of the user group in sql server
Is there anything else to check for?
Thanks in advance.