Moving BCM 2007 Database to a SQL 2005 Server

Status
Not open for further replies.
J

jb

One of our users has been testing BCM and we now want others to start

using it, they have just been using a local database but now I want to

move it to SQL Server. I thought I could just backup the database and

restore it on the server using the BCM Database admin tool. I first

created a new database on the server with the admin tool then backed

up his local database and restored this onto the server.

This seemed to work however although user1 was still the dbo of the

database he could not access the database but users that I shared the

database to could access it just not the dbo. In Studio Manager when I

right clicked on the database and click properties under database it

had the owner listed as administrator. Administrator is the user I ran

the admin tool as. Is this owner different from the dbo? I even tried

using the command sp_changedbowner to make sure the dbo is set

correctly and it now shows in Studio Manager as user1 instead of

administrator but the user still cannot access the db.

If I try and connect using sqlcmd -E -S 'servername'\'instance','port

no'

I get the following error:

C:\>sqlcmd -E -S 'servername'\'instance','port no'

Msg 18456, Level 14, State 1, Server 'servername, Line 1

Login failed for user 'domain\user1'.

I have read that instead of restoring the database I could just export

the data then the dbo would be administrator. However I think I will

then have a problem where user1 will no longer be able to create new

fields in BCM which they need to be able to do.

Any help much appreciated.
 
J

jb

Just found out that if I detach the database when I Attach I can chose

who the owner is. I have select the user I want to be the owner and

now it all seems happy.
 
J

jb

OK still have one small problem, although the dbo can access the db,

we can not assign any tasks to him, anything he created just has blank

in the assigned to box. It seems like he needs to have the database

shared for his user but as he is the dbo he can't be a shared user.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
K Moving data from Outlook 2007 to Outlook 2007 with BCM BCM (Business Contact Manager) 3
C Moving BCM Database to Server Share BCM (Business Contact Manager) 1
S Moving BCM database to new PC BCM (Business Contact Manager) 2
N Moving communication history and activities from BCM to OUtlook BCM (Business Contact Manager) 2
N Moving contacts and activities from BCM to OUtlook BCM (Business Contact Manager) 4
glnz Moving from Outlook 2003 to MS365 Outlook - need basics Using Outlook 4
E Having some trouble with a run-a-script rule (moving mail based on file type) Outlook VBA and Custom Forms 5
F Moving Contacts to New Profile Using Outlook 0
J Moving Imported folder Using Outlook 2
J Outlook 2016 Moving IMAP emails to Exchange Using Outlook 1
A .restrict results changing after moving to Exchange online Outlook VBA and Custom Forms 0
T I'm thinking about moving from outlook.com to the Outlook I have in my Office 365 Using Outlook 1
L Moving emails with similar subject and find the timings between the emails using outlook VBA macro Outlook VBA and Custom Forms 1
S Moving .OST file location unsuccessful! Using Outlook 6
M Moving mail to another folder is much slower than before (Office365) Using Outlook 0
D Any updates or fixes that would make this code stop working just moving emails to another folder Outlook VBA and Custom Forms 1
B Moving account, contacts & emails to another H/D with MSOutlook Using Outlook 5
M I'm Having problems Moving Contacts to a New List Using Outlook 8
D Moving Emails Based on Recipient/Sender Outlook VBA and Custom Forms 4
U Outlook 2010 'freezes' before moving emails Using Outlook 2
S Moving Emails Between Archive Folders Using Outlook 1
P Moving Outlook.pst & archive1.pst Using Outlook 3
A Moving archived contents in Outlook 2007 back into working folders Using Outlook 0
Diane Poremsky Moving Deleted Items New Slipstick.com Articles 0
O Moving .ost file Using Outlook 12
Diane Poremsky Outlook.com is moving to Office 365! New Slipstick.com Articles 3
Diane Poremsky Check Contacts before moving them to Hotmail Contacts folder New Slipstick.com Articles 0
V Problem moving folders Using Outlook 4
Diane Poremsky Moving Outlook to a New Computer New Slipstick.com Articles 0
Diane Poremsky Moving from Outlook Express to Outlook New Slipstick.com Articles 0
M1ck53 Moving Outlook Using Outlook 9
Diane Poremsky Moving an Outlook offline data file (*.ost) New Slipstick.com Articles 3
D After Moving or Deleting Open Item - Meeting Requests Using Outlook 4
E Moving autoarchive settings to new computer (Outlook 2007) Using Outlook 1
Nick Truscott Lost custom forms after moving mailbox Outlook VBA and Custom Forms 3
L Moving Message Class email via script and Rule Outlook VBA and Custom Forms 3
R Moving contacts from ICloud back to Outlook 2010 Using Outlook 4
M which Outlook recommended to buy for moving Outlook 2000 versions Contact Data Using Outlook 2
P Moving PST file questions Using Outlook 3
Klaas "To Address" duplicated when moving msg to another folder Using Outlook 2
A Outlook 2013 EAS: moving message causes duplicates Using Outlook 3
A Moving .msg files back into outlook Using Outlook 2
S automatically moving flagged sent e-mail to a special folder Outlook VBA and Custom Forms 1
M moving custom field data between outlook and excel? Using Outlook 4
G Moving "Delete" button on Outlook for Mac Using Outlook 1
Commodore Message becomes "unread" after moving to a local folder Using Outlook 2
S Moving folders from outlook 2010 to a new computer with outlook 2013 Using Outlook 1
W Moving Exchange 2007 to a different drive/partition? Exchange Server Administration 1
A Outlook VBA - moving mail item to public folder using variable within path Using Outlook 6
O New to Outlook 2013, dealing with copying vs. moving sent items Using Outlook 0

Similar threads

Top