SQL Server wont Start

Question

SQL Server wont Start

alnor

Right there with Babe

Points: 762
More actions
January 16, 2019 at 10:56 pm

#381191

Hi Guys
Thought I would ASK
I have a sql server instance that wont start
Tried all the local system accounts - all failed
The service account with the correc t password will not work
the SVC accounmt is a member of Log on as a service
THe event log does not say much.
Thanks for any suggestions

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

alnor Right there with Babe Points: 762 More actions · Answer 1

From EventVWR system Logs

The SQL Server (MSSQLSERVER) service failed to start due to the following error:
The service did not start due to a logon failure.

All Login accounts give the same error message

Thanks

Eirikur Eiriksson SSC Guru Points: 182948 More actions · Answer 2

alnor - Wednesday, January 16, 2019 11:01 PM
From EventVWR system Logs
The SQL Server (MSSQLSERVER) service failed to start due to the following error:
The service did not start due to a logon failure.
All Login accounts give the same error message
Thanks

Have a look at this article, might help you find the cause.
😎

alnor Right there with Babe Points: 762 More actions · Answer 3

I resolved my Issue

not sure which one fixed the issue

SQL Config Manager

Add the login account , and password - Click on Apply then click on Start

also

Made sure Account has full folder permissions and permissions for each database (this took a bit of work - had to use advanced settings )

Thanks for your suggestion Eirikur

Sue_H SSC Guru Points: 90860 More actions · Answer 4

alnor - Thursday, January 17, 2019 3:24 PM
I resolved my Issue
not sure which one fixed the issue
SQL Config Manager
Add the login account , and password - Click on Apply then click on Start
also
Made sure Account has full folder permissions and permissions for each database (this took a bit of work - had to use advanced settings )
Thanks for your suggestion Eirikur

You don't have to do anything with permissions when you use SQL Server Configuration Manager as it handles the permissions and rights for the account and the virtual account, Not using that for changes is generally when problems happen.
When you had the login failures with the local system account, I would guess that the changes were made in the services applet and not in SQL Server Configuration Manager.

Sue