dbTalk Databases Forums  

SQL Server and SQL Server Agent service cannot start on third serv

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss SQL Server and SQL Server Agent service cannot start on third serv in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Dovla
 
Posts: n/a

Default SQL Server and SQL Server Agent service cannot start on third serv - 12-04-2009 , 03:32 AM






SQL Server and SQL Server Agent service cannot start on third server.

We have 2- node Windows Enterprise 2003 x64 servers clustered in
active/active configuration with SQL 2005 x64 installed on it. Both servers
are domain controllers.
Now we try to add another node to the cluster. This third server is not
domain controller. We added new node to cluster and this work fine. Cluster
disk and other resource (IP address, network name) can be transformed to
third server. Then we changed SQL instance configuration and added third
server to possible owners of instance. Installations pass OK.

Problem is that we cannot move SQL instance to third server when user that
starts SQL and Agent services is normal user. When user is part of
administrators everything starts normally.
All HF and SP are installed.
User have privilege granted with GP – Log on as a services.

Logged error is:
Event ID: 17053
UpdateUptimeRegKey: Operating system error 5 (error not found) encountered.
Event ID: 17113
Error 3(error not found) occurred while opening file 'U:\Microsoft SQL
Server\MSSQL.5\MSSQL\DATA\master.mdf' to obtain configuration information at
startup. An invalid startup option might have caused the error. Verify your
startup options, and correct or remove them if necessary.
Event ID: 17053
UpdateUptimeRegKey: Operating system error 5(error not found) encountered.
Event ID: 17049
Unable to cycle error log file from 'U:\Microsoft SQL
Server\MSSQL.5\MSSQL\LOG\ERRORLOG.5' to 'U:\Microsoft SQL
Server\MSSQL.5\MSSQL\LOG\ERRORLOG.6' due to OS error '5(error not found)'. A
process outside of SQL Server may be preventing SQL Server from reading the
files. As a result, errorlog entries may be lost and it may not be possible
to view some SQL Server errorlogs. Make sure no other processes have locked
the file with write-only access.
Event ID: 19019
[sqsrvres] OnlineThread: ResUtilsStartResourceService failed (status 435),

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.