Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2001-07-10
4
Medium Priority
?
254 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 3

Accepted Solution

by:
gmoriak earned 700 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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

636 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