Category: IIS

  • How to list SQL Jobs using Query or SSMS?

  • How to enable “Windows Authentication” for your websites?

    There are few things which we need to do before access the website using windows authentication. Web.config: Add or replace existing Authentication Tag IIS Express with Visual Studio: Click on your project in the Solution Explorer to select the project. Open Properties pane suing F4. In the Properties pane for your project: a) Set “Anonymous…

  • Exception- The definition for user-defined data type ‘MyTypeList’ has changed.

    The definition for user-defined data type ‘MyTypeList’ has changed. Exception when we rename or changed any User defined TYPE and it used in stored procedures. Stored Procedures which is using this type variable will not run and throwing the exception. If we have large numbers of SP then it will to time consuming or irritating…

  • Missing Windows Authentication Feature IIS and Windows 10

    If you have windows 10 Home or SL version when might be you are unable to see Windows Authentication under IIS options when installing. To enable “Windows Authentication” either you need to upgrade the OS to Pro version or you can run this command to enable it. C:\WINDOWS\system32>dism /online /norestart /add-package:%SystemRoot%\servicing\Packages\Microsoft-Windows-IIS-WebServer-AddOn-2-Package~31bf3856ad364e35~amd64~~10.0.17134.1.mum The file name will…

  • How to Create Multiple SQL Server Instances on Same Server

    When you install SQL Server, the installation creates an instance (DEFAULT OR SQLEXPRESS) of SQL Server. In my case I have created instanace named DEVSQL. Some times we do need to create multiple instances based on requirements. To create more instances, start the setup again. The following screen appears when setup starts for the SQL…

  • How to install Koha – A Library Software on Ubuntu

    Step 1: Execute the script by giving the following command: #!/bin/bash #export HTTP_PROXY_HOST=10.3.100.207 #export HTTP_PROXY_PORT=8080 wget -O- http://debian.koha-community.org/koha/gpg.asc | sudo apt-key add – echo deb http://debian.koha-community.org/koha stable main | sudo tee /etc/apt/sources.list.d/koha.list sudo apt-get update sudo apt-get install libgd-perl sudo apt-get upgrade sudo apt-get install koha-common Koha installation gives error related with apache2-mpm-itk issue. The…

  • SQL Server 2016 Always Encrypted Timeout at IIS

    Always Encrypted is a feature designed by the Microsoft in SQL Server 2016 to protect sensitive data, such as credit card numbers or national identification numbers (SSN). It allows clients to encrypt sensitive data inside client applications. When you work with Always Encrypted in development environment, it will be works fine because it requires certificate…

  • JSON date to Date object – javascript

    While working with web services or API with json return, we will get date values in different format, we can’t use this as is where required. To convert to date object we need to extract integer value and then pass to Date object, below example shows how to get valid date object. [javascript] var json…

  • Debugging VS2013/VS2015 Websites Using 64-bit IIS Express

    If you are working on ASP.NET MVC web sites in Visual Studio 2013 (VS2013) or 2015 (VS2015), and want to debug 64bit application, you need to do following changes in Visual Studio. f you don?t do this, you will likely get a message similar to: ?Could not load file or assembly or one of its…

  • How to enable HTTP Compression of Static and Dynamic Contents IIS

    Enabling compression of static and dynamic contents of your website will be more help to load your website faster on browsers. To enabling both you must have to install “Dynamic Compression” and “Static Compression” on the server features and roles. Open server manager Roles > Web Server (IIS) Role Services (scroll down) > Add Role…