Hi

Could you help me find answer for this question please?

I’ve just set up two node fail over cluster (SQL 2008 and Windows Server
2008).
In documentation is that under with cluster service is working should have
rights to login to SQL to perform IsAlive check.

My cluster service is working under Local System Account but SQL services
are running under special sqlservice account. I didn’t give any rights for
SQL any of them. And now I don’t know if check IsAlive is working or not. I
have no issues, not errors in Event Log, nothing related cluster.

How to verify if this test is working correctly and what I should do with
this problem?
Many Thanks

You described a correct configuration for SQL 2008 and Windows 2008.

The SQL installer sets permissions on the service accounts using Service
SIDS. No more domain accounts are required.

The various cluster health checks are set up and running automatically. If
they were not, the SQL instance would appear dead and the cluster service
would shut it down.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Piotr" <Piotr (AT) discussions (DOT) microsoft.com> wrote

You described a correct configuration for SQL 2008 and Windows 2008.

The SQL installer sets permissions on the service accounts using Service
SIDS. No more domain accounts are required.

The various cluster health checks are set up and running automatically. If
they were not, the SQL instance would appear dead and the cluster service
would shut it down.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Piotr" <Piotr (AT) discussions (DOT) microsoft.com> wrote

You described a correct configuration for SQL 2008 and Windows 2008.

The SQL installer sets permissions on the service accounts using Service
SIDS. No more domain accounts are required.

The various cluster health checks are set up and running automatically. If
they were not, the SQL instance would appear dead and the cluster service
would shut it down.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Piotr" <Piotr (AT) discussions (DOT) microsoft.com> wrote

You described a correct configuration for SQL 2008 and Windows 2008.

The SQL installer sets permissions on the service accounts using Service
SIDS. No more domain accounts are required.

The various cluster health checks are set up and running automatically. If
they were not, the SQL instance would appear dead and the cluster service
would shut it down.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Piotr" <Piotr (AT) discussions (DOT) microsoft.com> wrote

You described a correct configuration for SQL 2008 and Windows 2008.

The SQL installer sets permissions on the service accounts using Service
SIDS. No more domain accounts are required.

The various cluster health checks are set up and running automatically. If
they were not, the SQL instance would appear dead and the cluster service
would shut it down.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Piotr" <Piotr (AT) discussions (DOT) microsoft.com> wrote

You described a correct configuration for SQL 2008 and Windows 2008.

The SQL installer sets permissions on the service accounts using Service
SIDS. No more domain accounts are required.

The various cluster health checks are set up and running automatically. If
they were not, the SQL instance would appear dead and the cluster service
would shut it down.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Piotr" <Piotr (AT) discussions (DOT) microsoft.com> wrote

You described a correct configuration for SQL 2008 and Windows 2008.

The SQL installer sets permissions on the service accounts using Service
SIDS. No more domain accounts are required.

The various cluster health checks are set up and running automatically. If
they were not, the SQL instance would appear dead and the cluster service
would shut it down.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Piotr" <Piotr (AT) discussions (DOT) microsoft.com> wrote

You described a correct configuration for SQL 2008 and Windows 2008.

The SQL installer sets permissions on the service accounts using Service
SIDS. No more domain accounts are required.

The various cluster health checks are set up and running automatically. If
they were not, the SQL instance would appear dead and the cluster service
would shut it down.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Piotr" <Piotr (AT) discussions (DOT) microsoft.com> wrote

You described a correct configuration for SQL 2008 and Windows 2008.

The SQL installer sets permissions on the service accounts using Service
SIDS. No more domain accounts are required.

The various cluster health checks are set up and running automatically. If
they were not, the SQL instance would appear dead and the cluster service
would shut it down.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Piotr" <Piotr (AT) discussions (DOT) microsoft.com> wrote