Failed DB Sharing

G

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?
 
R

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
 
L

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.
 
G

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?
 
L

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.
 
G

Guzun, Alex

OK, I know that
but what exactly?

Luther said:
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.
Click to expand...
 
Top