We built a SQL Server 2008 two node failover cluster (Operating System:
Windows Server 2008). The SQL Server Resource is working but the SQL
Server Agent-cluster resource is missing in cluster management after
installation (contrary to the SQL Server 2005 cluster installations). Is
this correct?. When trying to start SQL Server Agent we get the
following error: SQLServerAgent could not be started (reason: Unable to
connect to server '(local)';
SQLServerAgent cannot start). The SQL Server Fulltext-cluster resource
is also missing.

Are you sure SQL is installed to the cluster and not locally on one node?

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


"werner" <mayerw (AT) uni-mainz (DOT) de> wrote

Yes, SQL is installed to the cluster. The SQL Server-cluster Resource
works on both servers of the 2-node cluster.

Geoff N. Hiten schrieb:

here are some informations concerning sql server 2008 cluster setup
(Operating System Windows Server 2008 x64):

Installation Option: Advanced cluster preparation.
After that: Installation of the RU2-Package SQLServer2008-KB958186-x64.
After that: advanced cluster completion

SQL Server Service-Cluster online with the correct SPN (cluster service
domain account).


werner schrieb: