[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1413
  • Last Modified:

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!!!
0
jsctechy
Asked:
jsctechy
  • 2
1 Solution
 
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now