Post reply

Upgrading from sql 2000 to sql 2005 problem

  • November 24, 2010 at 7:26 am

    #241587

    hello,

    i'm doing upgrade from sql 2000 to sql 2005, i run the upgrade advisor and got in the report this problem 'rename logins matching fixed server role names' and the affected objects is SYSADMIN login.

    i followed the steps shown in how to resolve it :

    1- recored the SID

    2- drop the logins, got error "server: Msg 15175, Login 'sysadmin' is aliased or mapped to a user in one or more database. drop the user or alias before dropping the login"

    can anyone help me on this issue please.

    thanks

  • November 24, 2010 at 8:03 am

    #1255115

    i think instead of this, you need to script out all user and run the script on 2005.

    Follow this link for generating script for login transfer:-

    http://support.microsoft.com/kb/246133

    ----------
    Ashish

  • November 25, 2010 at 12:13 am

    #1255454

    I run the scripts and found it stored in the master db then i run the sql 2005 to upgrade but the upgrade blocked because of that use SYSADMIN.

    there is no anyway rename the login SYSADMIN.

    please this urgent and i'm new with SQL.

    thanks

  • November 25, 2010 at 2:36 am

    #1255478

    hany_amien (11/24/2010)

    i followed the steps shown in how to resolve it :

    1- recored the SID

    2- drop the logins, got error "server: Msg 15175, Login 'sysadmin' is aliased or mapped to a user in one or more database. drop the user or alias before dropping the login"

    Before dropping the login you must drop the user mapped to that login from the databases. Drop the user (SYSADMIN) from databases using the UI or sp_dropuser.

    Example:

    use master

    go

    select sid, cast(password as varbinary(2000)) from dbo.syslogins where name = 'SYSADMIN'

    0xF49847D03ECF224C9AE292AC20D958700x01008E5C582912C13C96B3EFB6DCEDCED53AE34C7B81448EF436CF12869CDE53F92F2B83144DC5FA81DD925E2599

    use <dbname>

    go

    sp_dropuser SYSADMIN

    go

    use master

    go

    sp_droplogin SYSADMIN

    go

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply