SQL server DSN issue

A

Ananda

Member
Joined
May 4, 2004
Messages
13
Hello

When I am trying to create a SQL server DSN thru ODBC data source Administrator, I am getting the following error

Connection failed:
slqstate:01000
sqlserver error: 10065
[microsoft][odbc sql server driver][tcp/ip sockets]connectionopen(connect())
connection failed:
sqlstate: 08001
sql server error:17
[Microsoft][ODBC sql server driver][tcp/ip sockets]sql server does not exist or access denied

Can any one tell me the solution for this?

Thanks & Regards
Arunagiri
 
Does the server exist (and turned on)?
Are you attempting to connect with a valid username / password (or valid windows user if using windows authentication)?
What authentication mode is the server using and are you attempting the correct one?
Is there any firewall etc between you and the server that may be blocking the connection?
 
Further Info

Hello

Thanks for your reply. The following are the answers for your queries

PlausiblyDamp said:
Does the server exist (and turned on)?

Yes.

Are you attempting to connect with a valid username / password (or valid windows user if using windows authentication)?

Yes. It is thru SQL server login.

What authentication mode is the server using and are you attempting the correct one?

Please tell me how to find this. Is it SQL server login or windows login authentication? If so our SQL server uses SQL server authentication.

Is there any firewall etc between you and the server that may be blocking the connection?
Click to expand...

Please tell me how to find this one. Because our administrator tells that there is no firewall.

Thanks & Regards
Arunagiri
 
Back
Top