• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 339
  • Last Modified:

SQL 2005

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
winsoftech
Asked:
winsoftech
  • 2
1 Solution
 
Keith AlabasterEnterprise ArchitectCommented:
Please provide the full output of the error lines within the isa log

Keith
0
 
rehan_k99Commented:
check the firewall of server and client as well. if it is on u may have too allow port which you are using
0
 
winsoftechAuthor Commented:
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
 
rehan_k99Commented:
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

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now