Changing Owner in a BCM Database via CLI

After running in to an issue with a client recently; where following a rebuild of a SBS 2003 single server environment, users could not access their local Outlook 2010 Business Contact Manager databases.

With a lack of any SQL management consoles to change the database owner to the new user accounts created for the new domain I needed to find a command line option.

After much Googling and testing, the following command was the result:

First connect to the BCM instance using SQLCMD
     C:\>sqlcmd -S .\mssmlbiz
Then connect to the database you want to change the owner on
     1> use DBNAME
Type go
     2> go
You should get a confirmation message
     Changed database context to 'DBNAME'.
Now change the owner on the database
     1> sp_changedbowner 'DOMAIN\UserName'
Type go
     2> go
All done, there is no confirmation message

This process has to be used to connect to each BCM database (the use command) and then change the owner for each.

After changing the owner on each database the users could then connect to the BCM database in Outlook 2010.

Took me a while to get this, so seems like a good idea to make a note here...