BCM with Server 2008

[Warren]

I'm moving from SQL 2005 to SQL 2008 for a Shared BCM database, I've tried
using the BCM manager database tool to backup and restore the database to the
new server and receive "Cannot retrive the list of SQL Server instances.
Please make sure that SQL Server 2005 or SQL Server 2005 Express is installed
and that the service is running" This also happened when I tried to create a
new database in SQL 2008.


I've also tried using SQL server backup and restore to copy the database,
clients can't connect to the new database either using computer\instance,1172
"Cannot access the database server on computer 'server'"

 

[Luther]

I'm moving from SQL 2005 to SQL 2008 for a Shared BCM database,  I've tried
using the BCM manager database tool to backup and restore the database tothe
new server and receive "Cannot retrive the list of SQL Server instances.  
Please make sure that SQL Server 2005 or SQL Server 2005 Express is installed
and that the service is running"  This also happened when I tried to create a
new database in SQL 2008.  

I've also tried using SQL server backup and restore to copy the database,
clients can't connect to the new database either using computer\instance,1172
  "Cannot access the database server on computer 'server'"

If you have a Sql Server 2005 instance with a BCM database, update to
Sql 2008, then the Sql 2008 install should migrate the BCM's MSSMLBIZ
sql instance to 2008, the instance retaining the same TCP port number
and user permissions. At least that's my theory. Because it is
supposed to work side-by-side with sql 2005, the sql 2008 setup may
have to be tweaked; e.g. specify that MSSMLBIZ should be migrated. I
know some people on this list have switched to sql 2008. Perhaps they
can share their findings.

I've noticed that Sql 2008 has stricter permissions (at least on
Vista) than 2005. That means that some actions in BCM or the database
tool (which was designed to work with Sql 2005) may not work without
changing some default permissions on Sql 2008. However, I have not
seen a list of what permissions need to be changed to make sql 2008
behave like 2005.

 

[Warren]

Let's try and make this simplier. I have a SQL 2005 instance installed on
Server 2008. I install the BCM database manager and when I run it to create
or share a database it doesn't recognize any SQL instances installed.

"Cannot retrive the list of SQL Server instances.
Please make sure that SQL Server 2005 or SQL Server 2005 Express is installed
and that the service is running"

 

[Luther]

Let's try and make this simplier.  I have a SQL 2005 instance installedon
Server 2008.  I install the BCM database manager and when I run it to create
or share a database it doesn't recognize any SQL instances installed.  

"Cannot retrive the list of SQL Server instances.  
Please make sure that SQL Server 2005 or SQL Server 2005 Express is installed
 and that the service is running"  







- Show quoted text -

Possibly a permissions issue. Have you tried running the tool as admin.

 

[Warren]

Yes I was running the tool as an admin. The only other thing I can think of
is this is a 64bit server.

 

[Warren]

Issue resolved. 64 Bit instance was the problem I installed a 32 bit
instance and that solved the problem.

 

[MichaelMc]

Could you please give me some guidance? I am in the same predicament of being
unable to use the Database Tool on a 64-bit Windows Server 2008 machine with
SQL Server 2008 installed. I have a 64-bit default instance and a 32-bit
MSSMLBIZ instance, but I still get the error that says that the Database Tool
cannot determine the SQL server instances and that it needs SQL Server 2005.

Thanks.

 

[a.k.a.]

Warren, MichaelMc and Luther,

About the compatibility of the BCM DB Administrator Tool with x64 instances
of SQL Server 2008....

I spotted this somewhere ... maybe it was the BCM Team Blog:

"The BCM Database Administrative Tool for BCM is only supported on x64 SQL
Server instances if you use this workaround...."

http://sharepoint.microsoft.com/inn...cuments/Outlook2007BusinessContactManager.doc

See if that gets you anywhere. I haven't tried it myself.

Also, just to reiterate, personally, I'm trying to figure out whether BCM
client will work if I remove SQL Server 2005 Express Edition and install SQL
Server 2008 Express Edition. Any better info there?

a.k.a.

 

[Luther]

Warren, MichaelMc and Luther,

About the compatibility of the BCM DB Administrator Tool with x64 instances
of SQL Server 2008....

I spotted this somewhere ... maybe it was the BCM Team Blog:

"The BCM Database Administrative Tool for BCM is only supported on x64 SQL
Server instances if you use this workaround...."

http://sharepoint.microsoft.com/innovateon/officedeveloper/Developer%...

See if that gets you anywhere. I haven't tried it myself.

Also, just to reiterate, personally, I'm trying to figure out whether BCM
client will work if I remove SQL Server 2005 Express Edition and install SQL
Server 2008 Express Edition. Any better info there?

a.k.a.





- Show quoted text -

1) BCM setup needs to configure BCM's instance of Sql. If BCM setup
doesn't do that, you'll need to do it manually.

2) I've noticed that 2008 is stricter about who can do what; e.g., to
grant another user some permissions, the admin must first grant
themselves permission to grant other users permission...These kinds of
things can break software that wasn't designed expecting them. So you
may need tweak Sql permissions to get certain BCM features to work
correctly.

 

[a.k.a.]

Ok, I see. That might get a little complicated, then. Is there documentation
about the settings and customizations that BCM makes in SQL Server when
installing?

I have a hard time believing that MS would release a PIM that would fail if
one of the two symbiotic components had to be refreshed on its own.

Thanks!