Summer Device Update

Here are some highlights from the summer device update from Kalvin Falconar at Microsoft.

Surface Family Flyer PDF
Windows Device Choices June 2014

Introduction

Earlier in June the Surface Pro 3 was announced and Surface Authorized Device Resellers are already shipping the i5 version.  Surface Pro 3 will also be available in i3 and i7 sometime in August, along with a new Surface Pro 3 Dock.   See attached for general specifications on the Surface Pro 3 and the Surface 2.  The Surface Pro 3 is already making an impact on healthcare, see below for details.  For availability, pricing and details please contact any Surface Authorized Devices Reseller or drop by a Microsoft Store

Also this month Xplore Technologies launched their new rugged tablet named “Bobcat”.  And from Lenovo the fabulous new ThinkPad 10 started shipping!  All very cool devices.

Windows Phone

As Canadian cellular operators are getting prepared to push out the new Windows Phone 8.1 update out shortly, this an opportunity to review an extensive list of new features for WP 8.1.  Check out “what’s new”!

http://www.windowsphone.com/en-US/how-to/wp8/basics/whats-new-in-windows-phone

Also, check out some of the new apps for Windows Phone…

Project My Screen App for Windows Phone - If you want to project your phone screen to an external display, you can use a USB cable to connect to a Windows device.

Adobe finally brings Photoshop to Windows Phone

Files App - Windows Phone now lets you browse your files

Healthcare

Surface Pro 3 is making an immediate impression in the healthcare market.  Check out the stories emerging in healthcare already…

Microsoft's latest tablet resonates with medical experts, and the company racks up health care customers.

Surface Pro 3 has already been well received by early adopters in the health care industry.

UPMC (University of Pittsburgh Medical Center) dumps the iPad for 2000 Surface Pro 3s

The Total Economic Impact™ Of Microsoft Windows Tablets

Cost Savings And Business Benefits Enabled By Windows Tablets For The Enterprise

Forrester collected data from 60 enterprise organizations currently using Windows or non-Windows tablets the subsequent analysis found a solid 128% ROI and many benefits specific to Windows devices: 

·         46% improved productivity for “road warriors”

·         Device consolidation and reduced device purchase costs

·         Reduction in annual device licensing, management, and support costs

·         Reduction in annual costs related to device security

·         Reduced errors from users of Windows tablet devices

Download the Forrester Total Economic Impact (TEI) study today!

  

Computex 2014

June 3-7, leaders from all over the world gathered in Taipei for Computex 2014, Asia’s largest information and communication technologies (ICT) show. Featuring industry leaders like Acer, ASUS, Intel, and AMD as well as emerging manufacturers that are leading innovation, this is the perfect forum to communicate the One Microsoft strategy.

In past years, the event team designed breakthrough exhibit spaces to showcase devices.

Some notable tablets innovations launched include:

Industrial Tablet IP65 rated 10.1” from SEWOO TECH CO., LTD, and a few others from the same manufacturer.

Rugged Tablet PC760 from Sambest Corporation

Tablet 10” from HOYA ELECTRONICS CO., LTD

We are seeing a vast number of tablet options from Asia now available to us in Canada, although many are consumer focused, there are many type of touchscreen and kiosk options that these low-priced devices can serve. 

Problem Starting SQL Server: Unable to Initialize SSL Support

Today I ran into a bit of a surprise trying to start a SQL server up from a reboot. The server was working before the reboot so I had a bad feeling that this issue might be difficult. The first thing I did is check the SQL server log to see what happened.

2014-08-23 02:09:44.63 Server      Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) 

                Dec 28 2012 20:23:12 

                Copyright (c) Microsoft Corporation

                Standard Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)

2014-08-23 02:09:44.63 Server      (c) Microsoft Corporation.

2014-08-23 02:09:44.63 Server      All rights reserved.

2014-08-23 02:09:44.63 Server      Server process ID is 3704.

2014-08-23 02:09:44.63 Server      System Manufacturer: 'VMware, Inc.', System Model: 'VMware Virtual Platform'.

2014-08-23 02:09:44.63 Server      Authentication mode is WINDOWS-ONLY.

2014-08-23 02:09:44.63 Server      Logging SQL Server messages in file 'E:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG'.

2014-08-23 02:09:44.63 Server      The service account is 'DOMAIN\databaseservice'. This is an informational message; no user action is required.

2014-08-23 02:09:44.63 Server      Registry startup parameters: 

                 -d E:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\master.mdf

                 -e E:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG

                 -l E:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\mastlog.ldf

                 -T 8295

                 -T 4199

