Unable to Access SQL Server 2005 Remotedly

Unable to Access SQL Server 2005 Remotedly

• Kosmo007

  HI Vinodonly, sorry to bug you, but I need your help.

  I have sonicwall firewall and I am trying to open my sql server 2005 to the internet.

  I am not familiar at all with sonicwall, is it possible for you to walk me through this process

  How do I assign an external IP to sql server

  Thanks in advanced.

  
  

• Bob Rossi

  Thanks for your reply..

  Kindly note it is already enabled under my named instance, option set is

  Local & Remote Connections

  & Using both TCP/IP & named pipes.

  This was set many days before and i have restrated server many times after that...

  pls advs..

  
  

• sm0g

  You can't configure the instance to use 1433, as the default instance (your 2000 instance) uses 1433. And the TCP Dynamic Ports setting is dynamic when set to 0, you need to delete the 0, then put a different port in for the TCP Port.
  
  

• giba7

  actually even that is set...

  in configuration manager->in tcp/ip(enabled)->Ip Addresses

  i have 2 IP Addresses given

  One is the local address

  & other one is the live IP Address,

  local address is not enabled but live ip address is enabled and active, dyanmic port is 0 and tcp port is 1433 (this is in IP2) but still it is not working.

  any other suggestions.

  
  

• Lawrence 007

  Since you don't specifically mention it, I have to ask this first: Have you checked the Surface Area Configuration to make sure that you have Remote Connections enabled It is located in All Programs, Microsoft SQL Server 2005, Configuration Tools, and then click SQL Server Surface Area Configuration.

  Under Services and Configuration, enable remote connections. You may have to restart the service, based on what Jens says here: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=810821&SiteID=1

  
  
  

• Xengor

  i can't access my web application from remot computer

  i m getting error :40 named pipe req. remote access not allowed.

  i m using sql server 2000 for data base but on accessing my aplicaton on remote

  i m getting error for 2005 sql server which i have never used in my application

  i m using vs.net 2005 for my application development

  so can anyone give me solution

  
  

• Frank2808

  I figured so, and should have read closer. SQL Server communicates on port 1433 for the default instance only. The other instances are assigned a port dynamically, but you can set a fixed port using the SQL Server Configuration manager.

  Search for: "Connecting to SQL Server over the Internet " in bol for more information.

  
  
  

• Bailey*

  Just so we're clear, your application is hosted on a different server to your sql 2000 db and you are having trouble accessing the DB from the app

  What connection string are you using (It might be nothing to do with this but its worth checking!)

  Also you mentioned getting a sql 2005 error - what does it say

  
  

• NozFx

  Unfotunately and surprisingly, i'm still not able to solve this. Even if i'm able to open IP address on sonicwall, still ISA is blocking so still the IP is not getting routed to SQL server.

  For the time being, i'm using VPN as an alternative.

  If i get any solution, i will post it here.

  
  

• CSharpDeveloper

  I had the same TCP Provider, error 0 problem and having spent about 3 hours trawling the InterWeb I eventually found out I simply had to add port 1433 to the windows firewall exceptions list!
  

• RPagels

  i can't access my web application from remote computer

  i m geeting error :40 named pipe req. remote access not allowed

  i m using sql server 2000 for data base

  but i m getting error for sql server2005 error which i have never used in my application

  i m using vs.net 2005 for my application development

  so can anyone give me a solution

  
  

• Heathorn Hawk

  i'm still checking on this. i have changed the port now to 1434 and changed in all places.

  my connection string is also changed now, so now i'm using :- MYIP\MYSERVER,1434

  now i'm getting a different error msg

  {"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)"}

  this can also be due to firewall or something else is blocking it, i will rechk n post back final answer.

  
  
• Unable to Access SQL Server 2005 Remotedly