Adding a new database to BCM

[aqueiros]

I've attached a new BD to SQL, but I cannot see it when running the BCM
wizzard to select the DB.
I can create a new database without any problem, but I need to access the
old one, created and used with the same version of Office, but in a Vista
environment.
I also had a office domain when I used for the last time the DB.
I tried also to restore de backup, but i got an error message.
I'm using Office 2007 and Windows 7.

Any clue?

 

[Luther Blissett]

I've attached a new BD to SQL, but I cannot see it when running the BCM
wizzard to select the DB.
I can create a new database without any problem, but I need to access the
old one, created and used with the same version of Office, but in a Vista
environment.
I also had a office domain when I used for the last time the DB.
I tried also to restore de backup, but i got an error message.
I'm using Office 2007 and Windows 7.

Any clue?

My guess.

You need to take ownership of the db. There's a built-in sql sproc for
doing that.

 

[Antonio Queiros]

Thanks Luther,
But can you tell me how to do it?
I've looked SQL Configuration Manager and SQL Servedr Managemtn Studio
Express, but can't see where and how to do it.

 

[Luther Blissett]

Thanks Luther,
But can you tell me how to do it?
I've looked SQL Configuration Manager and SQL Servedr Managemtn Studio
Express, but can't see where and how to do it.







- Show quoted text -

http://beyng.blogspot.com/2007/07/changing-dbo-database-owner.html

 

[Antonio Queiros]

Thanks Luther,
But I'm not a tech expert.
can you tell me where and how can I execute the comand (sproc)?