June 15, 2009 at 3:41 am
Hi ,
I am not able to start the SQL Server ,SQLServer Agent Services ,
I have changed the service account password,stillnot able to start
Event Type:Error
Event Source:ClusSvc
Event Category:Failover Mgr
Event ID:1069
Date:15.06.2009
Time:11:35:41
User:N/A
Computer:CHRS1431
Description:
Cluster resource 'SQL Server (PIN)' in Resource Group 'CHRS1431_PIN' failed.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Could you please help on this
June 15, 2009 at 3:52 am
You obviously running SQL Server on a cluster.
In that case the service account used to start the windows clustering service must have access to SQL Server. Usually after you installed SQL Server on a cluster this account has access through the Built-in|adminitrators group. When you remove this group you need to add the accountas a new Login in SQL Server.
Start the server in single user mode with minimal configuration and add a new login for the clustering service.
From a command prompt run:
sqlservr.exe -m -f
If it is a named instance you also have to add the -s paramater wih the instance name.
Hope this helps
[font="Verdana"]Markus Bohse[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply