SQL 2000 Clustering

Question

SQL 2000 Clustering

vime

SSC-Addicted

Points: 496
More actions
March 14, 2003 at 5:56 am

#101407

HELP!!!
We are running sql server 2000 cluster.
when I go to cluster admin the sql cluster will not come online, it keeps failing.
I am getting the following errors:
System log:
1.Event 1069: Cluster resource 'SQL Server' failed.
Application Log:
1.[sqsrvres] ODBC sqldriverconnect failed
2.[sqsrvres] checkODBCConnectError: sqlstate = 28000; native error = 4818; message = [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'EU\EU-ClusterService'( cluster login ).
Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Wesley Brown SSChampion Points: 12045 More actions · Answer 1

you need to check the account SQL is set to run under and the cluster account. It doesn't have enough permissions to start the server.

Wes

click-fund Ten Centuries Points: 1028 More actions · Answer 2

To add a little more detail here:

The cluster service has a resource monitor process ('sqsrvres') that attempts to logon to the cluster and execute a status command every so often. This is its way of checking that the server is responding.

This resource monitor runs under the cluster service account and logs on via a trusted connection. Since the cluster service account must be a domain administrator, you must either permit that group or the service account itself to logon to your server via the trusted connection -- i.e. using Windows authentication.

Best wishes,

Graham

K. Brian Kelley SSC Guru Points: 114572 More actions · Answer 3

The cluster service account needs to be a domain account (not domain admin). A slight, but important security distinction.

As far as access to SQL Server, the cluster account must have the ability to login to SQL Server and it must be a member of the sysadmin role.

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

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

K. Brian Kelley
@kbriankelley

click-fund Ten Centuries Points: 1028 More actions · Answer 4

As I understand it, only users with administrative privileges can administer a cluster. The cluster service does not need to be a *domain* admin, but it does need to be a *local* admin. See, for example:

http://www.microsoft.com/windows2000/en/advanced/help/default.asp?url=/windows2000/en/advanced/help/cluad_pr_58.htm

vime SSC-Addicted Points: 496 More actions · Answer 5

Thank you all for your help, sorry for the late response, but I have been away for a week. Gave cluster service account permission to SQL server and it works fine.

Thanks again