SQL Server Performance Forum – Threads Archive
Status: SQL server starting ….
In one box i could see , SQL server service status as ‘starting..’. I tried to restart the service ,but still it showing same status ”starting..’ . Any one knows y this? -rajivReboot the server in order update and pending transactions on the registry.
If you are using any account to startup SQL Server services then ensure that account is not locked our or using a different password. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Both services are already running with ‘local system account’ .So i guess i have to re-boot the machine . What is the common practice of using accounts for Services. Local system or Local admin or Domain user ? -rajiv
IF the Scheduled jobs and DTS packages involves in network file copy or access to remote shares then it must be a domain user account with required privileges. Or you can create a similar local account with similar privileges that are similar to the other account on that remote server. Using local system account is not always required, in general it is used for a Destop edition. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
So it is always good to configure SQLserver and AGENT service with Domain user account(having admin privls), right. Is tht an ultimat soln? Or still there is any issue using a generic domain user account? i have one like domainMSSQLDBA for admin activities.
Do you have any such jobs that require network access or any remote server location to perform the task, if so then it is always suggested to have a domain account for SQLAgent account atleast. If that generic domain user account SQL has required privileges on the share, then it is ok. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>