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

Can not start MSSQL service by normal Windows account Expand / Collapse
Author
Message
Posted Saturday, June 5, 2010 10:41 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC 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
Posted Sunday, June 6, 2010 8:31 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:22 AM
Points: 5,888, Visits: 13,061
As local system works it sounds like a permissions issue.

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


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

Post #933233
Posted Sunday, June 6, 2010 9:19 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC 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
Posted Sunday, June 6, 2010 9:32 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:22 AM
Points: 5,888, Visits: 13,061
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
Posted Sunday, June 6, 2010 8:07 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC 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
Posted Monday, June 7, 2010 4:27 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:22 AM
Points: 5,888, Visits: 13,061
right click server name, select properties, select security tab and amend the startup service account.

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

Post #933410
Posted Tuesday, June 8, 2010 12:35 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC 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
Posted Tuesday, June 8, 2010 6:05 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:22 AM
Points: 5,888, Visits: 13,061
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 »

Add to briefcase

Permissions Expand / Collapse