HTTPS with Visual Studio's built-in ASP.NET Development Server

You need to enable the SSL in the project by using the below steps:

• Enable the SSL with in IIS Express, you have to just set “SSL Enabled = true” in the project properties window.
  
• Then you can start your project with IIS Express normally and it will start using SSL, the new Port will be 44301

Note : https and http both ports are generally different. By default SSL enabled is set to false with IIS Express; so if you run your web application first time, you will only be able to find the default URL and you can access the site over http.

IIS - Isolated FTP

Follow the link to create http://www.vsysad.com/2015/02/configure-ftp-user-isolation-on-windows-server-2008-r2/

Ms Sql Server - The Visual Studio Component is out of date. Please restart Visual Studio. (Mscorlib)

SSMS Error: "The Visual Studio Component is out of date. Please restart Visual Studio. (Mscorlib)"

When you are trying to open Query or execute query in Microsoft SQL Server Management Studio, you may see the following message:

The Visual Studio Component is out of date. Please restart Visual Studio. (Mscorlib).

Cause: Sometimes cache of the Sql Server corrupted due to Updates in the visual studio or Sql-Server components updates.

Solution : 

STEP 1: Delete the Temp Files. Shortcut to delete the temp files

STEP 2: Restart Microsoft SQL Server Management Studio and the error message will have disappeared.

A network-related or instance-specific error occurred while establishing a connection to SQL Server - microsoft sql server error 2

SSMS Error: "A network-related or instance-specific error occurred while establishing a connection to SQL Server"

When you are trying to connect to a SQL Server using Microsoft SQL Server Management Studio, you may see the following message:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that the SQL Server is configured to allow remote connections. (provided: Named Pipes Provider, error: 40- Could not open a connection to the SQL Server) (Microsoft SQL Server, Error: 2).

While the message tells you to check some of the items that can cause this issue, it fails to mention that if your SQL Server Service is not started, then you cannot connect. One of the first things that you should check is that the SQL Server (MSSQLSERVER) is started. You can go to the Services Console (services.msc) and look for SQL Server (MSSQLSERVER) to see that it is started. If not, then start the service.

You could also do this through an elevated command prompt by typing net start mssqlserver.