Archive 2015

SQL 2012 install on Server 2012R2 “Error while enabling Windows feature NetFx3”

Problem… “Error while enabling Windows feature NetFx3″

We wanted to install APP-V 5.x on server 2008 running SQL 2008. At the very start this was a problem. Error you require a later version of the OS etc.

So we deployed 2012 R2, and then started to install SQL 2012….. error during install …

“Microsoft SQL Server 2012 Release Candidate 0 Setup
The following error has occurred:
Error while enabling Windows feature: NetFx3, Error Code: -2146498298, Please try enabling
Windows feature: NetFx3 from Windows management tools and then run setup again.”

Cancel install

We then tried to enable .NET Framework 3.5 on Windows Server 8 using the “Add Roles and Features Wizard” of Windows Serve 2012.

“Failed”

Next attempt.

Load 2012 disk & connect the server to the internet

Launch CMD as administrator

dism /online /enable-feature /all /featurename:NetFx3 /source:d:\sources\sxs

The operation finished successfully from the command prompt.

We then were able to install SQL Server 2012 successfully.

 

We also found this link to be useful for screen shots

 

TechUG Newcastle – 22nd September 2016- Time: 09:00 – 16:30

Technology User Group – Newcastle

“As an industry leader of user groups, we hold many local events throughout the year to create a buzzing community where like-minded IT professionals can meet up, hear about the latest developments and technologies in their field; network with local peers and have the chance to meet representatives from key technology solution providers that we tailor to each event. ” technologyug.co.uk/About-Us

Registration for the next event now open

TechUG Newcastle – 22nd September

Click here to register your free space now and quote referred by “StephenHackers”

Sorry, agencies need not apply. Tech user group.

Change user command to switch a Terminal Services server to Install mode.

KB 320185

How to put a Terminal Services server in Install mode.

You will need to switch to install mode, to install or remove programs on a terminal server.

The method I use the most is :
Open command prompt as administrator

Type:         change user /install
This will change the server to install mode.

Now your ready to install applications.

Switch Terminal Services to Execute Mode, when you are finished adding or removing programs.

Open command prompt as administrator

Type:         change user /execute

Users can now log in and start using the new applications

Trouble shooting a Disconnected Host in VMware vCenter

When your ESXi hosts are all setup up in vCenter and using HA and DRS but a blip happens, the power goes or  a host has a moment “not responding”.

disconnected host

In this  scenario we powered off the ESXi host.

What can you check?

Possible options. Try reconnecting the host if there has been no other changes

normal state reconnect

Watch the status bar for progress

Reconnecting host

What if it fails to connect like in the image below

failed to connect

  1. Don’t forget a few basic connectivity checks like…Can you ping the host?
  2. Can you connect to the ESXi host by DNS name or IP & local user and password using the vSphere client?
  3. Can you connect to any VMs which were / are still running on the disconnected host?
  4. Can you restart the management service on the ESXi host?
  5. Can you ilo to the ESXi host? Any errors /events logged on the host
  6. Any network switch down?
  7. Any SAN issues?

These are just a rough guide, it is no responsibility of the Author if you try any of these actions. Try at your own risk.

Trouble shooting VMware Virtual Center failing to start

We restarted the Virtual Center server during a routine maintenance window.

As a rough / quick test we then tried to connect via the client. To our shock, it didn’t connect

Client connection fails

How to Trouble shoot …..Where should you look next ?

Services?

Manual Service

Check for a stopped service on the vCenter server.

Start vcenter service

start vc service

In this scenario, check SQL , in the log you can see there is a SQL DB connection issue

VC no SQL connection

 

 

For Loop command to list users with sessions on servers

Problem :  Users/Admins disconnect from sessions on servers. How to get a list of users logged on to server active and disconnected

Simple Solution!

Create a file call servers.txt   – save in c:\temp

(possibly dsquery computer -name * >servers.txt    note your will need to delete all detail except server name)

Create a batch file call : listloggedinUsers.bat   – save in c:\temp

In the listloggedinUsers.bat type the following

for /f %%s in (servers.txt) do (echo %%s & qwinsta /server:%%s)

Save the bat file

Load command prompt as administrator.

Type
c:\temp\listloggedinusers.bat >> users_date_time.txt

This out put shows all 3389 connections. ie. RDP sessions

 

Disable inactive computers in AD

I would be tempted to run it manually in two parts.. that sounds a little cautious I know..

From your DC you can run

CMD ( as admin )
dsquery computer -inactive 8
(this lists the inactive computers- this list can include serveres!!!)

This will list the computers which have been inactive for 8 weeks or more.

Then you can choose to manually select the highlighted computers (from the query) in AD right click disable.
Or run    dsquery computer -inactive 8 | DSMOD computer -disabled yes

