SQL Server Performance

SQL Server 2000 to 2005

Discussion in 'SQL Server 2005 General DBA Questions' started by mazher_yasin, Aug 12, 2008.

  1. mazher_yasin New Member

    I have to genrate a Store procedures script from SQL sever 2000 when i try to execute these script on Sql Server 2005 it gives the following Error "Msg 15157,Setuser failed because of one of the following reasons: the database principal 'nust' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you do not have permission.
    "
    mazher_yasin, Aug 12, 2008
    #2

  2. Luis Martin Moderator

    Welcome to the forum!.
    Could you provide the following information:
    1) Databases names in 2000.
    2) Databases names in 2005.
    3) Your script.
    Luis Martin, Aug 12, 2008
    #3

Share This Page