Re: SQL Server Error 17058
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?
Re: SQL Server Error 17058
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.
Re: SQL Server Error 17058
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
Re: SQL Server Error 17058
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