Hi,
My application has accessing data from a remote database server .
My connection string is defined in web.config as follows
[B]<appSettings>
    <add key="ConnectionString" value="data source=DEVSVR;initial catalog=DEInsdata;user id=sa;"></add>
  </appSettings>[/B]
Whenever I am running the application from VS.NET 2005 it runs fine but when I run application from IE the application never run and there is a message [B]sql server 2005 does not allow remote connections[/B] and the most surprising thing is that my database is SQl SERVER 2000 so I am really confused with this error message.
Kindly help me

Actually I am not doing anything with SQL Server 2005. All my tables , views , SP s are in SQL Server 2000. So I've only one connection string in my web.config which is pointing to our database server. I failed to understand why this error is coming

Hi Chris,

Yes, all the table in sql server 2000

Below is my web.config file.

And kindly look the highlighted portion. It's the connection string.

<?xml version="1.0"?>
<!-- 
 -->
<configuration>
  <appSettings>
    <add key="ConnectionString" value="data source=DEVSVR;initial catalog=DEInsdata;user id=sa;"></add>
  </appSettings>
 <connectionStrings/>
 <system.web>
  <!--
            Set compilation debug="true" to insert debugging
            symbols into the compiled page. Because this
            affects performance, set this value to true only
            during development.
        -->
  <compilation debug="true"/>
  <!--
            The <authentication> section enables configuration
            of the security authentication mode used by
            ASP.NET to identify an incoming user.
        -->
  <authentication mode="Windows"/>
  <!--
            The <customErrors> section enables configuration
            of what to do if/when an unhandled error occurs
            during the execution of a request. Specifically,
            it enables developers to configure html error pages
            to be displayed in place of a error stack trace.

        <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
            <error statusCode="403" redirect="NoAccess.htm" />
            <error statusCode="404" redirect="FileNotFound.htm" />
        </customErrors>
        -->
 </system.web>
</configuration>

#But, DNN has two connection strings in the Web.config file. I'd be willing to bet that the other one is still setup to use SQL Express and that's why you're getting your problems.

Could you please little bit precise about this?(I am copying my web.config below for your convenience)

##In your SQL2000 database are there any tables?