2014-08-23 02:09:44.63 Server      Command Line Startup Parameters:

                 -s "MSSQLSERVER"

2014-08-23 02:09:44.77 Server      SQL Server detected 1 sockets with 2 cores per socket and 2 logical processors per socket, 2 total logical processors; using 2 logical processors based on SQL Server licensing. This is an informational message; no user action is required.

2014-08-23 02:09:44.77 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.

2014-08-23 02:09:44.77 Server      Detected 8191 MB of RAM. This is an informational message; no user action is required.

2014-08-23 02:09:44.77 Server      Using conventional memory in the memory manager.

2014-08-23 02:09:44.82 Server      This instance of SQL Server last reported using a process ID of 4828 at 23/08/2014 2:05:00 AM (local) 22/08/2014 6:05:00 PM (UTC). This is an informational message only; no user action is required.

2014-08-23 02:09:44.82 Server      Node configuration: node 0: CPU mask: 0x0000000000000003:0 Active CPU mask: 0x0000000000000003:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.

2014-08-23 02:09:44.83 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.

2014-08-23 02:09:44.84 spid4s      Starting up database 'master'.

2014-08-23 02:09:44.93 Server      CLR version v4.0.30319 loaded.

2014-08-23 02:09:44.97 Server      Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\.

2014-08-23 02:09:44.99 spid4s      3 transactions rolled forward in database 'master' (1:0). This is an informational message only. No user action is required.

2014-08-23 02:09:45.00 spid4s      0 transactions rolled back in database 'master' (1:0). This is an informational message only. No user action is required.

2014-08-23 02:09:45.21 Server      Software Usage Metrics is enabled.

2014-08-23 02:09:45.29 spid4s      SQL Server Audit is starting the audits. This is an informational message. No user action is required.

2014-08-23 02:09:45.29 spid4s      SQL Server Audit has started the audits. This is an informational message. No user action is required.

2014-08-23 02:09:45.32 spid4s      SQL Trace ID 1 was started by login "sa".

2014-08-23 02:09:45.42 spid4s      Server name is 'SERVERNAME'. This is an informational message only. No user action is required.

2014-08-23 02:09:45.43 spid14s     The server could not load the certificate it needs to initiate an SSL connection. It returned the following error: 0x8009030e. Check certificates to make sure they are valid.

2014-08-23 02:09:45.43 spid14s     Error: 26014, Severity: 16, State: 1.

2014-08-23 02:09:45.43 spid14s     Unable to load user-specified certificate [Cert Hash(sha1) "A2489BCC04B0E33E4564C32D59E758B9E672280C"]. The server will not accept a connection. You should verify that the certificate is correctly installed. See "Configuring Certificate for Use by SSL" in Books Online.

2014-08-23 02:09:45.43 spid14s     Error: 17182, Severity: 16, State: 1.

2014-08-23 02:09:45.43 spid14s     TDSSNIClient initialization failed with error 0x80092004, status code 0x80. Reason: Unable to initialize SSL support. Cannot find object or property. 

2014-08-23 02:09:45.43 spid4s      Failed to verify Authenticode signature on DLL 'E:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\ftimport.dll'.

2014-08-23 02:09:45.43 spid14s     Error: 17182, Severity: 16, State: 1.

2014-08-23 02:09:45.43 spid14s     TDSSNIClient initialization failed with error 0x80092004, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. Cannot find object or property. 

2014-08-23 02:09:45.43 spid14s     Error: 17826, Severity: 18, State: 3.

2014-08-23 02:09:45.43 spid14s     Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.

2014-08-23 02:09:45.43 spid14s     Error: 17120, Severity: 16, State: 1.

2014-08-23 02:09:45.43 spid14s     SQL Server could not spawn FRunCommunicationsManager thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

Luckily this wasn't so bad, if I look through the log the following error popped out:

The server could not load the certificate it needs to initiate an SSL connection. It returned the following error: 0x8009030e. Check certificates to make sure they are valid.

I took a quick look at the certificate store for the machine and noticed that the SQL Server identification certificate was missing. To browse the certificate store for the machine launch MMC.EXE, select File then Add/Remote Snap-in...

Select Certificates then Add.

Select Computer Account then Next.

Click Finish.

Expand the Certificates node, expand Personal and select Certificates.

Below is a screenshot of the certificate that should be present.

