Solved

SQL 2005

Posted on 2008-10-12
6
333 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 125 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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

828 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