Icon Tray SQL Icon

[Bob Day]

On a stand alone Windows XP, all with latest updates...

After installing the latest BCM (office 2003) from scratch, the SQL icon
(computer with white circle) appears in the icon tray (by the time);
however, the white circle does not have a green arrow and when you open SQL
Services Manager, it shows the server (the stand alone computer) by no
services are listed in the drop down box; however, pause and stop are valid
options (not grayed out); it also says Not Connected and the server name
(i.e. the stand alone computer) at the bottom. When I click "Refresh
Services" button, I get an Access Denied dialog box (I sometimes get this
dialog box on start up of the computer). BCM works fine.

The above behavior is different than other programs that use SQL (usually
there is a green arrow in the whte circle and the SQL Service Manager shows
a service running, referesh services button works fine.).

Why SQL behaving differently with BCM? Why is the icon there (I know BCM
uses SQL)?

Does this interfer with other programs using other instances in SQL?

Thanks
Bob

 

[Raul]

Hi

Go to start > run > svrnetcn.exe enable TCP/IP and Named Pipes,exit and
reopen the SQL service manager this should take care
of it

 

[Bob Day]

Thansk, that did help.

I have one other SQL server running, and it appears as expected in SQL
Service Manager

However, the BCM SQL service still does not show anywhere, but BCM works
fine. Has microsoft just hidden the BCM SQL service to protect people from
themselves?. I don't need access to it, I just wonder why it is working
differently than other SQL services.

Thanks!
Bob

 

[Raul]

If you go to start > run > services .msc you would see the BCM service
Listed (MSSQL$MICROSOFTSMLBIZ)