Tuesday, October 22, 2024
Run a Laravel application on Windows using Docker
Thursday, July 24, 2014
SQL Server: insufficient memory to continue the execution of the program (mscorlib)
When using large size SQL generated scripts to create/recreate databases, the above message is encountered.
To solve the issue, go to command prompt and issue the below command
c:\Program Files\Microsoft SQL Server\100\Tools\Binn> sqlcmd -S (LocalDb)\v11.0 -i D:\SQLDB\SqlserverScript.sql
Setting changes that you will need to do based on your environment
"c:\Program Files\Microsoft SQL Server\100\Tools\Binn" go to the folder where SQL server installed in your workstation
(LocalDb)\v11.0 - Replace this with your SQL server instance name
"D:\SQLDB\SqlserverScript.sql" - path to SQL script
Wednesday, October 2, 2013
IIS 7 - Setting up host headers using command line or batch file
As part of windows server administration, administrators may face a common problem in transferring the host headers when migrating web applications from one server to another.
A simple solution is to prepare a list of host headers and execute the addition of these host headers via a command line
Step 1: Go to C:\Windows\System32\Inetsrv
Step 2:
a) Execute the command to a "Site Host header" appcmd set site /site.name:"Website name on IIS Server" /+bindings.[protocol='http',bindingInformation='*:80:Site Host Header']
b) For specific IP binding appcmd set site /site.name:"Website name on IIS Server" /+bindings.[protocol='https',bindingInformation='10.0.0.10:80:sampledomain.com']
c) For HTTPS binding appcmd set site /site.name:"Website name on IIS Server" /+bindings.[protocol='https',bindingInformation='*:443:Site Host Header']
Friday, August 31, 2012
How to remove or modify "Server" http header in IIS 7 / IIS 7.5?
Server: Microsoft-IIS/7.0
Few methods are used to prevent IIS from sending the identification of the server to a client. This prevents the client from identifying the server hence delaying easy break through into the server.
One such method is writing a custom module (code given below) and saving the Class file under App_Code folder
Code from Stefan Gossner
using System;
using System.Text;
using System.Web;
namespace StefanG.ServerModules
{
public class CustomServerHeaderModule : IHttpModule
{
public void Init(HttpApplication context)
{
context.PreSendRequestHeaders += OnPreSendRequestHeaders;
}
public void Dispose()
{ }
void OnPreSendRequestHeaders(object sender, EventArgs e)
{
// modify the "Server" Http Header
HttpContext.Current.Response.Headers.Set("Server", "My Test Server");
}
}
}
Then, go to IIS 7 server and double click on "Modules". Then click "Add Managed Module". A dialog will open asking you to enter Name and Type. Enter a strong name for the module and choose the module (the one that we saved under App_Code) from the drop down and click OK. Restart the server.
Thats it! When you browse the website, Server identification will now be removed or modified based on the code in your module.
For IIS 6 UrlScan needs to be setup.
Thursday, August 30, 2012
How to remove ASP.Net version header from IIS 7 , IIS 7.5?
Add the following line to web.config within System.web node
<system.web>
<httpRuntime enableVersionHeader="false" />
</system.web>
Friday, March 23, 2012
How to check IP PING results automatically in Windows?
FOR /L %i IN (1,1,20) DO ping -n 1 192.168.1.%i | FIND /i "Reply">> d:\ipreplies.txt
Run the .bat file and it will save the results to "d:\ipreplies.txt"
In the above FOR loop we check for the usage of IP's starting from 192.168.1.1 incremented by 1 to 192.168.1.20.
Thursday, March 8, 2012
How to open a set of ports in windows firewall?
If you want to add multiple ports there is no option for you to open multiple ports (port range) with a simple addition of a filter.
To do this we need to type the following in the command prompt (Run > cmd):
FOR /L %I IN (9000,1,9100) DO netsh firewall add portopening TCP %I "Site Ports" %I
The ports will be incremented by 1 from 9000 until 9100.
In windows 2008 it is much easier than this. You can easily add a port range in the Firewall filter rules