Getting my web application to talk to SQL through the firewall

Posted on 2007-09-28
Medium Priority
Last Modified: 2010-03-19

I have my asp.net 2 application sitting on a windows 2003 server trying to communicate through a firewall with a named instance of an SQL 2005 database sitting on another box.

I am being told that my app is trying to go through the firewall on a number of different ports, it seems, fairly randomly. I have found out that I can create a new Alias in SQL 2005 and assign a specific port number in there. For example 8484 and the firewall can then be opened up on this port.

If we say my server name = "SN" and instance name of SQL Server = "IN" then which one of SN or IN should go in the Alias Name field or should it be both (ie Alias Name=SN/IN) ?
In my connection string I have value="SERVER=TCP:SN/IN"   should I then have a ',' after IN to specify port. SO, SERVER=TCP:SN/IN, 8484.

I hope this makes sense. Is this the best way to do it?

Many thanks for any help
Question by:wilfster123
LVL 14

Accepted Solution

Jai S earned 2000 total points
ID: 19977229
yes, tht is right...more info you can get in here
LVL 15

Expert Comment

ID: 21919956
Data Source=MyServer\MyInstance,2000

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

862 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