Can not start MSSQL service by normal Windows account

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » Can not start MSSQL service by normal Windows...

Can not start MSSQL service by normal Windows account

Rate Topic

Display Mode

Topic Options

Author

Message

thang_ngo_2002

Posted Saturday, June 05, 2010 10:41 PM

SSC Journeyman

Group: General Forum Members
Last Login: Wednesday, June 20, 2012 9:11 AM
Points: 85, Visits: 363

I use Windows account instead of Local System account to start MSSQL service to make more secure. My Windows is stand-alone, not domain system.
It's ok for longtime, but in a beautiful day, after I stop service, I can't start it again, there is error "The MSSQLSERVER service depends on the Net Logon service which failed to start because of the following error: The operation completed successfully", then (I change to Log On by Local System account, it starts OK)
So what's wrong, why I can use Windows account before?
Thanks

Post #933199

george sibbald

Posted Sunday, June 06, 2010 8:31 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 4:02 PM
Points: 5,269, Visits: 11,203

As local system works it sounds like a permissions issue.

does the local windows account have logon as a service rights?

---------------------------------------------------------------------

Post #933233

thang_ngo_2002

Posted Sunday, June 06, 2010 9:19 AM

SSC Journeyman

Group: General Forum Members
Last Login: Wednesday, June 20, 2012 9:11 AM
Points: 85, Visits: 363

Yes, it can run as service, because I use windows account for long time, but now suddenly this issue happens

Post #933239

george sibbald

Posted Sunday, June 06, 2010 9:32 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 4:02 PM
Points: 5,269, Visits: 11,203

It may have lost some of its rights, so check. Have you tried reenabling the account as the logon account via EM, or a server reboot?

---------------------------------------------------------------------

Post #933242

thang_ngo_2002

Posted Sunday, June 06, 2010 8:07 PM

SSC Journeyman

Group: General Forum Members
Last Login: Wednesday, June 20, 2012 9:11 AM
Points: 85, Visits: 363

Could you please explain me detail how to "reenabling the account as the logon account via EM"?

Thanks

Post #933310

george sibbald

Posted Monday, June 07, 2010 4:27 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 4:02 PM
Points: 5,269, Visits: 11,203

right click server name, select properties, select security tab and amend the startup service account.

---------------------------------------------------------------------

Post #933410

thang_ngo_2002

Posted Tuesday, June 08, 2010 12:35 AM

SSC Journeyman

Group: General Forum Members
Last Login: Wednesday, June 20, 2012 9:11 AM
Points: 85, Visits: 363

I think this way equals to setup Log On account on screen of Windows services configuration

Post #933813

george sibbald

Posted Tuesday, June 08, 2010 6:05 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 4:02 PM
Points: 5,269, Visits: 11,203

no it doesn't, if you do it through EM the account will be assigned all the permissions it needs at the same time. doing it through the services applet does not do that, so you should always assign the service account through EM.

You only got away with it last time because you assigned local admin which has all permissions anyway.

---------------------------------------------------------------------

Post #933926

« Prev Topic | Next Topic »

Permissions