Getting my web application to talk to SQL through the firewall

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

I have my 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

    yes, tht is right...more info you can get in here
    LVL 15

    Expert Comment

    Data Source=MyServer\MyInstance,2000

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    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 set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    746 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

    16 Experts available now in Live!

    Get 1:1 Help Now