Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
krisrajz
Starting Member
19 Posts |
 Posted - 2007-10-04 : 08:44:02
|
| I unable to connect to my MS SQL Server 2000 running on Windows 2003 server.I did try from Query Analyzer and through ASP using SQL-OLEDB.I have opened TCP/IP and UDP ports in firewall.Please let me know the right workaround. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-10-04 : 08:47:34
|
| Which authentication you setup for your SQL Server ?What authentication you are using to connect?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
krisrajz
Starting Member
19 Posts |
Posted - 2007-10-04 : 09:00:19
|
| I have set to both |
|
|
|
AnimalMagic
Starting Member
28 Posts |
Posted - 2007-10-04 : 09:29:43
|
| are you using windows authentication to connect or sql authentication? if your using windows make sure you windows account has server access. Can you connect locally on the server when logged in using the same windows account?You also mention the tcp/ip ports have been opened, is sql sat on the default port of 1433?What error message do you get? |
|
|
|
krisrajz
Starting Member
19 Posts |
Posted - 2007-10-04 : 09:41:00
|
| I am able to login from the local server.I am using SQL AuthenticationI have opened both TCP/IP and UDP through Windows FirewallI got this error message:[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] SQL Server does not exist or access denied |
|
|
|
AnimalMagic
Starting Member
28 Posts |
Posted - 2007-10-04 : 09:59:30
|
| Check on your server network utility (start - programs - sql 2000 - server network utility that TCP/IP is enabledthen do the same check on your client network utility (in the same subfolder)Also check you can ping the server so you know you can resolve the dns name you are trying to connect too from the client. |
|
|
|
krisrajz
Starting Member
19 Posts |
Posted - 2007-10-04 : 10:07:52
|
| TCP/IP is enabledPing to the specific fails. |
|
|
|
AnimalMagic
Starting Member
28 Posts |
Posted - 2007-10-04 : 11:09:40
|
| ok, well its going to be either the route that the ping is trying to go down is incorrect, in which case you can add a route print in command prompt (im assuming your on a seperate subnet to the sql server)You could also add an entry into your hosts file so that the dns name can be resolved. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-04 : 15:39:13
|
| Can you ping the server by ip address? If so, it's naming server isuue. You can just connect to sql with ip address. If can't, means app doesn't have direct connection to sql server. |
|
|
|
|
|
|
SQL Server does not exist or access denied