Printable View
HEllo , SQL Server 2005 instance is installed on my computer the problem is that I cannot start the service for the SQL Server ,It Giving me the Following errors message:
Quote:
initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating system error = 5(Access is denied.). The event ID in the application log is 17058.
Please help me solve thanks in advance
You Can Set any of the SQL Server services to manual.then Reboot the computer and try to execute the sqlservr.exe in this folder in a command prompt: C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn
using sqlservr.exe -c About the error message is pretty straight forward. Does the SQL Server service account have permissions on that folder?
My Freinds had this same problem, The real Solution was to change the permissions, because Program Files (folder where the setup is installing the SQLSERVER) folder only to read, we changed it and the problems was resolved. and If you are using the Network Service as the service account? Change the service account to local system or a domain account and you will probably be ok.
SqlSrv.exe is the executable related to the Sql Server Service, you can manage this service thru the management console related You Can Get rid of the Error Event 17058 by putting the SQL Server on Manual from Automatic but there still remains this Warning. There must be an entry under Services Configuration Manager that will correct this
I have been running SQL Server for some time on the same system, but now get the 17058 error in the System Event log. When I run the sqlservr.exe from a command window, the info messages indicate access to the ERRORLOG file is fine. But I get a message of:
2010-12-22 09:09:32.55 spid51s Error: 245, Severity: 16, State: 1.
2010-12-22 09:09:32.55 spid51s Conversion failed when converting the nvarchar value '<hostname>\<dbname>' to data t
ype int.
where <hostname>\<dbname> are correct. And then it appears to hang.
Any thoughts on this?
Thanks