Cannot connect to SQL Server

  • Hi good people,

    We have web application that connects to SQL Server 2008 using this connection string:

    connectionString="Data Source= ;"

    Web application and SQL Server are on a different machines that are on VPN. I have no problems to ping or telnet SQL server from application server, but my web application doesn’t want to connect.

    Seems to me a connection string issue, but have no idea what is it.

    Thank you very much,

    John

  • What errors do you get when connecting to server in your web application?

    Can you able to connect to SQL Server using SSMS from application server?

    --Ramesh


  • Hi

    If you don't have SSMS on your web server try this (sounds strange but works 😉 ):

    * Create a new, empty "Text File" in explorer. Rename the file from ".txt" to ".udl" so the file becomes "Microsoft Data Link" file. Double click and a connection dialog opens.

    * Switch to first tab and select either "Microsoft OLEDB Provider for SQL Server" if you work with OLEDB or "SQL Server Native Client x.x" if you use this connection type.

    * Switch to second tab and enter your connection information server/database/ "userid/password"/"windows authentication".

    * Click "Test Connection" to verify if it works.

    * If you entered user-name and password ensure that "Allow Saving Password" check box is not checked! If you check this the information will be written plaintext into the file!

    This is only a test if the problem is within your web application or the network between.

    If this also fails check if port 1433 (usually) is open in firewalls.

    Good luck!

    Flo

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

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