I have a Windows Server 2003 Std as my IIS Server. In that server I've deployed a web application. This machine is not under a domain.
I have a Windows Server 2008 R2 as my DB Server, it has a SQL Server 2005. This machine is not under a domain.
I made all the configurations to my SQL Server recomended and to the SO (Checked the ports, firewall exceptions, protocols).
In the development machine I can connect to the DB server without problems. Launching the application from VS I can work with it and I have no trouble with it.
The problem is from the IIS.
Can you help me with my problem? Thanks in advance!
Read this article, i want you to check your connection string parameters out of the application and check that it is correct and ports are accessible and every thing is ok
JuanPa_EC
0 Points
1 Post
SQL Server error 40 in deployed application (DB in another server)
Feb 08, 2012 05:12 PM|LINK
Hi experts!
I have a Windows Server 2003 Std as my IIS Server. In that server I've deployed a web application. This machine is not under a domain.
I have a Windows Server 2008 R2 as my DB Server, it has a SQL Server 2005. This machine is not under a domain.
I made all the configurations to my SQL Server recomended and to the SO (Checked the ports, firewall exceptions, protocols).
In the development machine I can connect to the DB server without problems. Launching the application from VS I can work with it and I have no trouble with it.
The problem is from the IIS.
Can you help me with my problem? Thanks in advance!
Muhammad Fak...
Contributor
2268 Points
511 Posts
Re: SQL Server error 40 in deployed application (DB in another server)
Feb 08, 2012 05:23 PM|LINK
what is the problem exactly ?
Is there an exception ?
If you feel it helps, Mark as answered so that it can help others to find solution.
For Any further questions, please contact me.
Muhammad Fak...
Contributor
2268 Points
511 Posts
Re: SQL Server error 40 in deployed application (DB in another server)
Feb 08, 2012 05:27 PM|LINK
Dear Juna
Read this article, i want you to check your connection string parameters out of the application and check that it is correct and ports are accessible and every thing is ok
http://blogs.msdn.com/b/farukcelik/archive/2007/12/31/basics-first-udl-test.aspx
If you feel it helps, Mark as answered so that it can help others to find solution.
For Any further questions, please contact me.
Muhammad Fak...
Contributor
2268 Points
511 Posts
Re: SQL Server error 40 in deployed application (DB in another server)
Feb 08, 2012 05:29 PM|LINK
you may revise the server parameter in connection string with the name of the server that have the SQL server instance
If you feel it helps, Mark as answered so that it can help others to find solution.
For Any further questions, please contact me.