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