|
Posted by JeffB on October 5, 2007, 1:11 pm
Please log in for more thread options
Just an observation--no question in here.
On one of my servers, if I look at User Rights Assignment, I see groups of
bogus SIDS in the form
S-1-5-21-xxxxxxxxxx-xxxxxxxxxx-xxxxxxxx-10xx
Here's my guess at what happened:
- SQL Server 2005 got installed; the installer created lots of lovely
SQLServer2005XXX$ComputerName accounts and gave them
necessary user rights.
- SQL Server 2005 was uninstalled, and the uninstaller got rid of
the accounts but not the user rights assignments.
I think my guess is a safe bet, because immediately following the
bad SIDs are SQLServer2005XXX$ComputerName accounts names.
Our DBA says this is likely what happened. More specifically, he had
accidentally installed the 32-bit version of SQL Server 2005 and then
replaced it with the 64-bit version.
| 
XML Sitemap