I need to restart SQL server service using my classic asp website, for that I have created batch file on the windows server which got installed sql server.
Command in batch file :
NET STOP SQLSERVERAGENT
NET STOP MSSQLSERVER
NET START MSSQLSERVER
NET START SQLSERVERAGENT
If I run the batch file manually by using remote desttop, its working fine. I'm calling this in asp page using ,
set wshell = CreateObject("WScript.Shell")
set wshell = nothing
this is not working. Can anyone guide me how to achive this.
Thanks in Advance,