Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQLServer Services and Agent Expand / Collapse
Author
Message
Posted Monday, June 15, 2009 3:41 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Saturday, September 12, 2009 9:12 PM
Points: 65, Visits: 224
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
Post #734855
Posted Monday, June 15, 2009 3:52 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 7:32 AM
Points: 4,429, Visits: 4,182
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


Markus Bohse
Post #734860
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse