Failed DB Sharing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Guzun, Alex - 18 Dec 2006 09:30 GMT

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?

Reply to this Message

Raul - 19 Dec 2006 02:53 GMT

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

Signature

With Regards

Raul Thomas

> Hi all
>
[quoted text clipped - 12 lines]
>
> Any idea?

Reply to this Message

Luther - 19 Dec 2006 17:03 GMT

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.

> Hi all
>
[quoted text clipped - 12 lines]
>
> Any idea?

Reply to this Message

Guzun, Alex - 20 Dec 2006 09:28 GMT

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?

> The answer probably lies in the "coz of something".
>
[quoted text clipped - 20 lines]
>>
>> Any idea?

Reply to this Message

Luther - 20 Dec 2006 17:10 GMT

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.

> I'll try something on my workstation, not server.
> By the way: When BCM is applying sharing settings it shows me
[quoted text clipped - 28 lines]
> >>
> >> Any idea?

Reply to this Message

Guzun, Alex - 21 Dec 2006 08:02 GMT

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",
[quoted text clipped - 33 lines]
>> >>
>> >> Any idea?

Reply to this Message