March 13, 2009 at 3:24 pm
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
March 14, 2009 at 6:04 am
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
April 10, 2009 at 10:06 am
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy