Thursday, November 8, 2007

WSS 3 Database Names - Headache!

For anyone who has tried installing MOSS 2007 in a web farm - you'll come to notice how the databases the install will create for content is something like this: "SharePoint_AdminContent_fdbaaad6-ab7f-4bce-982c-3441d23fa8de"
(the GUID is appended to a default common name - Sharepoint_AdminContent & GUID)

During the installation you will get prompted on what to name your config db - which is good, but the content db has no prompt. I have tried renaming this by: stopping IIS, renaming the db, going into the "object" table and finding the entry *will not let you change due to the concatenation formula. And you will get the "unknown error" which is a big HEADACHE.

Luckily I found this post by Rickey Whitworth: http://www.whitworth.org/Blog/PermaLink,guid,fa4f11e2-221a-4321-a01e-cd466016d534.aspx

Wish MOSS had an easier fix though.

No comments: