Failed to Connect to Database Issue

[Andrew_Tankersl]

I am receiving the following error when trying to access EV;

Failed to connect to the 'Vault Directory Database'

In the event viewer I have hundreds of the following events;

Event Type:Error
Event Source:Enterprise Vault
Event Category:Directory Service
Event ID:13360
Date:11/30/2006
Time:2:50:51 PM
User:N/A
Computer:RESKVS01
Description:
An error was detected while accessing the Vault Database 'EnterpriseVaultDirectory' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand) built Jul 25 17:21:03 2006):

Description:

Class not registered

SQL Command:
if exists(SELECT * FROM ExtendedSetting) and not exists(SELECT * FROM ExtendedSetting WHERE settingTypeId = '78') select 1 as else select 0 as


Additional Microsoft supplied information:

Source: Provider
Number: 0x80040154
SQL State:
Native Error: -2147221164
HRESULT0x80040154


And;

Event Type:Error
Event Source:Enterprise Vault
Event Category:Directory Service
Event ID:8391
Date:11/30/2006
Time:2:58:47 PM
User:N/A
Computer:RESKVS01
Description:
The EnterpriseVault.DirectoryService object reported an error.

Class not registered

For more information, see Help and Support Center at http://evevent.veritas.com/rosetta/showevent.asp


I am going to open a case with Symantec - but I'd thought I'd try with all of you first

[Michael_Bilsbor]

Hi,

On the EV server in HKLM\Software\KVS\Enterprise Vault

you will find a reg key called siteid

at the end of the number will be a string which is your site alias
can you ping that?

[Micah_Wyenn]

yeah,
that's a good place to start. If your ping works, and it's not a general connectivity issue, the next thing I'd suspect was SQL permissions. If that doesn't work, um...a long shot could be dcom. I just saw an agentclientbroker class not found on the support digests, you could give that a read and see if that helps ya a bit (but of course, don't chase down agentclientbroker, it's the wrong processes).

micah

[Andrew_Tankersl]

Confirmed - I can ping the site alias

[Andrew_Tankersl]

Our DBA is telling me there appears to be no permission issues with our KVS account
I will look into the support digest article you mention...

[Alan_M]

Can you open a manual connection to the SQL server from the EV server? You might have a general SQL connectivity issue.

[Andrew_Tankersl]

Manual connection seems ok...

[Micah_Wyenn]

Andrew,
i think I know what might be causing this. Two things you should check. Make sure you have the correct odbc settings for your server, and also check the client side alias to make sure you can connect.

micah

[Andrew_Tankersl]

Micah -
The ODBC connection works ok...
However if I run the SQL client tools and connect to the SQL database (which is on another server), then try to expand all rows on any database I get an "unknown error" prompt.

[Michael_Bilsbor]

Hi,

So running sql query analyser on EV server to connect to SQL server fails?

[Andrew_Tankersl]

Correct

[Michael_Bilsbor]

ok, so we all agree that this isn't an EV issue but an SQL issue that EV is then a victim of, correct?

[Andrew_Tankersl]

That's what we're leaning towards here...