To regenerate the certificate open the IIS 7 control panel and select the server then double click Server Certificates.

On the right hand side of the screen select Create Self-Signed Certificate.

Enter in the FQDN of the local server.

You should see a certificate for your server name and the Issued By field should match.

Open SQL Configuration Manager, expand the SQL Server Network Configuration node then right click Protocols for MSSQLSERVER. Select Properties to continue.

Select the Certificate tab and use the drop down to select the self-signed certificate you created. You can double check this by making sure the Issued By field matches the server name.

The following warning should appear, click OK.

Select the SQL Server  Services node, right click SQL Server and select Start.

If everything goes as planned your SQL server should be up an running. Also if you wish you can opt for a different certificate if you have PKI infrastructure in place but I kept this post simple since the certificate that comes with your Configuration Manager 2012 installed on top of SQL server is self-signed.

Take a look at the following article if you want to use a PKI to deploy a better certificate for this purpose.

http://www.jamesbannanit.com/2011/04/certificate-requirements-for-sccm-2012/

SMS_HEIRARCHY_MANAGER_ERROR 3353

I recently found an unusual way that this error can manifest itself in a site. I was deploying sites successfully except one of them cropped up with the SMS_HEIRARCHY_MANAGER_ERROR 3353. If you look at the error message below it makes the issue out to be a SQL communication issue with through a firewall.

What made the situation unique was that the secondary site experiencing issues had the Windows firewall service disabled. Once we turned on the Windows firewall and disabled all profiles (to match the other servers in this environment) the status messages went away. To be clear we didn't need to add the firewall exceptions we just needed to disable the firewall but leave the service running. I assume this error is being triggered because CM can't properly determine the firewall state when the service is disabled.

Troubleshooting the Migration Manager: Configuration Manager failed to gather data from .

Recently I was working on setting up a migration manager connection from a Configuration Manager 2012 site of questionable health to a clean site. In the process I got hung up on an error message that suggested several potential causes for my issue but wasn't terribly concise.

The next step was to figure out what the text logs have to say about this because I thought I had covered off all the culprits listed above. When I checked the migmctl.log on the site server I was performing the migration to I noticed there was something SQL related I wasn't expecting.

[MigrationManager]: Set the schedule item 16777217 to Failed.

ERROR: [MigrationManager]: Error occurred when trying to make sql connection to server.domain.com. Contact product support for help. Error Information -2146232060, Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

I didn't really troubleshoot why the authentication was not happening in depth because the account to be used for the SQL connection was in the same domain as the SQL server. As I result I opted to create a local account on the source server and give it SA rights to SQL. This in turn resolved the issue and I could continue on to making migration jobs.

Disabling SMB 1.0

So some of you might be curious about SMB 1.0 and weather you can turn off the protocol. The bad news is that if you are still running Windows XP or Windows Server 2003 there is a need to still run that protocol. If you are running filers it would be important to double check the support and configuration of these devices. In some cases Unix devices using Samba may require this protocol as well.

Ideally from a security perspective this protocol is dated and on its death bed so it should be disabled. The performance and security is better with the newer implementations and this should be an incentive to make sure your environment is specifically configured to use SMB 2.0 or better. I've been surprised at how many environments still run SMB 1.0 on their filers just because they never got around to applying updates or changing the infrastructure configuration.

To perform a quick test you can use the following Powershell 3.0+ command line to disable SMB 1.0.
Set-SmbServerConfiguration –EnableSMB1Protocol $false 

If you are running Powershell 2.0 you can achieve the same result with the following Powershell command line.
Set-ItemProperty -Path "HKLM:\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters" SMB1 -Type DWORD -Value 0 -Force

For more guidance you should also reference the following Microsoft KB for disabling SMB protocols.
http://support.microsoft.com/kb/2696547

And if you are up for some reading Microsoft has a wonderful 394 page document on the V2 and V3 specifications.
http://download.microsoft.com/download%2F9%2F5%2FE%2F95EF66AF-9026-4BB0-A41D-A4F81802D92C%2F%5BMS-SMB2%5D.pdf

April / May Windows Devices

Here is the latest list of devices:

https://onedrive.live.com/redir?resid=D1376BA87A35887F%215462

A Note from the Author: Kalvin Falconar @ Microsoft

The attached Windows Device Choices – April 2014 spreadsheet contains many new mobile devices.  It has been reorganized with tabs for Device Choices (Commercial Tablets & Phones), Rugged + Specialized, Retail and Healthcare specific.  When I discover specific unique devices, or accessories, I will continue to update this spreadsheet.

