Cannot remotely connect to SQL Server

[riksweeney]

Hi,

I'm trying to connect to my SQL Server. If I login using the Query Analyser then it logs in fine. However, if I try and connect using Query Analyser on another machine, then I get a message saying that it doesn't exist or access is denied. The other problem is that if I try and connect to the server using a java program run locally I get the following:

javax.servlet.ServletException: Cannot get connection to the application database. Check database URL and user credentials

I've been told that the previous user used to block the access somehow but I can't find anything about it. Any ideas?

 

[cheyney]

I assume the server is set to "Windows Only" authentication (if you can get into EM, you can check this by right-clicking on the server, properties, security tab).

In this case, applications will try to use your windows logon credentials to authenticate. I assume you have different credentials on the two computers you're having different results with.

Read "Authentication, overview" in Books Online for more information,

Cheyney

 

[SQLBill]

Is the ODBC connection set up on the other machine?

Is there a firewall involved (check port and/or IP blocking)?

Can you PING the SQL Server from the other machine? (if you aren't familiar with PING, check with your sysadmin)

-SQLBill