Post reply

permissions went missing after MSSQL instance migration

  • September 7, 2016 at 9:23 pm

    #329820

    I performed migration from MSSQL2005 to MSSQL2012 and permissions have been already synced as part of prework but users are now complaining that one login is not able to delete a Stored procedure on one database . When I check all db level permissions , server level permissions are intact what else I need to check ? is it because of some issues with application roles when we migrate versions of SQL server . Please guide . This has been encountered earlier as well . Thanks Geeks

  • September 8, 2016 at 2:40 am

    #1899711

    Probably a difference in the login identifiers between the databases caused the login and the database user to become disconnected. Take a look at this article for how to resolve the out of sync sid values.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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