DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Connecting to SQL server through firewall

  1. #1
    Join Date
    Apr 2004

    Connecting to SQL server through firewall


    I'm not sure if my connection string is the problem or what. In our shop I had a different division set up a Web Server in our DMZ and a open port through the firewall. We had them open a non standard port for SQL Server (let's say we had them open 5555) and we modified our SQL server (SQL Server 2000) to listen on TCP/IP to 5555

    The Application is written in ASP.Net 2.0 and the connection string is
    "Data Source=xxx.xxx.xxx.xxx,5555;Initial Catalog=dbname;User ID=username;Password=*******;Network Library=dbmssocn"

    Well we keep getting the following error:
    An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)

    I can't connect using a test.udl file
    I can ping the web server from the SQL Server
    I can not ping the SQL Server from the Web Server

    So my questions:

    Is my connection string good and if not what needs to change?

    Do they need to open additional ports?

    I've been googling and searching since 4:30pm yesterday with about 4 hrs of sleep so any help would be met with joy

  2. #2
    Join Date
    Apr 2004
    Nevermind, fixed it...

    I had not opened the port on the SQL Servers own firewall

Similar Threads

  1. query tuning
    By dhaya in forum Database
    Replies: 11
    Last Post: 08-25-2003, 05:24 PM
  2. Replies: 2
    Last Post: 03-05-2001, 03:55 PM
  3. Error connecting to SQL Server 7.0
    By Darcey in forum Database
    Replies: 0
    Last Post: 01-22-2001, 11:29 AM
  4. Replies: 0
    Last Post: 11-20-2000, 06:32 AM
  5. Remove exchange from a site
    By andriano in forum Enterprise
    Replies: 1
    Last Post: 10-02-2000, 03:54 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center