Flipkart

Saturday, February 22, 2020

How to install Cisco VPN client on Window 10

From 2011 it's have been discontinued, Cisco VPN client is not supported by Windows 10. Cisco itself has stated in the past that the last supported operating system for its VPN client was Windows 7.

Download and install below setups.

First Install DNE update from below location





After DNE setup installation completed, 
Install Cisco VPN client

Follow the next steps by default no other changes require.

Extract the setup  and run as administrator “vpnclient_setup” and proceed the next steps and finish the setup.

Once installation done. Start the Cisco VPN application and add “pcf” profiles using imported button.

After all this, connect the profile that just added, it will prompt for user and password. Enter your credentials.





Follow the below steps: -
Open your Windows Registry Editor by typing regedit in the Window run.
From the window on right, select and right -click on Display Name and choose Modify from the menu. Alternatively, Double-click on Display Name.




Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\CVirtA
For Windows 10 64bit (x64) operating systems, change the value data from “@oem8.inf,%CVirtA_Desc%;Cisco Systems VPN Adapter for 64-bit Windows”
to
“Cisco Systems VPN Adapter for 64-bit Windows”       (shown below):


The registry key now shows the correct DisplayName value data:




You should be able to connect to your VPN Router or Gateway without any problems.

Tuesday, November 26, 2019

Install and Configure DHCP Server on Windows Server 2016


Step by step guide to install and configure DHCP Server in Windows Server 2012 R2. Dynamic Host Configuration Protocol (DHCP) is the core networking protocol to deploy Internet Protocol (IP) address automatically for network clients.

1. Install and Configure DHCP Server Role
To install DHCP Serve go to Dashboard on Server Manager and click Manage then click Add Rules and Features.



Server Manager Dashboard
In the Role installation window select Role-based or feature-based installation the click Next.



DHCP Server Destination Server


Select the Server you want to install DHCP from the Server pool. Here we have one server and select by default.


Add DHCP Server Role

From the Roles list select DHCP Server. When the Add Roles and Features Wizard Page opened, click Add Features then Click Next. This will install required features for DHCP Server.

 Windows Features
In the Features window don’t change anything, just click Next.


Give static IP address to system


Windows Features
In the Features window don’t change anything, just click Next.


DHCP Server Information

Once read the information about DHCP Server and click Next button.


Restart automatically

In the Confirm installation page, select Restart the destination server automatically if required. Click Yes the warning window and click Install.



DHCP Installation Process
The installation will take a minute, when it has complete successfully click Complete DHCP Configuration link.



 DHCP Post-Install
Read DHCP Post-Install configuration wizard description and click Next.


DHCP Authorization
Set the appropriate user for management of DHCP Server. Here I leave it by default, because the administrator has the right privilege to perform DHCP Server configuration.




DHCP Summary
On the DHCP summery window click Close and close the DHCP Installation page also.
2. Configure DHCP Server and Create Scope
Now try to configure the installed dhcp server and create Scope to lease IP address for clients.
 

DCHP Management Console

Type dhcpmgmt.msc in Windows Run and press enter to open DHCP management console.


Create New Scope
On DHCP console window expend the domain name and IPv4.  Right click the IPv4 the click New Scope.
 

New Scope Wizard
Click Next on the New Scope Wizard page.


Scope Name and Description
In the Scope name define the name of Scope and write any description then click Next.



IP Address Range
Assign the start IP address range and the end IP address range. I have set from 192.168.100.1 to 192.168.100.254 which is a class C IP address. Leave the length 24 by default and click Next.
 

Add Exclusion
Add the exclusive range prevent them from leasing to client by DHCP Server. The IP address range which reserved are used for Network Servers and popular workstation. Here I add 192.168.100.1 to192.168.100.15.  Just set the IP address and click Add button then click Next.


DHCP Lease Duration
Let the Lease Duration by default and click Next.


Configure DHCP Options
Only click Next the Configure DHCP Options and Yes, I want to configure this option now must be checked.



Router IP Address

If you have router in your network, set the router IP address and click Add button then click Next.


Domain Name and DNS Server
Type your domain name and it’s IP address then click Next.


WINS Servers
Do nothing for WINS Servers, because we don’t use WINS Server ether. Just click Next



Active Scope
In Active Scope windows click Next. Be sure the Yes, I want to active this scope now must checked.





Completing the New Scope Wizard
Finally click Finish to close and complete the installation of DHCP Server in Windows Server 2012 R2.



Friday, August 30, 2019

Check SQL Server system Date and Time


Using below commands you can check SQL server date and time.

Open query browser and type the following commands. And when you execute it output will come out.

Command : 1

Select CURRENT_TIMESTAMP;


Command : 2

Select SYSDATETIME();



In below Results column its show the current Date and Time.


Current TIME in Various Formats
Below are the examples of current TIME in various formats:

  1. Current TIME in the 24-hour format hh:mi:ss

SELECT CONVERT(VARCHAR(8), GETDATE(), 108) 'hh:mi:ss'


  1. Current TIME in the 24-hour format hh:mi:ss:mmm

SELECT CONVERT(VARCHAR(12),GETDATE(),114) 'hh:mi:ss:mmm'


  1. Current TIME in the 12-hour format hh:mi:ss:mmmAM

SELECT RIGHT(CONVERT(VARCHAR(26), GETDATE(), 109),14)
          'hh:mi:ss:mmmAM (or PM)'