Connecting to a remote SQL Server in WinXP SP2
-
I have a problem to connect to a remote SQL Server in WinXp SP2. The error is "SQL Server does not exist or access denied". I've done almost all of the solutions that are recommended in Microsoft support service. I added sqlservr.exe program into the exception list of firewall included with XP SP2. I added 1433 (TCP) and 1434 (UDP) ports into that exception list as well. Even I disable XP SP2 firewall. but I got the problem again. Finally I installed SQL Server Service Pack 3a but unfortunately the problem is still exist. I really don't know what should I do after doing all of the above tasks. Is there anybody here who can solve this problem? Thank you in advance.
-
I have a problem to connect to a remote SQL Server in WinXp SP2. The error is "SQL Server does not exist or access denied". I've done almost all of the solutions that are recommended in Microsoft support service. I added sqlservr.exe program into the exception list of firewall included with XP SP2. I added 1433 (TCP) and 1434 (UDP) ports into that exception list as well. Even I disable XP SP2 firewall. but I got the problem again. Finally I installed SQL Server Service Pack 3a but unfortunately the problem is still exist. I really don't know what should I do after doing all of the above tasks. Is there anybody here who can solve this problem? Thank you in advance.
---Check if there is a program uses the Same ports ---Check Your Domain Account when you Try to Connect to the Server ---Try to Connect by IP address not the DNS ---check the Secury Setting in the SQL server ---Check if the Server has a firewall that prevent you from Connect ---Norton Firewall ...? agmb
-
I have a problem to connect to a remote SQL Server in WinXp SP2. The error is "SQL Server does not exist or access denied". I've done almost all of the solutions that are recommended in Microsoft support service. I added sqlservr.exe program into the exception list of firewall included with XP SP2. I added 1433 (TCP) and 1434 (UDP) ports into that exception list as well. Even I disable XP SP2 firewall. but I got the problem again. Finally I installed SQL Server Service Pack 3a but unfortunately the problem is still exist. I really don't know what should I do after doing all of the above tasks. Is there anybody here who can solve this problem? Thank you in advance.
How does the connection string looks like...? note that the SQL-server supports several instances and that that might be a peoblem if the instance nto is specified... /M