RE: Missing "SQL Server" & SQL "Server Agent" Resource after installat

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

For whatever its worth I've got the same issue.

Originally the agent would not even start on the second node, I found some
missing registry entries at:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL10.MSSQLSERVER\SQLServerAgent

So now it starts manually ok, but I would have expected there to me a
cluster resource for it.


"JP" wrote:

I installed SQL Server 2008 2 node Cluster on a Windows Server 2003
Enterprise 64-bit Server.

I opted for "Advanced Cluster Preparation" Option and prepared the two Nodes
and then performed "Advanced Cluster Completion".

SQL Server is installed on the cluster; however the "SQL Server" & "SQL
Server Agent" are missing (doesn't show up under Cluster Resources).

I tried to create the Resources manually, but received the message stating
the Resource Type is not found. How do I create a Resource Type manually?

Any help in resolving this issue will be appreciated. Thanks.

--
Regards,
JP
.