IIS 5 and 64-bit SQL Server connection problem

  •  We've got Windows 2000 web servers running IIS 5 connecting to massively powerful 64-bit Itanium processor powered SQL Server.

    Unfortunately, connections via MDAC fail in the ASP pages.

    No error message is generated as the connection attempt just times out. Is there an issue with connecting to 64-bit SQL Server via IIS 5?

     

  • This was removed by the editor as SPAM

  • Hello,

    Please describe the connection string. Also, no error  message is posted where? Is it the web page that don't show error message or is it something else?

    You may find helpful http://www.connectionstrings.com

    Try to change the type of connection string: ODBC, OLEDB via TCP/IP, OLEDB via Named Pipes

    Did you try to use Query Analyzer? Can you connect using Enterprise Manager? What is you Client network Utility is set up to: Named Pipes or TCP/IP by default? Did you create Client Network Utility alias?

    Can you connect from VBscript? From MS Access?

    How Firewall is implemented in your company? Ask your network admin check Firewall log for dropped connections.

    Check Server Network Utility what port is used for SQL Server. Check what Protocols are enabled.

    Regards,

    Yelena

    http://heartwalk.kintera.org/bostonma/yelenavarshal

     

     

    Regards,Yelena Varsha

Viewing 3 posts - 1 through 2 (of 2 total)

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