Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlsmith
Starting Member
2 Posts |
 Posted - 2011-12-07 : 09:30:01
|
| I am working on a system which has ms sql server 2008. The system has had sql server 2008 on it for a long while with no problems. About a week ago sql server 2008 failed to start automatically as a service upon startup. I attempted to start ms sql server 2008 as a service manually and it would not start either manually or automatically. It would not start as a service if I changed the startup options to manual and rebooted and attempted to start manually without having ever attempted automatic start. I did notice the error in the event log had to do with failing to write to ERRORLOG. I found the Log directory and the file, ERRORLOG, and could not delete the ERRORLOG file. I was able to rename the Log directory to Logorg and create a new dictory called Log and copy all the files from Logorg into Log except for the one corrupt file, ERRORLOG. The point is I intentionally did not copy the corrupt file. At this point, I realized I can navigate to the binn folder using windows explorer and start msqlserver by clicking on mssqlserver.exe and it will start up, but not as a service. This provides a work around, but does not solve the problem. The event log now reports initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'. Operating system error = 5(Access is denied.).For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.So I am wondering if the new Log directory does not have certain permissions on it or something like that. There are no corrupt files in the Log directory now. I have no idea why access denied is being reported.The operating system is windows xp home.My question is what can I do to enable ms sql server 2008 to again start up automatically as service upon startup and to be started as a service. Currently I cannot start mssql server2008 as service upon startup, from the control panel services window as a service after startup even after starting with mssql server service startup option set to manual, or from the configuration manager as a service after startup even after starting with mssql server service startup option set to manual. In summary I can no long start mssql server as a service and am prevented from using ms sql server management studio. I can use ms sqlserver management studio provided I navigate to the mssql server 2008 binn folder and click on mssqlserver.exe and start as a non-service as noted previously, and while this is a good workaround, it does not correct the problem which was introduced about a week ago. How can I correct the problem to again have the system operating fully functionally with regard to starting mssql server including as a service? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-12-07 : 13:17:54
|
| 1. Why do you think the error log is corrupt?2. Make sure service account has control permissions on the directory3. Did someone change the directory or drive to read only?4. Make sure the path to the error log is exactly the same as it was before you started moving stuff aroundCan also try starting sql server with -f or -m startup options if you've misconfigured something, fix it, them restart without startup param |
 |
|
|
sqlsmith
Starting Member
2 Posts |
Posted - 2011-12-07 : 17:28:47
|
| Russel,Thank you for your response. Russel, how do I make sure service account has control permissions on the directory?Someone has said I can do this from the sql server configuration manager. I don't see how.Personally, I think this is likely the problem.Remember this is windows xp home.SqlSmith |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-12-07 : 18:05:27
|
| You do this in Windows Explorer.This is Express or Developer edition? Else, it's not supported on XP Home. And you need at least SP3 on XP, I believe. |
|
|
|
|
|
|
|
|
mssql service fails to start