I've got a SQL Server 2008 R2 Express running on a Windows Server 2008 R2 Web edition.
Evertything works great except that the SQL service doesn't start automaticaly on server boot.
The SQL Service, the agent and the server browser are set on automatic.
The server is a clean install with an IIS and the sql server only.
Once the server is started, I can start the service manually and it works just fine.
The only error I have in the log is "The SQL Server (SQLEXPRESS) service terminated with service-specific error The requested address is not valid in its context." In details, there is a param2 : %%10049.
Any help would be greatly appreciated since it is a production server. Each time it restarts, the website is down until I manually start the SQL service.
Best Answer
Is that error from the Windows Event log or the SQL Server Log? (It sounds like an Windows service error, not the sort of detailed error that would be reported by SQL and kept in it's error log.) The windows Event log is visible through the Event Viewer and the SQL Server log can be seen through SSMS.
It is pretty rare to not have decent error messages in one log or the other. If you haven't already, have a look in the SQL Server error log (including the older ones when the service fails) and see what looks different between a failed start and a successful start.
WAG: Is there something that prevents exclusive access to the file? Something like a virus scanner that scans on boot, or a SAN connection that takes a while to come online?