Post reply

Not able to Access Database

  • October 15, 2010 at 5:58 am

    #1237450

    your login is not synced with the old 2000 DB.

    you can access the 2000 DB by either using you current 2008 sa or any login that is a sysadmin.

    OR

    you can sync the logins from the 2000 database into your 2008 server using sp_help_revlogin.

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

  • October 16, 2010 at 6:52 am

    #1237987

    Geoff A (10/15/2010)

    your login is not synced with the old 2000 DB.

    you can access the 2000 DB by either using you current 2008 sa or any login that is a sysadmin.

    OR

    you can sync the logins from the 2000 database into your 2008 server using sp_help_revlogin.

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

    Hi Geof,

    But in sql 2008 envy sa password already set. in sql 2000 sa password is blank.

    And also when i'm going to run the script result in sql 2008.. its shows SID is already in use

    In that case what i can do...

    Kindly help me

    Thanks

    Balaji.G

Viewing 2 posts - 1 through 3 (of 3 total)

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