Luther said:
The thingy in the system tray could be for another instance or version
of Sql Server. Chances are that your other database is not using the
same instance as BCM, unless it happens to be a MOA or POS database.
The BCM v3/2007 instance is called mssmlbiz. You can double check the
name BCM is using in the Registry:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Business Solutions eCRM
The pertinent key is SQLInstanceName.
You can check the databases on the instance with this command:
sqlcmd -E -S "localhost\mssmlbiz" -Q "select substring(name,1,20),
state_desc from sys.databases"
That registry key does not exist on the machine.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Business Solutions eCRM is there, but
the SQLInstanceName key is not. Keep in mind, I do not actually have BCM or
outlook installed because this server has exchange server on it. That is why
I am trying to use the databse admin tool instead.
Also the database we have running on our server is called BKUPEXEC. Here is
a command I tried similar to you the one you gave and the results:
C:\Documents and Settings\Administrator>sqlcmd -E -S "localhost\bkupexec" -Q
"select substring(name,1,20), state_desc from sys.databases"
Msg 208, Level 16, State 1, Server FS01\BKUPEXEC, Line 1
Invalid object name 'sys.databases'.
Do I just need to create a new instance?