Sharepoint during the initial installation creates a Sharepoint_AdminContent database with a GUID as a part of the db name. To a pedant like myself its annoying and when you have more than 1 sharepoint config on the same SQL server it's downright confusing. But there is no neat interface.
I did some research and found Keith Ritchies blog entry on PSConfig with some good notes on doing this.
However I struck a couple of issues with psconfig throwing errors and ended up modifying his command line as follows.
Keiths:
psconfig -cmd configdb -create -server krichie-fosqlp -database krichie-fo-wss-configdb -user adomain\SPService -password "SPServicePassword" -admincontentdatabase krichie-fo-wss-admin-content -dbuser adomain\SQLService -dbpassword "SQLServicePassword"
Remove the second dbuser and password details.
Now:
psconfig -cmd configdb -create -server krichie-fosqlp -database krichie-fo-wss-configdb -user adomain\SPService -password "SPServicePassword" -admincontentdatabase krichie-fo-wss-admin-content
Not sure how this affects anything but I could not get psconfig to acknowledge the username for the second database. It just did not like it. Admittedly my install is on Server 2008/SQL 2008 and Keiths post was dated back in 2006 so something may have changed.
No comments:
Post a Comment