SQL2005 x64 Analysis Cluster

#11

Check that the service account is NOT a domain admin.

Apply SP2 and it should clean up some of the compatibility issues.

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

"Sean (UK)" <Sean (UK)@discussions.microsoft.com> wrote

Quote:

Hi All,

I have a strange error with SQL2005 x64 on a HP DL580g5 x64 (Win23k R2 +
Sp2).

I've installed SQL2005 DB and cluster it no problem at all.

This system is going to be a BI system so I've also tried to install and
cluster Analysis Services with little success.

I get a strange error in the app evnt log.

Category (289) Event ID:0
The service cannot be started: The following system error occurred: An
attempt was made to access a socket in a way forbidden by its access
permissions.

The cluster account has local admin permissions on all the cluster nodes,
and I've followed the white paper to configure the cluster.

I've been clustering SQL for years and SQL 2005 always seems to be work
straight away.

I've removed it using the correct cli method and reinstalled, but I seem
to
get the same error....?

Any ideas? before I try and log a formal fault call with MS..?

Regards,

Sean
Error is

#12

Hi All,

I've fixed this by removing the local instance of SSAS on both nodes and
then reclustering with 1 clustered instance of SSAS then patched to SP2.

Weird sort of issue or as MS would say Undocumented feature for x64.

Regards,

Sean

"Geoff N. Hiten" wrote:

Quote:

Check that the service account is NOT a domain admin.

Apply SP2 and it should clean up some of the compatibility issues.

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

"Sean (UK)" <Sean (UK)@discussions.microsoft.com> wrote in message
news:FF711332-6309-4BC8-B5C8-9A26CD83507A (AT) microsoft (DOT) com...
Hi All,

I have a strange error with SQL2005 x64 on a HP DL580g5 x64 (Win23k R2 +
Sp2).

I've installed SQL2005 DB and cluster it no problem at all.

This system is going to be a BI system so I've also tried to install and
cluster Analysis Services with little success.

I get a strange error in the app evnt log.

Category (289) Event ID:0
The service cannot be started: The following system error occurred: An
attempt was made to access a socket in a way forbidden by its access
permissions.

The cluster account has local admin permissions on all the cluster nodes,
and I've followed the white paper to configure the cluster.

I've been clustering SQL for years and SQL 2005 always seems to be work
straight away.

I've removed it using the correct cli method and reinstalled, but I seem
to
get the same error....?

Any ideas? before I try and log a formal fault call with MS..?

Regards,

Sean
Error is

#13

Hi All,

I've fixed this by removing the local instance of SSAS on both nodes and
then reclustering with 1 clustered instance of SSAS then patched to SP2.

Weird sort of issue or as MS would say Undocumented feature for x64.

Regards,

Sean

"Geoff N. Hiten" wrote:

Quote:

Check that the service account is NOT a domain admin.

Apply SP2 and it should clean up some of the compatibility issues.

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

"Sean (UK)" <Sean (UK)@discussions.microsoft.com> wrote in message
news:FF711332-6309-4BC8-B5C8-9A26CD83507A (AT) microsoft (DOT) com...
Hi All,

I have a strange error with SQL2005 x64 on a HP DL580g5 x64 (Win23k R2 +
Sp2).

I've installed SQL2005 DB and cluster it no problem at all.

This system is going to be a BI system so I've also tried to install and
cluster Analysis Services with little success.

I get a strange error in the app evnt log.

Category (289) Event ID:0
The service cannot be started: The following system error occurred: An
attempt was made to access a socket in a way forbidden by its access
permissions.

The cluster account has local admin permissions on all the cluster nodes,
and I've followed the white paper to configure the cluster.

I've been clustering SQL for years and SQL 2005 always seems to be work
straight away.

I've removed it using the correct cli method and reinstalled, but I seem
to
get the same error....?

Any ideas? before I try and log a formal fault call with MS..?

Regards,

Sean
Error is

#14

Hi All,

I've fixed this by removing the local instance of SSAS on both nodes and
then reclustering with 1 clustered instance of SSAS then patched to SP2.

Weird sort of issue or as MS would say Undocumented feature for x64.

Regards,

Sean

"Geoff N. Hiten" wrote:

Quote:

Check that the service account is NOT a domain admin.

Apply SP2 and it should clean up some of the compatibility issues.

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

"Sean (UK)" <Sean (UK)@discussions.microsoft.com> wrote in message
news:FF711332-6309-4BC8-B5C8-9A26CD83507A (AT) microsoft (DOT) com...
Hi All,

I have a strange error with SQL2005 x64 on a HP DL580g5 x64 (Win23k R2 +
Sp2).

