migrating SQL2005 to SQL2008 problems

Discussion in 'Databases' started by brea245, May 7, 2009.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Hi, I recently migrated my DASP account from SQL2005 to SQL2008 I followed this instruction for my membership and roles in Web Admin Tool the following message may help in diagnosing the problem:
    Login failed for user 'SQL2008_459863_ns2509_user'.
    and I thought I followed these instuctions but when I query database I get this:

    Server Error in '/' Application.
    ------------------------

    Object reference not set to an instance of an object.

    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.

    Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

    Source Error:


    Line 1556: private void InitConnection() {
    Line 1557: this._connection = new global::System.Data.SqlClient.SqlConnection();
    Line 1558: this._connection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["authorConnectionString"].ConnectionString;
    Line 1559: }
    Line 1560:


    Source File: c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\4a768cc8\13ff178f\App_Code.doms-3ew.0.cs Line: 1558

    When I view my SQL 2008 account the restore tool didn't work because the SQL 2008 'usage meter' is still at zero compared to my SQL 2005 'usage meter'. I use VWD 2008 and my 'explorer database' sees my SQL 2005 database intact. My other problem is the connectionstrings in my web.config is:
    <connectionStrings>
    <
    removename="LocalSqLServer"/>
    <
    addname="LocalSqlServer"connectionString="Data Source=tcp:sql2k801.discountasp.net;Initial Catalog=SQL2008_459863_ns2509;User ID=SQL2008_459863_ns2509_user;Password=******"providerName="System.Data.SqlClient"/>
    </
    connectionStrings>


    I have discontinued my SQL2005 account is there a way to solve these problems???
     
  2. corrected roles & membership see next post>

    frustration in not seeing my database
     
  3. Did you run the 'aspnet_regsql.exe' command against our SQL server? This is the first step in setting up Membership/roles provider on our servers.
     
  4. Bruce

    Bruce DiscountASP.NET Staff

    This error means that you are using the wrong password.
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page