SQL Server error 40 in deployed application (DB in another server)

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!

Re: SQL Server error 40 in deployed application (DB in another server)

what is the problem exactly ?

Is there an exception ?

Re: SQL Server error 40 in deployed application (DB in another server)

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

Re: SQL Server error 40 in deployed application (DB in another server)

you may revise the server parameter in connection string with the name of the server that have the SQL server instance