Post reply

SQL Server 2008, IIS7 and Windows server2008

  • February 8, 2010 at 8:20 am

    #216494

    Hi,

    I have a Windows server 2008 and on that I have SQL Server2008 and IIS7 installed.

    In IIS7 I have a website installed that gets it's login information from the sql database.

    The website connects to this database server with the IP of the windows server, the name of the database, login name and password.

    The problem is that the website cannot get connected to the database.

    Firewall: TCP 1433 is open, UDP1434 is open

    SQL Server: Allow remote conntections is on, in tcp/ip protocol the IP en port is set to the server IP and 1433. Also on AllIP is set to 1433

    The username and password for the database are set, Sql Management is working and connecting.

    I tried Telnet ip 1433, but it does not connect. Not on the server nor outside the server.

    I tried Telnet 127.0.0.1 1433, but also no connection.

    The website is reachable but it gets stuck on the connection with the sql server.

    How can I solve this?

    Did I do something wrong?

    Did I forget something?

    Please help.

    rg,

    Eric

  • February 8, 2010 at 8:43 am

    #1115555

    Do you see anything in your error log?

    -Roy

  • February 8, 2010 at 8:46 am

    #1115559

    Hi,

    I managed the get it working by using the localhost ip instead of the server ip.

    The only problem I have now is connecting from outside the server by it's IP.

    That is still not working.

    Tried it with and without firewall, but no luck.

    Anyone has any suggestions?

    rg,

    Eric

  • February 8, 2010 at 9:04 am

    #1115581

    If the connection is being refused at the database level you will see the error details in the error log of the DB.

    Also check Select @@servername and see if the DB name matches with the DB Server name.

    -Roy

  • February 8, 2010 at 9:29 am

    #1115607

    In IIS 7 check the connection string definition I have had issues with IIS adding SQL Server Express connection string to the one you defined. You also need to make sure the Asp.net runtime have the relevant permissions.

    Kind regards,
    Gift Peddie

  • February 8, 2010 at 9:39 am

    #1115612

    Hi,

    Thanks for the help.

    Problem is solved.

    Company firewall was blocking.

    Using SSH gives me the possibility to communicate with the server from my applications.

    rg,

    Eric

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply