Solved

SQL 2005

Posted on 2008-10-12
6
335 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

Some time ago I faced the need to use a uniform folder structure that spanned across numerous sites of an enterprise to be used as a common repository for the Software packages of the Configuration Manager 2007 infrastructure. Because the procedu…
Know what services you can and cannot, should and should not combine on your server.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses

627 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