Post reply

SETUSER permission denied in database ''Inovsoft''.

  • February 21, 2006 at 6:34 am

    #111695

    Hi All,

             I have made a new database whose name is Inovsoft in which a username is Inovsoft and password is Inov123.I have copied the stored procedure list from our other database Dundas in which a username is admdund so I have replace admdund to Inovsoft and trying to execute the script for stored procedures.But it shows me "SETUSER permission denied in database 'Inovsoft'." error.Please help me it is an urgent issue for me.

            Million of thanks in advance.

    Manutosh

  • February 21, 2006 at 7:00 am

    #622253

    Hello Manutosh,

    Can you check up "sp_change_users_login" in the Books Online. It might give you the idea.

    Thanks and have a nice day!!!


    Lucky

  • February 23, 2006 at 11:36 am

    #623027

    SETUSER is included for backward compatbility in SQL 2K5. BOL states you should use ECECUTE AS instead.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • January 3, 2007 at 9:47 am

    #680989

    Hi I came across this problem today.

    Try adding the account used in the data source to the sysadmin role.

    Any SQL account that is configured in a data source that is being used by a report model, must be a member of the sysadmin role, this seems rubbish but heh....

    More info here:

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

     

     

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

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