errror when user tries to connect to SQL server with access

[miscluce]

Connection failed:
SQLState '28000'
SQL Server Error 18456
[Microsoft][ODBC SQLServer Driver][SQL Server]Login failed for domain/'user"

Can someone tell me how to give access to fix this or know where there is a website that has instructions?

I can connect to it fine but other users cant?

I have an access 2003 project that connect to a SQL DB?

 

[PHV]

Have a look here:

http://www.connectionstrings.com/

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[miscluce]

thanks for the reply but there is nothing wrong with the connection. I cant connect or should I say logon using the ODB (data source)to the SQL server fine.

Other people can't logon using the ODBC data source.

 

[dhookom]

Do all users have the correct permissions?
Do all users have the appropriate ODBC/DSN created and tested?

Duane
Hook'D on Access
MS Access MVP

 

[miscluce]

This is actually my problem "Do all users have the appropriate ODBC/DSN created and tested? "

I know they have the correct version (2.8). It has something to do with the permissionsin SQL which I dont know which object to add. It looks like I have all the objects added with the correct permissions such as the NT authority object, etc.

 

[dhookom]

I don't do much with ADPs but expect each user needs to have the same dsn that identifies how/where to connect to your database.

Duane
Hook'D on Access
MS Access MVP