Hi ,
        I have created a ASP.NET 2.0 website. It runs successfully on my local PC with Win XP. But, now i would like to publish the entire website to our dedicated server with SQL server 2000 (serversms2003). i just want to authenticate users using the aspnetdb on serversms2003. But for my web application, i want to use another SQL server 2000 & use dabatbase "bradford" on simsserver.
I ran the steps to create the aspnetdb thru the utility aspnet_regsql on serversms2003.
The problem now is that the website still takes the users from the app_data folder which contains the ASPNETDB.MDF file. I want the application to take users defined in SQL server 2000 on serversms2003. Pls help !!!
My web.config is as : (Note there are some lines with commnents)
<?xml version="1.0" encoding="utf-8" ?>
<!--
    Note: As an alternative to hand editing this file you can use the
    web admin tool to configure settings for your application. Use
    the Website->Asp.Net Configuration option in Visual Studio.
    A full list of settings and comments can be found in
    machine.config.comments usually located in
    \Windows\Microsoft.Net\Framework\v2.x\Config
-->

<configuration >
  <appSettings>
    <add key="CrystalImageCleaner-AutoStart" value="true" />
    <add key="CrystalImageCleaner-Sleep" value="60000" />
    <add key="CrystalImageCleaner-Age" value="120000" />
  </appSettings>
  <connectionStrings>
    <add name="BradfordConnectionString" connectionString="Data Source=simsserver;Initial Catalog=Bradford;Persist Security Info=false;User ID=sa" providerName="System.Data.SqlClient"/>

    <add name="DBConn" connectionString="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=aspnetdb;Data Source=serversms2003" providerName="System.Data.SqlClient" />
  </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.

            Visual Basic options:
            Set strict="true" to disallow all data type conversions
            where data loss can occur.
            Set explicit="true" to force declaration of all variables.
        -->
    <webParts>
      <personalization defaultProvider="AspNetSqlPersonalizationProvider" >
        <providers>
          <remove name="AspNetSqlPersonalizationProvider" />
          <add name="AspNetSqlPersonalizationProvider"
          type="System.Web.UI.WebControls.WebParts.SqlPerson alizationProvider"
          connectionStringName="DBConn"
          applicationName="/" />
        </providers>
      </personalization>
    </webParts>

    <!--<membership>
      <providers>
        <remove name="AspNetSqlMembershipProvider" />
        <add name="AspNetSqlMembershipProvider"
          type="System.Web.Security.SqlMembershipProvider,
           System.Web, Version=2.0.0.0, Culture=neutral,
           PublicKeyToken=b03f5f7f11d50a3a"
          connectionStringName="LocalSQLServer"
          enablePasswordRetrieval="false"
          enablePasswordReset="true"
          requiresQuestionAndAnswer="true"
          applicationName="/"
          requiresUniqueEmail="false"
          passwordFormat="Hashed"
          maxInvalidPasswordAttempts="5"
          minRequiredPasswordLength="7"
          minRequiredNonalphanumericCharacters="1"
          passwordAttemptWindow="10"
          passwordStrengthRegularExpression="" />
      </providers>
    </membership>
    <profile>
      <providers>
       <remove name="AspNetSqlProfileProvider" />
       <add name="AspNetSqlProfileProvider"
           connectionStringName="LocalSQLServer"
           applicationName="/"
           type="System.Web.Profile.SqlProfileProvider,
             System.Web, Version=2.0.0.0, Culture=neutral,
             PublicKeyToken=b03f5f7f11d50a3a" />
       </providers>
    </profile>
    <roleManager enabled ="true ">
      <providers>
        <remove name="AspNetSqlRoleProvider" />
        <add name="AspNetSqlRoleProvider"
           connectionStringName="LocalSQLServer"
           applicationName="/"
           type="System.Web.Security.SqlRoleProvider,
             System.Web, Version=2.0.0.0, Culture=neutral,
             PublicKeyToken=b03f5f7f11d50a3a" />
      </providers>
    </roleManager>-->
    <roleManager enabled="true"/>
    <compilation debug="true" strict="false" explicit="true">
      <assemblies>
        <add assembly="CrystalDecisions.CrystalReports.Engine, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
        <add assembly="CrystalDecisions.ReportSource, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
        <add assembly="CrystalDecisions.Shared, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
        <add assembly="CrystalDecisions.Web, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
        <add assembly="CrystalDecisions.ReportAppServer.ClientD oc, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
        <add assembly="CrystalDecisions.Enterprise.Framework, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
        <add assembly="CrystalDecisions.Enterprise.InfoStore, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
      </assemblies>
    </compilation>
    <pages>
      <namespaces>
        <clear/>
        <add namespace="System"/>
        <add namespace="System.Collections"/>
        <add namespace="System.Collections.Specialized"/>
        <add namespace="System.Configuration"/>
        <add namespace="System.Text"/>
        <add namespace="System.Text.RegularExpressions"/>
        <add namespace="System.Web"/>
        <add namespace="System.Web.Caching"/>
        <add namespace="System.Web.SessionState"/>
        <add namespace="System.Web.Security"/>
        <add namespace="System.Web.Profile"/>
        <add namespace="System.Web.UI"/>
        <add namespace="System.Web.UI.WebControls"/>
        <add namespace="System.Web.UI.WebControls.WebParts"/>
        <add namespace="System.Web.UI.HtmlControls"/>
      </namespaces>
    </pages>
    <!--
            The <authentication> section enables configuration
            of the security authentication mode used by
            ASP.NET to identify an incoming user.
        -->
    <!--
            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>
        -->
    <authentication mode="Forms" >
      <forms name=".ASPXAUTH"
         defaultUrl="login.aspx"
        loginUrl="login.aspx"
        protection="All"
        timeout="30"
        path="/"
        requireSSL="false"
        slidingExpiration="true"
        />
    </authentication>
    <!--<authorization>
            <deny users="?"/>
        </authorization>-->
    <authorization>
      <allow users="*"/>
    </authorization>
    <httpHandlers>
      <add verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
    </httpHandlers>
  </system.web>
  <system.net>
    <mailSettings>
      <smtp from="[email protected]">
        <network host="XX.XX.XX.XX" password="XXXX" userName="[email protected]"/>
      </smtp>
    </mailSettings>
  </system.net>
</configuration>

Same problem here

Add the following to your web.config and it'll pick up from the database you created on Sql Server instead of aspnetdb.mdf.
<connectionStrings>
    <remove name="LocalSqlServer" />
    <add name="LocalSqlServer" connectionString="data source={server address};Initial Catalog={database name};User Id={username};Password={password};" providerName="System.Data.SqlClient"/>
</connectionStrings>

Hope this helps.

Hi there,

You may want to take a look at this article by Scott Guthrie: http://weblogs.asp.net/scottgu/archi...25/423703.aspx

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004