locked
sp_migrate_user_to_contained returns error RRS feed

  • Question

  • I planned to migrate my database (SQL Server 2012) to a contained database as given in this link: http://msdn.microsoft.com/en-us/library/ff929139.aspx

    After doing that my web service can go longer retrieve the data from the database. (I am getting denied here).

    The Web Service uses SQL user and password to access the database. I manually tried to add this user to the contained database as follows:

    sp_migrate_user_to_contained 
    @username = N'TestUser',
    @rename = N'keep_name',
    @disablelogin = N'do_not_disable_login' ;

    I get the following error:
    sp_migrate_user_to_contained can not be used with a user with a password or a user type other than SQL Login

    The user was created by right clicking on "Users" node under "Security" and user type SQL user with password

    Any idea what is going wrong here ? I  want to get this migration done without modifying anything in the web service config files






    • Edited by Shawn Dan Tuesday, October 30, 2012 4:52 AM
    Tuesday, October 30, 2012 4:33 AM

Answers