Moss/Sps Database with wrong DBO

27 באוגוסט 2007

אין תגובות

Ok , so what happens when you let a ruckie Sharepoint Admin/Developer install your company's sharepoint? yes ladies and gentlemen – he installs it under HIS login 'MyDomain\HisUserName' . Problems ? yes, and what if he decides to leave the company and go freelance or something ? yes boys and girls his login and mailbox is been deleted . problem ? yes – all the DBs runs under his permission and not body knows it until a restart to the machine is made – aghhh   :s


Solution ? yes


USE whichever_database
EXEC sp_changedbowner 'MyDomain\Administrator'

הוסף תגובה
facebook linkedin twitter email

כתיבת תגובה

האימייל לא יוצג באתר. שדות החובה מסומנים *