SQL Server

[Patrick D.]

Hi,

BCM 2007:
I prefere to use an SQL-Server on my Small Business Server:
Is there a way to install BCM on a client without the local installation of
SQL-Server?

. . .or should we simply uninstall the local copy of SQL-Server after
installing BCM?

Thanks for your feedback.

regards
Patrick

 

[Kiatake]

I have the same question. The local SQL is dragging memory and performance.
I wonder if it is because the offline option.

 

[Patrick D.]

Hi Kiatake

Possibly it is because of the offline-option:
But there are still some systems, where you never use this option.
Since I didn't get an answer, we have to think, that nobody knows a solution
to get rid of this local sql installation.
The most interesting thing is: If you allready have a local sql
installation, BCM will still install another instance of sql. I don't
understand why.

regards
Patrick

 

[Luther]

Hi Kiatake

Possibly it is because of the offline-option:
But there are still some systems, where you never use this option.
Since I didn't get an answer, we have to think, that nobody knows a solution
to get rid of this local sql installation.
The most interesting thing is: If you allready have a local sql
installation, BCM will still install another instance of sql. I don't
understand why.

regards
Patrick






- Show quoted text -

BCM (and other applications from Microsoft Business Solutions) install
there own instance of SQL so that they can control some security
aspects. For example, their instance requires that connections encrypt
their data and won't respond to the default request used to browse Sql
Server instances on a machine.

 

[Kiatake]

Dear Luther and Patrick,
I have uninstalled the SQL Server of my local machine, but BCM appears to
still working.
Will I lost some functionalities or just security?

Regards,
Kiatake

 

[Wayne Small]

It also installs on a different port than normal SQL server as I've found.

--
Regards,
Wayne Small [SBS-MVP]
MCT, MCSE+I, MCSE 2000
SBSfaq.com Pty Ltd

Co-author of Advanced Windows Small Business Server 2003 Best Practices
For all the answers on Microsoft's Small Business Server- check out
www.sbsfaq.com

 

[Luther]

It also installs on a different port than normal SQL server as I've found.

--
Regards,
Wayne Small [SBS-MVP]
MCT, MCSE+I, MCSE 2000
SBSfaq.com Pty Ltd

Co-author of Advanced Windows Small Business Server 2003 Best Practices
For all the answers on Microsoft's Small Business Server- check outwww.sbsfaq.com

BCM (and other applications from Microsoft Business Solutions) install
there own instance of SQL so that they can control some security
aspects. For example, their instance requires that connections encrypt
their data and won't respond to the default request used to browse Sql
Server instances on a machine.- Hide quoted text -

- Show quoted text -

Setting that specific port is part of security.

By default, when a Sql instance starts up it picks a random,
available, TCP port for connections, and listens at a known (low
security) UDP port for connection requests. A client asks Sql via a
UDP port for the TCP port number, and then connects to the TCP port.
This is how you can browse a machine for Sql, you ask the UDP port if
there are any Sql instances on the machine, and it returns their TCP
port numbers. The BCM Sql instance doesn't participate in that port
discovery via UDP, so someone randomly scanning a BCM machine with UDP
won't discover the BCM instance.

 

[Luther]

Dear Luther and Patrick,
I have uninstalled the SQL Server of my local machine, but BCM appears to
still working.
Will I lost some functionalities or just security?

Regards,
Kiatake






- Show quoted text -

If you only use a BCM database hosted on another server machine, you
can remove Sql Server on your client machine. Even if you don't remove
it, you shold turn it off, so it doesn't use up your CPU and memory
needlessly.

Security is set ("demanded") by the server. If the server demands a
secure connection, then it'll accept secure connections, irrespective
of what's installed on the client.