Remote access problem - sql server2008- Out of Domain
-
For my project, I have setup a small domain, and arranged a LAN connection. From my domain, when I connect with my Sqlserver 2008 remotely It's connected, no problem.And the application is running good. But when I run the program, out of domain not in LAN, it's not connecting with my sql server and showing the error, "A network-related or instance-specific error occurred while establishing a connection to sql server......(provider; Named pipes provider, error: 40- could not open a connection to sql server). Iam using the followings as connection string Dim ConStr As String = "Data Source=1.1.1.1; initial Catalog=Employee_Master; User Id=Codeproject; Password=xxxxxxxx" It's cnnecting under LAN, but not from remote machines. Any ideas to fix this problem ?
-
For my project, I have setup a small domain, and arranged a LAN connection. From my domain, when I connect with my Sqlserver 2008 remotely It's connected, no problem.And the application is running good. But when I run the program, out of domain not in LAN, it's not connecting with my sql server and showing the error, "A network-related or instance-specific error occurred while establishing a connection to sql server......(provider; Named pipes provider, error: 40- could not open a connection to sql server). Iam using the followings as connection string Dim ConStr As String = "Data Source=1.1.1.1; initial Catalog=Employee_Master; User Id=Codeproject; Password=xxxxxxxx" It's cnnecting under LAN, but not from remote machines. Any ideas to fix this problem ?
Two things I would check are if you have a firewall, if the proper ports are open (1433). Other would be if the sql server is listening on 1433 on a public IP address and internal address. Byron Mann mannb@hostmysite.com byronosity@gmail.com Software Architect hosting.com | hostmysite.com http://www.hostmysite.com/?utm\_source=bb
-
Two things I would check are if you have a firewall, if the proper ports are open (1433). Other would be if the sql server is listening on 1433 on a public IP address and internal address. Byron Mann mannb@hostmysite.com byronosity@gmail.com Software Architect hosting.com | hostmysite.com http://www.hostmysite.com/?utm\_source=bb
Hi, Sorry. Iam zero in this Sql Servers. This my first Project. So can you explain a bit more. 1.Yes. I have a firewall. But how can i understand my ports are open 1433? Any commands....? 2.How can i check my Sqlserver is listening on 1433 on public IP address and internal address.. Can you provide any sample commands? Thanks
-
Hi, Sorry. Iam zero in this Sql Servers. This my first Project. So can you explain a bit more. 1.Yes. I have a firewall. But how can i understand my ports are open 1433? Any commands....? 2.How can i check my Sqlserver is listening on 1433 on public IP address and internal address.. Can you provide any sample commands? Thanks
From the server access SQL outside your local network, to tell if the outside server can connect to the port. From the command line ->telnet SqlServerHostname 1433 If it connects it will blank screen. Hit ctrl+] to escape; otherwise it will just sit there "Connecting to sqlserverhostname" and eventually time out and return you to the command prompt. On the sql server from the command line issue this command >netstat -an sift through the list and look for this in the second column PublicIP:1433 208.208.208.208:1433 for example, that first column is the ip and ports your server is listening on.
-
For my project, I have setup a small domain, and arranged a LAN connection. From my domain, when I connect with my Sqlserver 2008 remotely It's connected, no problem.And the application is running good. But when I run the program, out of domain not in LAN, it's not connecting with my sql server and showing the error, "A network-related or instance-specific error occurred while establishing a connection to sql server......(provider; Named pipes provider, error: 40- could not open a connection to sql server). Iam using the followings as connection string Dim ConStr As String = "Data Source=1.1.1.1; initial Catalog=Employee_Master; User Id=Codeproject; Password=xxxxxxxx" It's cnnecting under LAN, but not from remote machines. Any ideas to fix this problem ?
Use TCP/IP Provider instead of named pipes. Regards, Aman