This will error if there is nothing to update “dsquery computer -inactive 8 | DSMOD computer -disabled yes”

I would not schedule this to run automatically.. Just in case it bins a server.. even though servers should never been offline for 8 weeks

Veeam Backup & Replication example

In this example we have VMware vSphere and Hyper-V in Veeam Backup & Replication.
vSphere And HyperV

In vCenter we can see two data center and the VMs running.

In Microsoft Hyper-V we have one Hyper-V server and VMs running.

Unfortunately we have deleted a VM. Ooops. But we can recover using Veeam Backup & Replication to recover the VM

VeeamVMrecover

Another VM recovered thanks to Veeam.

 

Veeam Explorer for Microsoft® Active Directory®

“Easy, fast, granular recovery of individual AD objects and entire containers.
And it’s absolutely FREE!” Veeam

Veeam Explorer is a part of Veeam Backup™ Free Edition

 

Veeam Explorer

“With Veeam Explorer™, you can look directly into your backups to zero in on the

exact items you need to recover and restore from:

NEW! Microsoft Active Directory: Restore individual Active Directory (AD)

objects quickly and export AD objects directly from an image-level backup for

use with the LDIFDE utility

ENHANCED! Microsoft Exchange: Get instant visibility into Exchange 2010 and

2013 backups, advanced search capabilities and quick recovery of individual

Exchange items (emails, contacts, notes, etc.), Online Archive mailboxes and

hard-deleted items

• Microsoft SharePoint: Browse SharePoint 2010 and 2013 backups and

databases, search for specific SharePoint files and quickly recover them

NEW! Microsoft SQL Server: Save time and restore SQL databases without

having to search for individual database files

ENHANCED! Storage Snapshots*: Recover single files or entire VMs from HP and

NetApp snapshots in 2 minutes or less—without staging or intermediate steps”

veeam_backup_8_free_edition_datasheet_en.pdf

 

 

Amazon Web Services (AWS) – PoC

  • Created an account – http://aws.amazon.com/
  • Setup a Windows 10 client
  • Installed using the download 3.4.3 x86 msi and ticked install paths.
    Tried x64 installed and had a few errors trying 3.5 version
  • The EB  Command Line Interface (CLI), used the following the guide
  • Followed the Amazon Install procedure below:

The Python Software Foundation provides installers for Windows that include pip.

To install Python 3.4, pip, and the EB CLI on Windows

  1. Install Python 3.4 from the downloads page of Python.org.
  2. Add the Python home and scripts directories to the Windows Path system variable:
    C:\WINDOWS\system32;C:\WINDOWS;C:\Python34;C:\Python34\Scripts
  3. Open the Windows Command Processor from the Start menu.
  4. Verify that Python and pip are both installed correctly with the following commands:
    C:\Windows\System32> python --version
    Python 3.4.3
    C:\Windows\System32> pip --version
    pip 6.0.8 from C:\Python34\lib\site-packages (python 3.4)
  5. Install the EB CLI using pip:
    C:\Windows\System32> pip install awsebcli
    Collecting awsebcli
      Downloading awsebcli-3.2.2.tar.gz (828kB)
    Collecting pyyaml>=3.11 (from awsebcli)
      Downloading PyYAML-3.11.tar.gz (248kB)
    Collecting cement==2.4 (from awsebcli)
      Downloading cement-2.4.0.tar.gz (129kB)
    Collecting python-dateutil<3.0.0,>=2.1 (from awsebcli)
      Downloading python_dateutil-2.4.2-py2.py3-none-any.whl (188kB)
    Collecting jmespath>=0.6.1 (from awsebcli)
      Downloading jmespath-0.6.2.tar.gz
    Collecting six>=1.5 (from python-dateutil<3.0.0,>=2.1->awsebcli)
      Downloading six-1.9.0-py2.py3-none-any.whl
    Installing collected packages: six, jmespath, python-dateutil, cement, pyyaml, awsebcli
      Running setup.py install for jmespath
      Running setup.py install for cement
      Running setup.py install for pyyaml
        checking if libyaml is compilable
        Microsoft Visual C++ 10.0 is required (Unable to find vcvarsall.bat).
        skipping build_ext
      Running setup.py install for awsebcli
        Installing eb-script.py script to C:\Python34\Scripts
        Installing eb.exe script to C:\Python34\Scripts
        Installing eb.exe.manifest script to C:\Python34\Scripts
    Successfully installed awsebcli-3.2.2 cement-2.4.0 jmespath-0.6.2 python-dateutil-2.4.2 pyyaml-3.11 six-1.9.0
  6. Verify that the EB CLI is installed correctly:
    C:\Windows\System32> eb --version
    EB CLI 3.2.2 (Python 3.4.3)

Install Python, pip, and the EB CLI on Windows