Have NT4 with SQL7 on in an NT Clustered enviroment, on on enode the cluster starts up fine, on the other it fails when it trys to start the SQLAgent.
I have checked the user the service starts on, just fine and also checked that it has the correct rights in SQL but to no avail.
When the service fails it gets the following errors:
Event ID 1024 Source:ClusSrv Cat: (64)
The registry checkpoint for cluster resource {sql instance] SQL server 7.0 could not be restored to the registry
hkey_local_machine\system\CCS\services\MSSql[dbname] The resource may not function corretly. Make sure that no other processes have open handles to registry keys in this registry subtree
Followed by:
Event ID: 1069 Source: ClusSrv Cat: (4)
Cluster resource [DBNAME] sql server 7.0 failed
any help wuld be appreciated thank you
I have checked the user the service starts on, just fine and also checked that it has the correct rights in SQL but to no avail.
When the service fails it gets the following errors:
Event ID 1024 Source:ClusSrv Cat: (64)
The registry checkpoint for cluster resource {sql instance] SQL server 7.0 could not be restored to the registry
hkey_local_machine\system\CCS\services\MSSql[dbname] The resource may not function corretly. Make sure that no other processes have open handles to registry keys in this registry subtree
Followed by:
Event ID: 1069 Source: ClusSrv Cat: (4)
Cluster resource [DBNAME] sql server 7.0 failed
any help wuld be appreciated thank you
