July 25, 2008 at 9:29 am
Hi Ladies/Gents,
I have just installed SQL server and having used a windows domain account as the startup account, I am having some errors. It looks like it cannot read/write to the error log, but I have given it full control rights over the root drive i.e D:
But the funny thing is that if I make the domain account as part of the local administrators group, then it works. From what I have read in the past, its not a good idea to make the SQL startup account (domain) a local administrator.
Can you please guide me here and also tell me what the standard practice is for the sQL startup account (windows).
initerrlog: Could not open error log file 'D:\SQL\MSSQL\LOG\ERRORLOG'. Operating system error = 5(error not found).
July 25, 2008 at 9:32 am
For testing purposes, you could make the account an adminstrator on the box it's running on and see if the problem goes away. I suspect you have a rights issue....
July 25, 2008 at 9:39 am
If you are really using SQL Server 2005 and you set the service account to a domain account during setup then the setup handles setting the necessary permissions.
If you changed it after setup and you did not use the SQL Server Configuration Manager then you could have this problem. I would go to the SQL Server COnfiguration Manager, change the service account to local system, and then move it back to the domain account and see if that works.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply