September 17, 2002 at 12:37 pm
I am using a Domain account to start up this service. It is giving me an error message.
What rights does this need?
(I added the Domain account in Enterprise Manager but it still does not work)
HELP!!!!!!!!!!!
September 17, 2002 at 1:17 pm
What exactly is the error message you are getting?
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
September 17, 2002 at 1:28 pm
"The service did not return an error. This could be an internal Windows error..."
September 17, 2002 at 1:31 pm
I am assuming that the domain account has admin rights, if not add the account to the admins group then try it again.
When added, did you use "\\domain\userID" syntax to the SQL Server secutiry\logins? Good luck!
September 17, 2002 at 1:33 pm
So did it just not start? Have you looked in the LOG directory at the ERRORLOG file to see if there was some hint as to why the service will not start?
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
September 17, 2002 at 2:16 pm
Also check the Event Viewer for the server.
Steve Jones
September 17, 2002 at 3:31 pm
Can't put in Admin. group - security risk.
Solved:
The Domain Account needed permissions to the directory where SQL Server was installed.
The reason it did not was because an on ongoing "Lock Down" project.
September 17, 2002 at 4:02 pm
The Win user that starts the service, must be a member of the Local Administrators. And also check that the password doesn't expire.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply