Fixed DotNetPanel ASP.Net 4.0 not installed

Recently I found out when you have ASP.Net 4.0 installed from your server but your DotNetPanel do not show it is installed. To fix it, simply modify your MSSQL database data.

1. you should backup your MSSQL database.
2. Open table ServiceDefaultProperties.
3. Check for the ProviderID of 2 and 101 if contain AspNet40Path(32 bits server) or AspNet40x64Path(64 bits server).
4. If not, add them to the MSSQL and point to the path as below.
AspNet40Path -> %SYSTEMROOT%\Microsoft.NET\Framework\v4.0.30128\aspnet_isapi.dll
AspNet40x64Path -> %WINDIR%\Microsoft.NET\Framework64\v4.0.30128\aspnet_isapi.dll

Check if ASP.Net 4.0 show from your server setting. If not, you may proceed to the step below.

1. Backup MSSQL database.
2. Open table ServiceProperties.
3. Check if AspNet40Path and AspNet40x64Path existed for each of the ServiceID.
4. If you have multiple web server and do not know which server belong to which ServiceID, open table Services and Servers.
5. Check for Services table and look for ProviderID of 2(IIS6) or 101(IIS7). Check for the ServerID and verify the server from Servers table.
6. Add the record as below.
AspNet40Path -> %SYSTEMROOT%\Microsoft.NET\Framework\v4.0.30128\aspnet_isapi.dll
AspNet40x64Path -> %WINDIR%\Microsoft.NET\Framework64\v4.0.30128\aspnet_isapi.dll

Schedule backup for MSSQL to remote computer

If you familiar with MSSQL maintenance plan and ever configured backup through this tool and you should know that to backup the MSSQL database to remote computer, you have to configure Log On setting from services.

Okay, today we assume that we couldn’t allow to change the setting from Log On setting and wish to set the schedule backup, we could use maintenance tool and batch command to schedule it.

Firstly, create a maintenance plan from MSSQL, then select “Back Up Database Task”. From Database(s) option, select your database name, you may specify the directory that wish to backup. From this article we make it to C:\mssql\backup\.

Next, create a batch file named mssql_backup.bat and insert command as below.

xcopy C:\mssql\backup "\\remote_server\c$\backup" /e /i /h /y

Where remote_server is your remote server name and you would like to place it to C:\backup.

Lastly, create Windows Task Scheduler and configure the mssql_backup.bat to run daily or weekly as your wish.