#Update SQL 2008 r2 Service Pack 2 into SQL 2008 r2 Installation Pack - Slipstream procedure

Install SQL 2008 R2 in Windows server 2012 Cluster required SP


1. Download SQL 2008 r2 sp2. Save in C: drive
     http://www.microsoft.com/en-my/download/details.aspx?id=30437

2. Extract SQL sp2 to C: drive.
    Command prompt: SQLServer2008R2SP2-KB2630458-x64-ENU /x:C:\SP2

3. Run the Service pack setup files.
    Command prompt: SP2\1033_enu_lp\x64\setup\sqlsupport_msi\sqlsupport.msi



4. Run the SQL setup files from SQL media kit.

     a) Change directory. Command prompt: z:    (my media kit in Z:)

     b) Run setup.  Command prompt: setup.exe /PCUSource=C:\SP2

    

    Note: If install SQL 2008 r2 in Windows Server 2012, Program Compatibility Assistant will prompt. Select Run the program without getting help.

5. Install SQL as normal.

6. Verify have completed a slipstream update.

    a) On Installation Rules, Update Setu Media Language Compatibility show in list as below.

    b)On ready to install, right panel under action, install slipstram show as below.

Source: http://support.microsoft.com/kb/955392/en-us

#Windows Server 2012 - Install .Net Framework 3.5 features

First remove windows update KB below if installed.

• KB2966826
• KB2966827
• KB2966828

Method 1

1. Add feature, select .Net Framework 3.5 features

2. Select Specify an alternate sources path (highlighted) 

3. Enter D:\Sources\SxS\     (D: = Windows server installation kit or mount the ISO, my drive here is D:)

4. .NET Framework installed.

Note: If unable to install, try copy ISO to local disk and mount agains, or change another installation kit.

#Hyper-V - Live Migrating "Migration Attempt Failed" - Error 1205

Hyper-V Live Migrating "Migration Attempt Failed" - Error 1205

Error 1205 The Cluster service failed to bring clustered service or application "ServerName" completely online or offline. One or more resources may be in failed state. This may impact availability of clustered service or application.

Method

Disable antivirus or

Antivirus scan exclude "ClusterStorage" folder

exclude *.XML
              *.VHD
              *.VHDX
              *.AVHD
              *.AVHDX
              *.VFD
              *.VSV
              *.ISO

exclude VMMS.exe
              VMWP.exe

Optional:
exclude C:\ProgramData\Microsoft\Windows\Hyper-V
              C:\Users\Public\Documents\Hyper-V\Virtual Hard Disks

#Hyper-V - Remove Hidden Network Adapter

Remove Hidden Network Adapter

-Cannot rename this connection. A connection with the name you specified already exists. Specify a different name.
-The IP address XXX.XXX.XXX you have entered for this network adapter is already assigned to another ....



1. System properties > Advanced > Environment Variables...

2. On System variables, select New..., on Variable Name enter devmgr_show_nonpresent_devices

on Variable Value enter 1

3. On Device Manager, click on view, select Show hidden devices.

4. Expend Network adapters, uninstall hidden network.

Hyper-V  (Microsoft Hyper-V Network Adapter)

Physical   (Physical Network Adapter)

*Don't uninstall RAS Async Adapter or any other than Microsoft Hyper-V Network Adapter/Physical Network adapter.





#Windows Server - Reset Windows 2012 Domain Administrator Password

Reset Windows 2012 Domain Administrator Password

1. Boot Installation CD, select Repair your computer

2. Select Troubleshoot.

3. Select Command Prompt.

4. Change directory to d:\windows\system32

 5. Type copy utilman.exe utilman.exe.bak to Backup utilman.exe
     Type move cmd.exe utilman.exe to Move cmd.exe to utilman.exe
     Type Y to overwrite.

6. Restart server and boot windows as normal.
     Press “Windows Key + U” to open command prompt.

 7. Type net user administrator password
     Password = new password

8. Close command prompt and log in with new password.

Enable Physical Address Extension (PAE)

For Windows Server 2008 Enterprise/Datacenter 32-bit RAM access more than 4GB of pysical memory.

Method:

1. Run command prompt as Administrator.
2. Type bcdedit /set PAE forceenable.
3. Restart Server.

Memory Limit for windows releases: http://msdn.microsoft.com/en-us/library/aa366778(VS.85).aspx#physical_memory_limits_windows_server_2008

Sources: http://msdn.microsoft.com/en-us/library/aa366796(v=vs.85).aspx

#Microsoft Office 365 - Reset All Users Passwords in PowerShell - Additional for password never expired

     1.  Install Microsoft Online Services Module for Windows PowerShell

     2.  Run Microsoft Online Services Module for Windows PowerShell as Administrator

     3.  Type Import-Module MSOnline

     

     4.  Type Connect-MsolService -cred $cred

    

     5.  Insert Office365 admin user name and password

      6.  Type Get-Command -Module msonline

     7.  Type Get-msoluser |set-msoluserpassword -newpassword “password” -forcechangepassword $false

     8.  Password will start reset for all users                              

Source: http://onlinehelp.microsoft.com/en-us/Office365-enterprises/hh124998.aspx

additional: Password never expired 

For all users: Type Get-MSOLUser | Set-MsolUser -PasswordNeverExpires $true

For individual user: Type Get-MSOLUser -example@domain.com -PasswordNeverExpires $true -StrongPasswordRequired $true