All--

Please help.

Why is my application throwing the "SQLExpress database file auto-creation error" after I have removed references to SQLExpress and pointed the code to a duplicate schema in SQL Server 2000?

Here are the details.

I cannot run SQLExpress at my hosting provider. As such, I want to use SQL Server 2000 instead. Therefore, I am seeking to remove all SQLExpress code and files and replace them with SQL2000 code. To that end, I have done the following.

--I have created a new web with the Personal Web Site (PWS) template in Visual Web Developer (VWD) on my local machine.

--I have deleted all of the SQLExpress files from the application.

--I have re-created the database schema in SQL Server 2000, including tables, SPs, and relations.

--I have added new connection string keys to "web.config".

--I have changed the code to call my custom "GetConnectionString()" method as-needed, which returns a valid connection string to my SQL 2000 DB.

--I have run the site locally and it seems to run fine.

--I have copied all files to my live location at my hosting provider, via FTP.

--When I try to load the "Default" page, I get the "SQLExpress database file auto-creation error". (See the ErrorDetails below.)

Why does this happen?

What exactly is causing my application to try to create the SQLExpress database?

Please advise.

ErrorDetails--

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. SQLExpress database file auto-creation error: The connection string specifies a local SQL Server Express instance using a database location within the applications App_Data directory. The provider attempted to automatically create the application services database because the provider determined that the database does not exist. The following configuration requirements are necessary to successfully check for existence of the application services database and automatically create the application services database

--ErrorDetails

FWIW, the current site location is http://site291.mysite4now.com/mkamoski/S15/Default.aspx but that may change.

Thank you.

---

http://www.WebLogicArts.com

Could you post your web.config less any security settings like password and user id's, we might be able to spot your problem.

- Will

---

- William

Give my enhanced version of the PWSK a look.

www.willyd.ca

All--

I found the issue and it was MY fault.

I forgot to flip the switch before I posted my code to the live site to use the ReleaseConnectionString instead of the DebugConnectionString.

I fixed that and now it works fine.

I am sorry about the confusion.

Thank you.

---

http://www.WebLogicArts.com

<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
    <connectionStrings>
        <add name="Sql2000Debug" connectionString="Data Source=localhost; 
        Initial Catalog=MyCatalog;User Id=MyUserId;Password=MyPassword;"/>
        <add name="Sql2000Release" connectionString="Data Source=111.111.111.111;
        Initial Catalog=MyCatalog;User Id=MyUserId;Password=MyPassword;"/>
    </connectionStrings>
    <system.web>
        <pages styleSheetTheme="White"/>
        <customErrors mode="RemoteOnly"/>
        <compilation debug="true"/>
        <authentication mode="Forms">
            <forms loginUrl="Default.aspx" protection="Validation" timeout="300"/>
        </authentication>
        <authorization>
            <allow users="*"/>
        </authorization>
        <globalization requestEncoding="utf-8" responseEncoding="utf-8"/>
        <roleManager enabled="true"/>
        <siteMap defaultProvider="XmlSiteMapProvider" enabled="true">
            <providers>
                <add name="XmlSiteMapProvider" 
                description="SiteMap provider which reads in .sitemap XML files." 
                type="System.Web.XmlSiteMapProvider, System.Web, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" 
                siteMapFile="web.sitemap" securityTrimmingEnabled="true"/>
            </providers>
        </siteMap>
    </system.web>
    <location path="Admin">
        <system.web>
            <authorization>
                <allow roles="Administrators"/>
                <deny users="*"/>
            </authorization>
        </system.web>
    </location>
</configuration>

---

http://www.WebLogicArts.com

All--

FYI, as it turns out, this issue is still present, is a slightly different way.

As of now, the case is that the error message appears when the site is loaded for the 1st time. That is the 1st browser load (always?) causes the error to appear.

However, if one refreshes the browser, then the error message goes away.

Therefore, my orginal questions still stand--

--What is causing the "SQLExpress database file auto-creation error" message?

--What can one do to make this message go away?

Please advise.

Thank you.

---

http://www.WebLogicArts.com