Solved

MsSQL Server outside a Firewall. What ports? How to setup?

Posted on 2001-07-10
4
247 Views
Last Modified: 2012-05-04
I'm having problems and I don't want someone to tell me to follow the steps on Microsoft's Support info from:
Q269882
Q238949

I've tried them.
I have a SQL server outside the firewall, it's using it's default 1433 port. There's a port open on the firewall in/out for 1433 and listening on 1024 to 65535.

I use the Connection String in my ASP Page like the example. "Provider=SQLOLEDB;Password=password;Persist Security Info=True;User ID=username;Initial Catalog=DBNAME;Data Source=servername;Network Library=dbmssocn"

I'm using the IP Address for the Servername.
When ever I try Conn.Open line in my ASP I get 'Connection Not Open' error.  So I can't figure out if it's something I have to do on the SQL or what other ports I need to open up on the firewall.

Any ideas how I can get this working?
0
Comment
Question by:Helpdesk
  • 2
4 Comments
 
LVL 3

Accepted Solution

by:
gmoriak earned 175 total points
ID: 6274789
I would suggest to set up an ODBC setting on that machine just to get to the point where you can hit test connection.  If this doesn't work, it is likely to get you more info as to why.  If it does work, the problem isn't getting through the firewall.
0
 
LVL 3

Expert Comment

by:sanjaykp
ID: 6276685
1. Check your SQL Server's client network utility and ensure that it is actually listening on TCP/IP and not named pipes. Although within an intranet, pipes work just fine, through your firewall presumably, only IP packets are allowed through.

2. I'd also drop the 'Network Library=dbmssocn' bit from the connection string, since you are actually indicating to the provider that that is the network library it should use.

Cheers
0
 
LVL 3

Expert Comment

by:sanjaykp
ID: 6276698
To answer the last part of you question, what you are doing is just fine. Actually you can ask your network bods to close every port except 1433 (other than those being used for other applications). This should also be the port indicated in the TCP/IP setup in the netowrk client utility.

0
 

Author Comment

by:Helpdesk
ID: 6281230
Well this ended up working. I setup a DSN connection on the webserver, it's not a normal IIS server, it's actually a Linux server running ChilliSoft which supports ASP, so within the Chillisoft configuration we added the DSN connection and I can connect that way, I perferd to use DSN-less but I'm still working on that. At least it works now thanks.  

The ports ended up working correctly after all.
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

27 Experts available now in Live!

Get 1:1 Help Now