Addition of cluster node sets MSSQLSERVER path to UNC

Giganews Newsgroups
Subject: Addition of cluster node sets MSSQLSERVER path to UNC
Posted by:  Lightning-dave (Lightning-da…@discussions.microsoft.com)
Date: Mon, 27 Nov 2006

We're attempting to add a second node to a single node SQL Server cluster
running on Win2k SQL2k SP4. The install appears to work OK but when trying to
bring the SQL Server resource online the resource fails.

After some investigation we've discovered that MSSQLSERVER service has the
unc path to sqlservr.exe which the SQL Service account does not have access
to.

I've tried removing it from the cluster and readding but it's not made any
difference

Replies