11-02-2005 01:01 AM - edited 03-18-2019 05:14 PM
we have Unity404 Sr1, with failover UM, e2k3. We continously get the following msg in app log every 10 minutes:
Event Type: Warning
Event Source: CiscoUnity_NodeMgr
Event Category: Run
Event ID: 1033
Date: 8/19/2005
Time: 12:10:22 PM
User: N/A
Computer: UnityVM1
Description:
AvCsNodeMgr unable to connect to SQL Server on LocalHost. Error 0x80040000.
This appears on the primary server. Replication is working as I have tested this by adding text files in \commserver stream files folder and this gets replicated. Failover also works ok. Name resolution also working ok.
Have also done this :
Open SQL Enterprise manager, SQL Server Group.
Right click on the Server Group, select New SQL
Server Registration, and select the secondary unity server
Any advice appreciated.
11-04-2005 03:48 AM
Hi, can anybody help with this ?
11-04-2005 11:41 AM
Open SQL Enterprise manager\SQL Server Group
Right-click on the Server Group, select New SQL Server Registration and selected the secondary unity server
Please let use know if you get any error messages and post them here (don't forget to check the app logs)
I suspect that you might get "Cannot generate SSPI context" and maybe a failed sql server registration.
11-06-2005 02:16 AM
Hi Hin,
I have tried this as I saw one of your previous threads and the secondary server registration worked ok with no reported errors.
Any other suggestions.
11-06-2005 03:53 PM
I am still leaning towards spn.
From the command prompt do,
setspn -l primary-unity
setspn -l secondary-unity
Compare the output of both and let us know if there is a difference.
Incidentally, what account is used to start the AvCsNodeMgr service on both servers? What is used to start the MsSqlServer and SqlServerAgent service?
(Sorry I missed the initial troubleshooting that you had registered the 2nd server on Sql Ent. Mgr.)
11-07-2005 02:02 PM
Hi Hin,
what do these commands actually test, they won't affect the system in anyway will they as the system in now in production. Also do we run both on the same server or on primary and then secondary?
thanks
J
11-11-2005 12:51 AM
Found following bug:
CSCec80854
No fix at present, cosmetic only.
11-09-2006 12:21 PM
Hi Hinho
Came across this thread. I had the following error message when trying to register primary sql server on 2nd server's SQL enterprise manager or try to re-run the failover wizard on 2nd server.
[0x80040000] : [Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context
The setspn output for the two servers are:
unity01 primary server
C:\Program Files\Resource Kit>setspn -L unity01
Registered ServicePrincipalNames for CN=UNITY01,OU=RMY,DC=region,DC=ca:
MSSQLSvc/unity01.region.ca:1433
SMTPSVC/UNITY01
SMTPSVC/unity01.region.ca
HOST/UNITY01
HOST/unity01.region.ca
ykr-unity01-fai failover server
C:\Program Files\Resource Kit>setspn.exe -L unity01-fai
Registered ServicePrincipalNames for CN=UNITY01-FAI,OU=RMY,DC=region,DC=ca:
HOST/UNITY01-FAI
HOST/unity01-fai.region.ca
Somebody suggested deleting the MSSQLSvc/unity01.region.ca:1433
SMTPSVC/UNITY01
SMTPSVC/unity01.region.ca
on the primary server. I am wondering what will happen if remove it?Will it stop the sql and smtp service on the primary server? Why this will help? Thanks
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: