Hello,

I am having the problem with accessing database.

It works fine on my development machine.But When i deployed it to a production server which is in DMZ,I am getting the following

error.

An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server).

My web.config file is

<configuration>
    <appSettings>
        <add key="ConnectionString" value="server=vvvv;database=DBTest;uid=sa;password=yyyyy;"/>
    </appSettings>
    <connectionStrings/>

<authentication mode="None">
        </authentication>
        <authorization>
            <allow users="*"/>
        </authorization>

vvvv  is an intranet server where i kept the database.

My question is what do i need to change in the  web.config inorder to access the application even though it is in DMZ.

refer this

http://www.connectionstrings.com/sql-server-2005

find which connection string works for u

I tried by adding Trusted_Connection = True

and even Integrated Security= SSPI;

But nothing is working for me.

Please suggest me as the application is in DMZ.

Thanks

I usually use something like this in my Web.config:

<connectionStrings>

<add name="ConnectionString" connectionString="Data Source=12.34.56.78;Initial Catalog=DB_Name_Here;UID=User_ID_Here;Password=Password_Here;providerName="System.Data.SqlClient"/>

</connectionStrings>

yeah..it is working fine now...Thanks guys