MS SQL Server Windows Server 

Powershell script to check SQL service status and send email

In windows server we can create a PowerShell script to trigger an email on the basis of SQL service status. Solution Below The solution for checking the status of SQL Server service can be achieved by using the “Get-Service” cmdlet. In the below example we are using some common naming conventions of SQL server like MSSQL$, MSSQLSERVER, and SQL Server, etc. below code is to get the server status. Note: please check your SQL server name and replace them “MSSQLSERVER” in below code To send email we will use some…

Read More
SSL Certificate Windows Server 

How to add “Letsencrypt” free SSL in IIS server updated in Aug 2020

Letsencrypt is a free SSL Service provided by a group of an internet organization. It is a free, automated, and open certificate authority (CA), run for the public’s benefit.  Letsencrypt is a certificate authority which provides free SSL certificates with 90-days lifetime. The idea behind this innovation is to improve and simplify the process of SSL installation and make the Internet a safer place by providing certificates at no cost. While there are two main functions of SSL – encryption, and validation, Let’s encrypt is aimed at encryption only. Steps…

Read More
NodeJS Node JS Windows Server 

how to add SSL certificate in node server for webRTC app

I have gone through this problem when I was implementing webRTC signaling server in node.js using muaz khan webRTC experiments. I was running trying to run node on windows server 2012 R2 platform where I already hade a wildcard SSL certificate  (Wildcard SSL Certificate saves you money and time by securing your domain and unlimited sub-domains on a single certificate.) with my main domain so I was trying to implement using that certificate only, here is what I did to solve it. This process is for windows server: First, get .crt(certificate…

Read More
Windows Windows Server 

How to host SignalR with SSL/https or adding new port to SSL

To host SignalR server and client in a secure hosting, you have to bind a port to SSL to run as https. next comes why to bind a new port to SSL when 443 default already available? Why, because if you are self-hosting outside IIS and 443 is already assigned you have to add a new port to SSL. Follow below steps to find a solution. Binding a new port to SSL Self-hosting under HttpListener is good, but one of the negative aspects of not being part of IIS is…

Read More
MS SQL Server MS SQL Server SQL Windows Server 

How to configure SQL server to access it remotely

How to configure SQL server to access it remotely?, Actually this is not a big issue there are some straightforward steps to configure, but there might be a possibility of giving problem after configure using the same steps also. So go through the below steps carefully. To establish a successful remote connection is to set up ports through the Window Firewall. In SQL Server there are two types of instances. First is a default instance and the second is a named instance. To connect to the default instance of Database…

Read More
Hosting Windows Windows Server 

How to redirect HTTP to HTTPS URL in Windows server

Step1: Goto Windows Server and open IIS(internet information service) and select the site to which you want the HTTP URL to be redirected to HTTPS URL. Step2: Then in Management Section of the Site selected, find “web platform installer” and double click to open, here search for “URL rewrite” keyword after listing that install that to you server IIS. Note: If, after installing URL rewrite didn’t appear under IIS, please close and reopen the IIS, it will list under IIS tab. From here you can implement in to ways, Either you…

Read More