Error - AvCsNodeMgr unable to connect to SQL Server

[Beth Verish]

Unity 4.0(5), vocie mail only.

Every 15 minutes get the following event reported:

AvCsNodeMgr unable to connect to SQL Server on LocalHost. Error 0x80040000.

EVT_SQLSERVER_CONNECT_FAILED

ID: 1033

Source: CiscoUnity_NodeMgr

Message: AvCsNodeMgr unable to connect to SQL Server on %1. Error %2.

AvCsNodeMgr unable to connect to SQL Server on %1. Error %2.

Looked up error 0x80040000, returns Invalid OLEVERB structure

I am still receiving vm ok. I ran failover wizard which seemed to have sparked this event. Any suggestions? Thanks.

[Hin Lee]

If you open SQL's Enterprise Manager, and try to register the other Unity server, you might get "Cannot generate SSPI context." I think if you remove localhost, and register the actual servername or ip, you will get the same error. If either of the above is true, then see

http://support.microsoft.com/default.aspx?scid=kb;en-us;822265

You can download setspn.exe for windows 2000 from http://www.microsoft.com/downloads/details.aspx?familyid=5fd831fd-ab77-46a3-9cfe-ff01d29e5c46&displaylang=en

the command that you would run is

setspn –d ServicePrincipalNameEntryServerName

[arnieg]

I have the same issue. Did anyone have a solution for this?