Microsoft Data Link Error

Dear All!

I use a Microsoft SQL server 2005 under windows 2000, and I would like to connect to this server from an another windows 2000 computer under Access 2003.

When I click to test connection buttom, I get an error mesige: "Test connection failed because of an error in initializing provider. Login faild user 'raktaros'. The user is not associated wth a trusted SQL server connection."

The 'raktaros' is a user on the server computer.

Please help me, what is the problem.

Best regards,

Labi

Is he a SQL Server user or just a windows local user on the server.

The latter won't work, the former will if the security mode of the SQL Server is set to SQL Server and Windows using the Properties of the Server in Object Explorer on the security section

|||Your SQL Server is setup for WIndows Authentication. If you use this you are not able to use SQL Server Authentication anymore, nor passing the user parameter within the connection process.

HTH, jens Suessmeyer.