Upgrading PowerShell Version 4 on Windows Server 2008 R2

Upgrading PowerShell Version 4 on Windows Server 2008 R2

By default PowerShell version 2 is available or installed on Windows Server 2008 R2 & Windows 7.

Prerequisites:

1. Install SP1 for Windows Server 2008 R2 or Windows 7.

2. Install Microsoft .NET Framework 4.5.1

 http://www.microsoft.com/en-us/download/details.aspx?id=40779 (Offline Installer)

3. Install Windows Management Framework 4.0 

http://www.microsoft.com/en-us/download/details.aspx?id=40855

Once both above things are installed reboot the Windows Server 2008 R2 server or Windows 7 machine.

Checking the PowerShell version

Need to run  $psversiontable, to check version for PowerShell

Thank You

Vikas Singh
Vikas.9452@gmail.com
VikasSingh.9452@hotmail.com

SQL Error: Cannot connect to - Login failed for User ‘SA’ (Microsoft SQL Server, Error: 18456)

Error: Cannot connect to

Login failed for User ‘SA’ (Microsoft SQL Server, Error: 18456)

Issue occurred:

The login may be a SQL Server login but the server only accepts Windows Authentication

Tried lots of other solution available on google but below solution worked for me on my production environment.

To resolve this issue, configure SQL Server in Mixed Authentication Mode. To do this, follow these steps:

1)    Click Start à click All Programs à click Microsoft SQL Server 20xx (where xx is the version of SQL), and then click SQL Server Management Studio.

2)    Right-click the server, and then click Properties.

3)    On the Security page, under Server authentication, click the SQL Server and Windows Authentication mode option button, and then click OK.

4)    In the SQL Server Management Studio dialog box, click OK to restart SQL services and try again to login with ‘SA’ account.

Applies to:

SQL Server 2014, SQL Server 2012, SQL Server 2008, and SQL Server 2005

Thank You

Vikas Singh

Vikas.9452@gmail.com

VikasSingh.9452@Hotmail.com

Microsoft Azure: How to reset a forgotten password for Virtual Machine on Azure

Microsoft Azure: How to reset a password for Virtual Machine on Azure

If you can't connect to a Windows virtual machine because of a forgotten password or a problem with the Remote Desktop service configuration, use the Azure portal or the VMAccess extension to reset the local administrator password or reset the Remote Desktop service configuration.

1. Go to https://manage.windowsazure.com

2. Click on Virtual Machine from left. Select Machine on which you want to reset password and Click on it.

3. Then you will get Dashboard of that Virtual Machine.

4 Then this page will redirect you to https://portal.azure.com

Then type on your Administrator Account name and Type password which you want to set, Once done. Click save.

That all now to try to login to you Virtual Machine with password.

Thank You

Vikas Singh

Vikas.9452@gmail.com

VikasSingh.9452@Hotmail.com

Part 1 - Downloading and Installing StarWind on Win2K16-DC01.

Part 1 - Downloading and Installing StarWind on Win2K16-DC01.

In this step I am going to install and configure StarWind on Win2K16-DC01.

1.1            Download the StarWind setup executable file and evaluation or free key from below link:

                                  https://www.starwind.com/registration-starwind-virtual-san

1.2            I have downloaded both StarWind setup executable file and evaluation on my Win2K16-DC01, run the executable file StarWind.

1.3            Read and accept the License Agreement, Click Next to continue.

1.4            Carefully read the information about new features and improvements.

1.5            Red text indicates warnings for users who are updating existing software installation, Click Next to continue.

1.6            Click Browse to modify the installation path if necessary, otherwise leave default and Click Next to continue.

1.7            Leave default and Click Next.

Note:

Full installation (recommended)

Full installation includes both StarWind Service and the Management Console elements. It allows users to manage storage resources on the machine where StarWind Virtual SAN is installed, as well as manage other StarWind Virtual SAN installations on the network.

StarWind Virtual SAN Service

This installation type is designed for Core OS editions. StarWind Service is the core of the software. It enables the creation of iSCSI targets as well as sharing virtual and physical devices. The service can be managed using StarWind Management Console from any Windows computer on the network.

StarWind Management Console

The Management Console is the Graphic User Interface (GUI) part of the software that controls and monitors all storage-related operations (e.g. allows users to create targets and devices on the available Virtual SAN servers). Once installed, StarWind Management Console is connected to the servers running StarWind Virtual SAN.

1.8            Specify the Start Menu folder if necessary, otherwise leave default and Click Next to continue.

1.9            Enable the checkbox if you want to create a desktop icon, Click Next to continue.

1.10       Then we prompted to request a time-limited fully functional evaluation key, or a FREE version key, or a fully commercial license key sent to you with the purchase of StarWind Virtual SAN. Select the appropriate option, Click Next to continue.

1.11       Click Browse to locate the license file, Click Next to continue.

1.12       Review the licensing information, Click Next to apply the license key.

1.13       Verify the installation settings. Click Back to make any changes, Click Install to continue.

1.14       Click Finish to close the wizard. Once you click on Finish.

1.15       Press Choose path and Select the Drive which you want to use, in my demo i am going to select E Drive. So select E Drive and Clink Open.

 Note: Each of the arrays which will be used by StarWind Virtual SAN to store virtual disk images has to meet the following requirements:

• initialized as GPT

• Have a single NTFS-formatted partition

• Have a drive letter assigned

1.16       Once you click on open, StarWind Management Console opens immediately. Which looks like below.

Note: The default login and password are “root” and “starwind”. You can always change them later. It’s strongly recommended to change the default username/password to protect your StarWind Server from unauthorized access.

Click Here For : Part 2. Creating Highly Available Storage for the Failover Cluster on Win2K16-DC01

Part 2. Creating Highly Available Storage for the Failover Cluster on Win2K16-DC01.

Part 2.     Creating Highly Available Storage for the Failover Cluster on Win2K16-DC01.

2.1            Press the Add Device (advanced) button on the toolbar.

2.2            Add Device Wizard will appear. Select Hard disk device and click Next to continue.

2.3            Select Virtual disk and click Next to continue.

2.4            Specify the virtual disk location and size, Click Next to continue.

2.5            Specify virtual disk options, (Leave default) Click Next to continue.

2.6            Specify Device RAM Cache Parameters, (Leave default) Click Next to continue.

2.7            Specify Flash Cache Parameters, (Leave default) Click Next to continue.

2.8            Specify target parameters, (Leave default) Click Next to continue.

2.9            Click Create to add a new device and attach it to the target. Then click Finish to close the wizard.

2.10       Repeat the steps from 2.1 to 2.9 to add one more virtual disks with size 200GB, which will be used as Cluster Shared Volumes.

2.11       Once all devices are created the Management console should look as below:

Click Here For: Part 3. Installing Failover Clustering and Multipath I/O features on HyperV01 and HyperV02