fhtapia at gmail.com
Thu Apr 12 12:02:46 CDT 2007
Arthur is this the revlogin script? http://support.microsoft.com/default.aspx?scid=kb;en-us;246133 The issue is that the server was down, and we couldn't load it at all... my sysadmin ended up redoing the entire system. I restored the masterdb, but it may be a problem that the hashes that are saved in the sysuser table do not match the sid key from the OS since it was re-installed. -- Francisco On 4/12/07, Arthur Fuller <fuller.artful at gmail.com> wrote: > This is a bit after the fact, I realize, but I have a script that will write > a script for you that records all the user info (logins, users, passwords, > etc.) so you can just run the script in future to avoid all the hand-work. I > don't have it with me at the moment, but I'll send it off-list if you like. > > Arthur > > > On 4/12/07, Francisco Tapia <fhtapia at gmail.com> wrote: > > > > Today I had a server go down, and my sysadmin had to rebuild the OS. > > After re-installing SS2k SP4, I went ahead and placed the server in > > single user mode and restored the original master db, and also went > > ahead and restored the msdb (for scheduling task I had). One thing > > that did not go smoothly was the userid's that were restored via > > Master db restore. i've had to re-create the windows users and simply > > re-type the Sql users. I don't know why this happend, it almost was > > as if the users were orphaned. > > > > I'm posting here in case others have ran into this problem... I was > > quite at a loss since I didn't quite know what to even google for... > > the closest match was when you migrate users. and the point I guess is > > that I wasn't they were already on the same server (master db). > > > > any ideas? > > > > :) thanks, > > > > -- > > -Francisco > > http://sqlthis.blogspot.com | Tsql and More... > > _______________________________________________ > > dba-SQLServer mailing list > > dba-SQLServer at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > > http://www.databaseadvisors.com > > > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > > -- -Francisco http://sqlthis.blogspot.com | Tsql and More...
More information about the dba-SQLServer mailing list