I've installed SQL2005 DB and cluster it no problem at all.

This system is going to be a BI system so I've also tried to install and
cluster Analysis Services with little success.

I get a strange error in the app evnt log.

Category (289) Event ID:0
The service cannot be started: The following system error occurred: An
attempt was made to access a socket in a way forbidden by its access
permissions.

The cluster account has local admin permissions on all the cluster nodes,
and I've followed the white paper to configure the cluster.

I've been clustering SQL for years and SQL 2005 always seems to be work
straight away.

I've removed it using the correct cli method and reinstalled, but I seem
to
get the same error....?

Any ideas? before I try and log a formal fault call with MS..?

Regards,

Sean
Error is

#15

Hi All,

I've fixed this by removing the local instance of SSAS on both nodes and
then reclustering with 1 clustered instance of SSAS then patched to SP2.

Weird sort of issue or as MS would say Undocumented feature for x64.

Regards,

Sean

"Geoff N. Hiten" wrote:

Quote:

Check that the service account is NOT a domain admin.

Apply SP2 and it should clean up some of the compatibility issues.

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

"Sean (UK)" <Sean (UK)@discussions.microsoft.com> wrote in message
news:FF711332-6309-4BC8-B5C8-9A26CD83507A (AT) microsoft (DOT) com...
Hi All,

I have a strange error with SQL2005 x64 on a HP DL580g5 x64 (Win23k R2 +
Sp2).

I've installed SQL2005 DB and cluster it no problem at all.

This system is going to be a BI system so I've also tried to install and
cluster Analysis Services with little success.

I get a strange error in the app evnt log.

Category (289) Event ID:0
The service cannot be started: The following system error occurred: An
attempt was made to access a socket in a way forbidden by its access
permissions.

The cluster account has local admin permissions on all the cluster nodes,
and I've followed the white paper to configure the cluster.

I've been clustering SQL for years and SQL 2005 always seems to be work
straight away.

I've removed it using the correct cli method and reinstalled, but I seem
to
get the same error....?

Any ideas? before I try and log a formal fault call with MS..?

Regards,

Sean
Error is

#16

Hi All,

I've fixed this by removing the local instance of SSAS on both nodes and
then reclustering with 1 clustered instance of SSAS then patched to SP2.

Weird sort of issue or as MS would say Undocumented feature for x64.

Regards,

Sean

"Geoff N. Hiten" wrote:

Quote:

Check that the service account is NOT a domain admin.

Apply SP2 and it should clean up some of the compatibility issues.

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

"Sean (UK)" <Sean (UK)@discussions.microsoft.com> wrote in message
news:FF711332-6309-4BC8-B5C8-9A26CD83507A (AT) microsoft (DOT) com...
Hi All,

I have a strange error with SQL2005 x64 on a HP DL580g5 x64 (Win23k R2 +
Sp2).

I've installed SQL2005 DB and cluster it no problem at all.

This system is going to be a BI system so I've also tried to install and
cluster Analysis Services with little success.

I get a strange error in the app evnt log.

Category (289) Event ID:0
The service cannot be started: The following system error occurred: An
attempt was made to access a socket in a way forbidden by its access
permissions.

The cluster account has local admin permissions on all the cluster nodes,
and I've followed the white paper to configure the cluster.

I've been clustering SQL for years and SQL 2005 always seems to be work
straight away.

I've removed it using the correct cli method and reinstalled, but I seem
to
get the same error....?

Any ideas? before I try and log a formal fault call with MS..?

Regards,

Sean
Error is

#17

Hi All,

I've fixed this by removing the local instance of SSAS on both nodes and
then reclustering with 1 clustered instance of SSAS then patched to SP2.

Weird sort of issue or as MS would say Undocumented feature for x64.

Regards,

Sean

"Geoff N. Hiten" wrote:

Quote:

Check that the service account is NOT a domain admin.

Apply SP2 and it should clean up some of the compatibility issues.

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

"Sean (UK)" <Sean (UK)@discussions.microsoft.com> wrote in message
news:FF711332-6309-4BC8-B5C8-9A26CD83507A (AT) microsoft (DOT) com...
Hi All,

I have a strange error with SQL2005 x64 on a HP DL580g5 x64 (Win23k R2 +
Sp2).

I've installed SQL2005 DB and cluster it no problem at all.

This system is going to be a BI system so I've also tried to install and
cluster Analysis Services with little success.

I get a strange error in the app evnt log.

Category (289) Event ID:0
The service cannot be started: The following system error occurred: An
attempt was made to access a socket in a way forbidden by its access
permissions.

