Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL 2005

Posted on 2008-10-12
6
Medium Priority
?
338 Views
Last Modified: 2008-12-06
I want to connect SQL 2005 DB of another network over vpn. All the required setting like remote connection using TCP/IP only, SQL browser setting automatic and configured allow port through ISA server but still getting an error like error no: 53, serverity error :20 .
0
Comment
Question by:winsoftech
  • 2
6 Comments
 
LVL 51

Expert Comment

by:Keith Alabaster
ID: 22700585
Please provide the full output of the error lines within the isa log

Keith
0
 
LVL 1

Expert Comment

by:rehan_k99
ID: 22700623
check the firewall of server and client as well. if it is on u may have too allow port which you are using
0
 
LVL 1

Author Comment

by:winsoftech
ID: 22700691
I think no issue on ISA server (0x0 Error_Success  then afer some time gives result 0xc0040038 FWX_E_TCP_NO_SERVER_REPLY) while on SSMS (Provider: Named Pipes Provider : error 40 could not open connection  to server, Microsoft SQL Server : error 53)
0
 
LVL 1

Accepted Solution

by:
rehan_k99 earned 500 total points
ID: 22700962
check your named pipe connection using
c:\windows\system32\cliconfg.exe
please also check this
hope will help to resolve the error
http://blogs.msdn.com/sql_protocols/archive/2007/03/31/named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server.aspx
my another suggesting
Most of the time cause is firewall on SQL Server machine is blocking port 1433
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have been asked to explain on many, many occasions the correct way to setup network cards and DNS settings on ISA Server 2004, 2006 and forefront Threat management gateway (FTMG) and have willing done so. I have also promised my self everytime tha…
Learn about cloud computing and its benefits for small business owners.
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

927 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question