found a bit more tsql and that shows a different sid between the actual db and what the master thinks it should be, but ......how do we translate that to accounts?
Stuart Watret Offshore - IT Ltd ________________________________ From: [email protected] <[email protected]> on behalf of Stuart Watret <[email protected]> Sent: 18 November 2013 14:32 To: [email protected] Subject: [mssms] help !! - sql sid's Moved the sccm log file this weekend using the detach/attach method. Hit a snag with the "Trustworthy" issue; resolved that. System up and consoles connecting, but I can't import any new devices using the name/mac screen. Error states, "could not get next available key"......... the db owner sid recorded in the master db differs from the db owner sid recorded in "mt sccm db". Correct this using Alter authorization, blah blah. The issue I have is I'm not sure what to compare to find the difference; and as luck would have it, large migration tonight and need to add some devices. ANy thoughts? Stuart Watret Offshore - IT Ltd
