how can i change the databse owner of a business contact manager BCM database?

i have a user that changed domains and is now on a different one but gets the following error when he tries to share out his database on the new domain.

"YOU MUST BE THE PERSON THAT CREATED THE DATABASE TO CHANGE USER PERMISSIONS FOR IT."
ANY IDEAS? im not sure how you can change the owner with this type of database, please advise, thanks!!!
LVL 1
jsctechyAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mark WillsTopic AdvisorCommented:
Where is it installed ? Is it running locally on his machine, or, is it centrally on a server ? If you go into SSMS (sql server 2005 ?) and go into "connect" you should see a servername (use the drop down list) like <servername>\MICROSOFTSMLBIZ  - in otherwords it is likely to be a named instance, and you user if no longer part of the original domain will not be recoginised (as you already know - because of the error message).

Have a look at : http://support.microsoft.com/default.aspx/kb/901164
0
Mark WillsTopic AdvisorCommented:
Also check out some of the help on : http://www.microsoft.com/smallbusiness/markets/connect/business-contact-manager.mspx  - look down on the left hand side for "help and how-to" and go into the version that matches your setup.
0
Neeraj SoniSr. ArchitectCommented:
This script will change db owner and all the objects owner in the db from user1 to dbo
You can set the variable values and run it in QA.
--Declare variables

DECLARE @old sysname, @new sysname, @sql varchar(1000)

--Initialize variables
SELECT
  @old = 'user1'
  , @new = 'dbo'
  , @sql = '
  IF EXISTS (SELECT NULL FROM INFORMATION_SCHEMA.TABLES
  WHERE
  QUOTENAME(TABLE_SCHEMA)+''.''+QUOTENAME(TABLE_NAME) = ''?''
  AND TABLE_SCHEMA = ''' + @old + '''
  ) 

--Change DB Owner
EXECUTE sp_changeobjectowner ''?'', ''' + @new + ''''

--Change Object Owner
EXECUTE sp_MSforeachtable @sql

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Outlook

From novice to tech pro — start learning today.