May 3, 2013 at 8:47 am
After upgrading to 2008, some of the users in master are shown disabled. Wht could be the reason and how to fix it, other than deleting and recreating the users?
May 3, 2013 at 9:55 am
How was the upgrade performed, side by side or in-place?
I am guessing that you scripted out all the logins and ran the scripts on the upgraded server. Scripting SQL logins, by default, generates a script that has the user disabled and creates a random password for the login.
May 4, 2013 at 10:25 am
David,
Its side by side upgrade. I used the Rev Login script from MSDN which scripts out the logins and password. It does not disable login/user by default.
I ran the script, fixed orphaned users. In source, that login/user has read access to master. In upgraded server, when i see the login, it doesnt have access to master, when i go to master-users, i see the id has read access to master and its disabled. I am pretty certain, that if i delete the user in master and recreate it, and fix orphan, it would work and can access master. But if there are many such users, then such option is not viable.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply