Hi have a windows 2008 enterprise installation with plesk control panel wich has had all of the components installaed by plesk that one of them is SQL server 2005

LAst Day I reboot the server and after booting the windows I noticed that the SQL server 2005 cant start.I attempted to restart but it couldn’t start.
I checked the services in SQL server Configuration Manager properties and noticed that both sql sever Browser and SQL SERVER(MSSQLSERVER) are stopped
I attempted to restart SQL server Browser and luckily it restarted without any problem
but the attempt to restart the sql server service was result-in failure

I check the logs and noticed this error

I find out that the reason SQL erver cant start is it can not read and write the log file located here
C:\Program Files\Parallels\Plesk\Databases\MSSQL\MSSQL.1\MSSQL\DATA\fnphysic_pnu_log.LDF
AN Idea came into my mind that it may because of some ermission conffilict may have came into the the log file named fnphysic_pnu_log.LDF

as I didn’t really know what correct permission should be assigned to this log file and maybe it has been corrupted I decided to move that to other directory and attempt to restart SQL server again and have this file on elsewhere for backup purpose
Unbelievably MS SQL SERVER 2005 could be restarted without any problems and creted its own log file.

I offer you if you have faced the same problem to try the same work I done that way it may fix your problem easily

Thanks Voshka Niknam

Related posts:

1. Plesk 9.0.1 Disk usage and traffic 0 problem
2. fixing MySQL manager or server PID file could not be found! [FAILED] in DirectAdmin
3. fix diretadmin php compiling error gcc: /usr/lib/mysql/libmysqlclient_r.so: No such file or directory make: *** [libphp5.la] Error 1
4. dot net panel installation error “sql server does not exist or access denied”
5. fixing Starting httpd: Syntax error on line 35 of /usr/local/directadmin/data/users/mainr/httpd.conf: Invalid command ‘php_admin_flag’, perhaps misspelled or defined by a module not included in the server configuration
6. Fixing Apache Error Name or service not known: mod_unique_id: unable to find IPv4 address of
7. fixing [ERROR] /usr/libexec/mysqld: Can’t create/write to file ‘/var/run/mysqld/mysqld.pid’ (Errcode: 13)