The cluster account has local admin permissions on all the cluster nodes,
and I've followed the white paper to configure the cluster.

I've been clustering SQL for years and SQL 2005 always seems to be work
straight away.

I've removed it using the correct cli method and reinstalled, but I seem
to
get the same error....?

Any ideas? before I try and log a formal fault call with MS..?

Regards,

Sean
Error is

#18

Hi All,

I've fixed this by removing the local instance of SSAS on both nodes and
then reclustering with 1 clustered instance of SSAS then patched to SP2.

Weird sort of issue or as MS would say Undocumented feature for x64.

Regards,

Sean

"Geoff N. Hiten" wrote:

Quote:

Check that the service account is NOT a domain admin.

Apply SP2 and it should clean up some of the compatibility issues.

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

"Sean (UK)" <Sean (UK)@discussions.microsoft.com> wrote in message
news:FF711332-6309-4BC8-B5C8-9A26CD83507A (AT) microsoft (DOT) com...
Hi All,

I have a strange error with SQL2005 x64 on a HP DL580g5 x64 (Win23k R2 +
Sp2).

I've installed SQL2005 DB and cluster it no problem at all.

This system is going to be a BI system so I've also tried to install and
cluster Analysis Services with little success.

I get a strange error in the app evnt log.

Category (289) Event ID:0
The service cannot be started: The following system error occurred: An
attempt was made to access a socket in a way forbidden by its access
permissions.

The cluster account has local admin permissions on all the cluster nodes,
and I've followed the white paper to configure the cluster.

I've been clustering SQL for years and SQL 2005 always seems to be work
straight away.

I've removed it using the correct cli method and reinstalled, but I seem
to
get the same error....?

Any ideas? before I try and log a formal fault call with MS..?

Regards,

Sean
Error is

#19

Hi All,

I've fixed this by removing the local instance of SSAS on both nodes and
then reclustering with 1 clustered instance of SSAS then patched to SP2.

Weird sort of issue or as MS would say Undocumented feature for x64.

Regards,

Sean

"Geoff N. Hiten" wrote:

Quote:

Check that the service account is NOT a domain admin.

Apply SP2 and it should clean up some of the compatibility issues.

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

"Sean (UK)" <Sean (UK)@discussions.microsoft.com> wrote in message
news:FF711332-6309-4BC8-B5C8-9A26CD83507A (AT) microsoft (DOT) com...
Hi All,

I have a strange error with SQL2005 x64 on a HP DL580g5 x64 (Win23k R2 +
Sp2).

I've installed SQL2005 DB and cluster it no problem at all.

This system is going to be a BI system so I've also tried to install and
cluster Analysis Services with little success.

I get a strange error in the app evnt log.

Category (289) Event ID:0
The service cannot be started: The following system error occurred: An
attempt was made to access a socket in a way forbidden by its access
permissions.

The cluster account has local admin permissions on all the cluster nodes,
and I've followed the white paper to configure the cluster.

I've been clustering SQL for years and SQL 2005 always seems to be work
straight away.

I've removed it using the correct cli method and reinstalled, but I seem
to
get the same error....?

Any ideas? before I try and log a formal fault call with MS..?

Regards,

Sean
Error is

#20

Hi All,

I've fixed this by removing the local instance of SSAS on both nodes and
then reclustering with 1 clustered instance of SSAS then patched to SP2.

Weird sort of issue or as MS would say Undocumented feature for x64.

Regards,

Sean

"Geoff N. Hiten" wrote:

Quote:

Check that the service account is NOT a domain admin.

Apply SP2 and it should clean up some of the compatibility issues.

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

"Sean (UK)" <Sean (UK)@discussions.microsoft.com> wrote in message
news:FF711332-6309-4BC8-B5C8-9A26CD83507A (AT) microsoft (DOT) com...
Hi All,

I have a strange error with SQL2005 x64 on a HP DL580g5 x64 (Win23k R2 +
Sp2).

I've installed SQL2005 DB and cluster it no problem at all.

This system is going to be a BI system so I've also tried to install and
cluster Analysis Services with little success.

I get a strange error in the app evnt log.

Category (289) Event ID:0
The service cannot be started: The following system error occurred: An
attempt was made to access a socket in a way forbidden by its access
permissions.

The cluster account has local admin permissions on all the cluster nodes,
and I've followed the white paper to configure the cluster.

I've been clustering SQL for years and SQL 2005 always seems to be work
straight away.

I've removed it using the correct cli method and reinstalled, but I seem
to
get the same error....?

Any ideas? before I try and log a formal fault call with MS..?

Regards,

Sean
Error is