September 22, 2010 at 8:30 am
Hello All -
I'm having an issue with an application, in the DMZ, connecting to my SQL Server in the internal network. 1434 UDP is opened and so is the port that the SQL Server is running on. Telnet is successful, but for whatever reason the application is still having troubles connecting. It almost seems as if we're sending the request on the right port, but getting a response from a different port.
Here is the error message:
"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"
I know we can probably figure out what port needs to be opened for the responses, but I'm wondering if there is a way to force the SQL Server to respond on the same port as it is running on?
Any help would be greatly appreciated. Thanks!
September 22, 2010 at 10:09 am
from memory you need port 1434 UDP and TCP. Can you not configure the application with the server name\IP and port number like so
Myserver, 1933
or
192.168.29.28, 1933
Just open the 1933 TCP port and NAT through the firewall to the internal server!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 22, 2010 at 10:17 am
Perry Whittle (9/22/2010)
from memory you need port 1434 UDP and TCP. Can you not configure the application with the server name\IP and port number like soMyserver, 1933
or
192.168.29.28, 1933
Just open the 1933 TCP port and NAT through the firewall to the internal server!
Oh I did that. The data source connection looks like this: Data Source=servername,1433\instancename
September 22, 2010 at 10:41 am
DBAgal (9/22/2010)
The data source connection looks like this: Data Source=servername,1433\instancename
That's wrong, it should be
Data Source=servername,port number
You configure the port number via SQL Server configuration manager and then use the port number in the connection string in place of the instance name not as well as!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply