CODEWITHSUNDEEP
sql-serverexternalports
JBT
JBT

Reputation: 11

Connecting to a SQL Server on the Web

My company had a machine running SQL Server hosted by a company specializing in such. We have an .NET application that connects to it.

Recently the decision was made to bring the machine in house.

If we use the internal IP of the machine to connect, it works. When we go to an outside network and use the machine's external IP, it fails. The machine answers pings, and all of the ports in the following article have been opened.

http://support.microsoft.com/kb/287932

Any ideas?

Upvotes: 1

Views: 441

Answers (3)

Darknight
Darknight

Reputation: 2500

Firewalls

I assume you have enabled TCP/IP, and also the SQL Browser Service.

Also I assume if behind a router/NAT, you have done the required Port triggering/Port forwarding.

The final thing would be make sure all firewalls allow SQL Server through.

Upvotes: 0

Don Dickinson
Don Dickinson

Reputation: 6248

are you sure that the server is configured to accept tcp connections? open teh "SQL Server Configuration Manager". "Protocols for MSSQLSERVER" (in the tree) be sure that TCP/IP i set to enabled.

Upvotes: 1

Matthew Dresser
Matthew Dresser

Reputation: 11442

You might need to go to 'SQL Surface Area Configuration', click on 'Remote Connections' in the treeview, then check the 'Local and Remote Connections' radiobutton.

Upvotes: 0

Related Questions