Super User question MDS 2012 RRS feed

  • Question

  • I prepare SQL Server 2012 to 2017 migration including MDS 2012 to 2017.

    In our 2012 MDS database I did not pay attention to the 1. administrator user. The user belonged to a domain "olddomain" that is no longer available. So I used the 

    EXEC [mdm].[udpSecuritySetAdministrator] @UserName=@v_UserName, @SID = @v_SID, @PromoteNonAdmin = 1; 

    Stored Procedure to change the Administrator. The new administrator belonging to "newdomain" has got the ID = 1 in mdm.tblUser and the record for the old administrator has been deleted. Seems to me the change was successful. But the new Administrator has not assigned the "Super User" function in MDS 2012 as I can see in Web Interface user administration.

    I also restored an MDS 2012 database backup (before Admin change!!) to SQL Server 2017 and after upgrading the database schema there was still the olddomain Administrator in the users list and he has assigned the "Super User" function (and several other functions). 

    As of my knowledge the [mdm].[udpSecuritySetAdministrator] SP is not available in MDS 2017 so I have to change the Super User in MDS 2012 but after that the new Administrator has no Super User function assigned in MDS 2012. 

    Can anyone tell me how to migrate the MDS from 2012 to 2017 including change of the Super User to have a user with this function available in MDS 2017 after migration?

    THX a lot for any help.

    Thursday, May 9, 2019 9:52 AM

All replies

  • I found the solution by myself.

    I backed up the MDS 2012 database (with Administrator from newdomain), restored in MDS 2017, migrated the database schema and after that the user had Super User function and was able to add Super User function to other users.

    So it seems that the Super User function was not available in MDS at all.

    Thursday, May 9, 2019 1:26 PM