Installing SQL Express with BCM 2007

[TedSA]

Is it mandatory to install SQL Express with BCM 2007?

If you want to use BCM 2007 with a SQL Server 2005 central server, do you
still need to install the SQL Exoress 2005 Small Business instance in each
client machine?

Thanks in advance for your help!

 

[Luther]

Is it mandatory to install SQL Express with BCM 2007?

If you want to use BCM 2007 with a SQL Server 2005 central server, do you
still need to install the SQL Exoress 2005 Small Business instance in each
client machine?

Thanks in advance for your help!

In theory, you shouldn't need sql locally.

I don't recall anyone saying here that they managed to install BCM
without Sql, and then had it connect to a remote server.

If you look at the setup files, there are different MSIs for BCM and
Sql, so what you want is feasible. So should be able to install just
the BCM MSI, if all its prerequisites are installed, and the BCM MSI
doesn't explicitly check for Sql.

I do recall someone installing BCM with Sql, connecting to a remote
database, and then uninstalling sql from the client.

 

[TedSA]

if you try to install from the bcm msi, mssmlbiz.msi, the installation fails
with a notification that the installation has to be run from setup.exe

setup.exe uses a xml based wizard to configure the installation order and
parameters of the 5 packages that make up BCM.

if you make SQL Server 2005 Express an optional component and tell the
wizard not to install it the installation returns an error.

any thoughts on this would be greatly appreciated.

 

[Luther]

if you try to install from the bcm msi, mssmlbiz.msi, the installation fails
with a notification that the installation has to be run from setup.exe

setup.exe uses a xml based wizard to configure the installation order and
parameters of the 5 packages that make up BCM.

if you make SQL Server 2005 Express an optional component and tell the
wizard not to install it the installation returns an error.

any thoughts on this would be greatly appreciated.









- Show quoted text -

Looks like you'll have to install BCM with Sql, connect BCM to your
remote database, and then remove sql.

You could also suggest sql-less installs to the BCM team for their
next release.

Their blog is here: http://blogs.msdn.com/bcm/default.aspx