SQL server error: 1265 and 17

[ForcedToUseIt]

Hi, I have a access 2003 FE and sql server 2000 BE. One user of the database gets the following error message when he tries to connect to the database.

This is probably very simple but i am not figuring it out so please let me know if you have any ideas.

[Edit] The picture is not readable so here is the error message that i get

Connection failed:
SQLState: '01000'
SQL Server Error: 1265
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect()).
Connection failed:
SQLState '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

[/Edit]

 

[SQL_Hell]

Hello,


1.try and ping the server

2. Does user have a vlaid account in sql?

3. is application accidently set to windows authentication

 

[ForcedToUseIt]

Thanks for the reply!

1. I pinged the server and that works like a charm.

2. This particlar user has a valid account in sql DB. This problem is only with this one user.

3. I set up the system so that all users log on using windows authentication. This works for all of my users and I have had no problem with it so far.

Could the problem be, the way that this user connects to the server? If so, how do i change the way he connects to the server.

Thanks for the help, G