How did you do it? Thanks, ________________________________
Mark Mears [email protected]<mailto:[email protected]%0d> Phone: (757) 945-2651 [cid:[email protected]]<http://www.cireson.com/> [cid:[email protected]]<http://twitter.com/teamcireson> Check out our System Center App Store: www.cireson.com/app-store ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Stuart Watret Sent: Monday, November 18, 2013 10:22 AM To: [email protected] Subject: [mssms] RE: help !! - sql sid's hooray........ well done me. Stuart Watret Offshore - IT Ltd ________________________________ From: [email protected]<mailto:[email protected]> <[email protected]<mailto:[email protected]>> on behalf of Stuart Watret <[email protected]<mailto:[email protected]>> Sent: 18 November 2013 15:07 To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: help !! - sql sid's ok so I think the master db thinks the owner is me, and the actual db thinks it's sa......... how to resolve? ..honestly if you leave this thread long enough I'll fix it myself :) Stuart Watret Offshore - IT Ltd ________________________________ From: [email protected]<mailto:[email protected]> <[email protected]<mailto:[email protected]>> on behalf of Stuart Watret <[email protected]<mailto:[email protected]>> Sent: 18 November 2013 14:40 To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: help !! - sql sid's 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]<mailto:[email protected]> <[email protected]<mailto:[email protected]>> on behalf of Stuart Watret <[email protected]<mailto:[email protected]>> Sent: 18 November 2013 14:32 To: [email protected]<mailto:[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
<<inline: image005.png>>
<<inline: image006.jpg>>
