sql server msde:
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