Windows Phone 8.1 – Cool New Features

Last week Windows Phone 8.1 was announced – more personal and even smarter than Windows Phone is today. Some of the cool things showcased:

·         Cortana - your personal digital assistant. With a name inspired by the popular AI character from Halo, Cortana builds a relationship with you by learning about your interests and habits and then brings information to you as you need it. You can talk to Cortana through your voice or your keyboard, and when she replies you’ll notice she has a real personality!

·         An enhanced Start screen: Between the ability to customize your Start background with a photo and the option for a third row of tiles on all phones, Windows Phone 8.1 provides you with an even bolder canvas for expressing your individuality

·         Delighters such as Action Center, which lets you see notifications from any app, a new Calendar with week view and integrated weather like you get in Outlook, and the new Word Flow keyboard that lets you glide quickly over the keys to type and learns your writing style too

·         A new Skype app, split Music, Video and Podcast apps, and cool features that help you get the most your data allowance, battery life and storage: Data Sense, Wi-Fi-Sense, Storage Sense and Battery Saver

·         Amazing new ways that Windows and Windows Phone work together: Synced tabs and favourites with Internet Explorer 11 for Windows Phone, newer apps that let you purchase once and use on both your phone and PC, and theme colour changes that follow you across all your Windows devices!

And with Windows Phone 8.1, Microsoft has made it easier to connect with business apps and services with suite of new features, such as VPN and S/MIME support and customizable Mobile Device Management (MDM) enrollment. With great new features for consumers and businesses, Windows Phone will become THE #1 phone choice for Enterprise.

Note that Windows Phone 8.1 availability for customers is dependent on the mobile operator or phone manufacturer, and will vary by country, region, and hardware capabilities. Cortana will launch shortly here in the US first as a “beta,” and then will launch in the US, the UK and China in the second half of 2014 with other countries to follow afterwards into 2015.

Developers can download Windows Phone 8.1 immediately here:

http://www.windowsphone.com/en-us/store/app/preview-for-developers/178ac8a1-6519-4a0b-960c-038393741e96?signin=true

Initial Reviews here:

http://www.wpcentral.com/windows-phone-81-review

http://www.engadget.com/2014/04/14/windows-phone-8-1/?utm_source=Iphone_Featured_Stories_RSS&utm_medium=feed&utm_campaign=Engadget

Windows 8.1 Update - Enhancements and Improvements

Windows 8.1 Update represents a great collection of improvements that give people even more familiar and convenient experiences. Microsoft has delivered easier access to your favourite apps and controls:

·         The ability to pin both desktop apps and apps from the Windows Store to your desktop taskbar

·         Power and search buttons in the upper-right hand corner so you can more quickly shut down and do a search right from the Start screen

Some of our biggest Windows fans are diehard keyboard and mouse users, so while we think touch is the future, for people using a PC without touch or folks who just prefer to mouse/keyboard we made Windows 8.1 Update easier with enhancements such as:

·         Right-click on an app tile to get a menu

·         Scrolling to the top of a Windows Store app to see the familiar Close and Minimize buttons

·         Moving the mouse to the bottom of the screen in a Windows Store app to make the taskbar appear

Apps continue to be a focus area from the standpoint of making even more apps available to customers as well as making them easier to find. With Windows 8.1 Update, we’ve made improvements in the discoverability of apps:

·         The Windows Store is now pinned on the taskbar for fast app discovery

·         Apps in the Windows Store show up in Bing Smart Search results.

One of the best new features for Windows 8.1 Update is Internet Explorer 11 Enterprise Mode that enables Internet Explorer 8 compatibility on Internet Explorer 11, allowing enterprises to run their existing web-based applications seamlessly on Windows 8.1 devices. If you find users are installing Chrome or Firefox for compatibility, you have to check this out immediately and test it in your environment.  Available now, for Windows 8.1 and Windows 7.

Windows 8.1 Update is available for consumers on April 8th via Windows Update and Windows Store, for developers on MSDN/TechNet it was available , with full media published on April 8th, and for enterprise customers via VLSC on April 14th.  

New Windows Tablets for March (yes, I',m late)

Just a FYI here is another list of new Windows tablets being made available.
https://onedrive.live.com/redir?resid=D1376BA87A35887F%214480


Also if you are curious about business cases I have a total economic impact report on using Windows tablets in retail.
https://onedrive.live.com/redir?resid=D1376BA87A35887F%214481