Solved

SQL 2005

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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Moving RDP Server to New Server. 3 56
server DNS address could not be found 22 191
sccm client without collection 1 55
Problems with Microsoft.DHCP.PowerShell.Admin Module 4 56
On a regular basis I get questions about slow RDP performance, RDP connection problems, strange errors and even BSOD, remote computers freezing or restarting after initiation of a remote session. In a lot of this cases the quick solutions made b…
On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

810 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