MSDE & Business Contact Manager

I have a computer (XP PRO) that I attempted to install MSDE on for a database
application we use, not realizing that the Outlook Business Contact Manager
has some sort of SQL server already installed. The installation failed. In
looking through the services I noticed the MicrosoftBCM instance and realized
that must be my problem.
I attempted to connect to this instance via odbc and not knowing the
connection method was unable to connect (server does not exist or access
denied...) but the computer name and (local) were listed in the SQL servers
list.
So I installed a new instance of MSDE SP3. The installation went fine. The
new instance appeared in the services. I started the new service and
everything looked OK, but in trying to connect via ODBC, now SQL servers list
was empty and typing in the computer name did not help.
I restarted the computer and had the same symptoms. I started the SQL server
agent and none of the services were listed here either.
I looked in the reg key HKLM\SOFTWARE\MICROSOFT\Microsoft SQL
Server\InstalledInstances, and both were listed there.
The services were started and there were not any errors in the event log.
I uninstalled and re-installed MSDE, but that did not help either. So I
uninstalled the Business contact manager, since we were not yet using it and
the MSDE, then reinstalled MSDE and that is now working just fine with the
database application.
Does anyone have any idea what my problem may have been, if I am just unable
to have the Business contact manager and MSDE on the same comptuer or if
there is a fix or workaround for the problem I am experiencing?
Thanks so much,
ST
hi,
ST wrote:
> I have a computer (XP PRO) that I attempted to install MSDE on for a
> database application we use, not realizing that the Outlook Business
> Contact Manager has some sort of SQL server already installed. The
> installation failed. In looking through the services I noticed the
> MicrosoftBCM instance and realized that must be my problem.
> I attempted to connect to this instance via odbc and not knowing the
> connection method was unable to connect (server does not exist or
> access denied...) but the computer name and (local) were listed in
> the SQL servers list.
> So I installed a new instance of MSDE SP3. The installation went
> fine. The new instance appeared in the services. I started the new
> service and everything looked OK, but in trying to connect via ODBC,
> now SQL servers list was empty and typing in the computer name did
> not help.
> I restarted the computer and had the same symptoms. I started the SQL
> server agent and none of the services were listed here either.
> I looked in the reg key HKLM\SOFTWARE\MICROSOFT\Microsoft SQL
> Server\InstalledInstances, and both were listed there.
> The services were started and there were not any errors in the event
> log.
> I uninstalled and re-installed MSDE, but that did not help either. So
> I uninstalled the Business contact manager, since we were not yet
> using it and the MSDE, then reinstalled MSDE and that is now working
> just fine with the database application.
> Does anyone have any idea what my problem may have been, if I am just
> unable to have the Business contact manager and MSDE on the same
> comptuer or if there is a fix or workaround for the problem I am
> experiencing?
> Thanks so much,
> ST
I do not know about Outlook Business Contact Manager, but as regard the
empty SQL Server list in the SQL Server Service Manager, it probably depends
on network protocols setting for the installed MSDE instance, as reported in
http://support.microsoft.com/default...b;EN-US;814132
to modify this behaviour, run the Server Network Utility (svrnetcn.exe) and
enable the desired networkprotocol, if this is a viable solution..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply