Failed DB Sharing

[Guzun, Alex]

Hi all

I'm fighting with this problem for a few days. I installed BCM on our server
(to be a client-server installation). No problems. Created new DB - no
problems. Then I wanted to share it: added users clicked share and....

An error occurred while applying changes. Your changes have not been applied
successfully.

2k3 server, member of a domain, domain admin account.


After that error SQL/MSSMLBIZ won't work at all. It stopped and I can't
start it, saying that it could not be started coz of something. Now I need
to reinstall BCM with integrated SQL

Any idea?

 

[Raul]

The error message that you earlier stated might happen if the Internet
connection firewall is disabled. As for the second error try removing
BCM and MSDE from add / remove programs and then navigate to C:\Program
Files\MSSQL Server and rename the same to MSSQL ServerOLD

Then try reinstalling BCM

 

[Luther]

The answer probably lies in the "coz of something".

Look in the Windows Event Viewer for Application errors from Sql, or
the MSSMLBIZ sql log.

 

[Guzun, Alex]

I'll try something on my workstation, not server.
By the way: When BCM is applying sharing settings it shows me

Enabling network protocols on SQL Server

What does it mean actually? What should I do if I want to configure SQL
manually?

 

[Luther]

Sql has a utility that configures access to local machine only, or TCP
and Named Pipes access from network. When "Enabling network protocols",
BCM is turning on the latter programmatically.

 

[Guzun, Alex]

OK, I know that
but what exactly?

Sql has a utility that configures access to local machine only, or TCP
and Named Pipes access from network. When "Enabling network protocols",
BCM is turning on the latter programmatically.