Quick Tip: Windows Server 2012 Internal Database Connection String

Today’s quick tip is for Windows Server 2012 and 2012 R2. If you’re attempting to use SQL Server Management Studio to manage the Windows Internal Database instance, the connection string has been changed.

To connect to Windows Internal Database on Windows Server 2012 and 2012 R2, you will need to use the following.

\.pipeMICROSOFT##WIDtsqlquery

SQL 2012 Connect to Server

Windows Server 2012 R2 is now available to MSDN / Technet Subscribers

Today, Microsoft has released the RTM Windows Server 2012 R2 bits to MSDN and TechNet subscribers.

Microsoft has said that they will be continuing to improve the product between now and General Availability in October.

Windows Server 2012 R2 brings a ton of awesome new features from refinements in Server 2012 R2 Essentials, to the Windows Server Essentials experience, improved support for BYOD with Work Folders and Active Directory, Storage Tiering in Storage Spaces, and many other awesome features.

To learn more about What’s New in Windows Server 2012 R2, I suggest visiting the TechNet Library, and reading Brad Anderson’s blog about the new features.

For the build curious amongst us, the build string for Windows 8.1 RTM is 9600.winblue_rtm.130821-1623. The SHA1 hashes for the ISO have been posted below along with steps to check the integrity of the downloaded ISO.

Hashes for today’s release:

en_windows_server_2012_r2_x64_dvd_2707946.iso
SHA1: B6F063436056510357CB19CB77DB781ED9C11DF3

en_windows_server_2012_r2_essentials_x64_dvd_2707177.iso
SHA1: 8A4CB96563DDA4F1BF637E57A992F3255D56B6F8

To run MSCDCRC against an ISO file that you have downloaded follow these steps.

  1. 1. Download MSCDCRC to the same folder that you downloaded the ISO to. (Click here to download MSCDCRC)
  2. 2. Open a Command Prompt window and navigate to the folder from Step 1
  3. 3. Type “MSCDCRC InstallDVD.iso” (without quotes)
  4. 4. The integrity check will take a few moments to complete. After the check is complete compare the CRC and SHA hashes to the hashes posted above

Windows 8.1 now available to MSDN and Technet Subscribers

Win8Blue_WebToday, in a change of heart, Microsoft has released the RTM Windows 8.1 bits to MSDN and TechNet subscribers.

In a blog post published by Steve Guggenheimer, Microsoft notes that they are working through how to best support developers and IT pros as they align to a faster release cadence.

In my opinion, it would have been much better to release the bits to developers and IT pros back around the original RTM timeframe, but this is better than nothing.

For the build curious amongst us, the build string for Windows 8.1 RTM is 9600.winblue_rtm.130821-1623. The SHA1 hashes for the ISO have been posted below along with steps to check the integrity of the downloaded ISO.

Hashes for today’s release:

en_windows_8_1_x86_dvd_2707392.iso
SHA1: 802CFCD3A411D99C097EA7E747F0B6697F9BDAC4

en_windows_8_1_x64_dvd_2707217.iso
SHA1: BC2F7FF5C91C9F0F8676E39E703085C65072139B

To run MSCDCRC against an ISO file that you have downloaded follow these steps.

  1. 1. Download MSCDCRC to the same folder that you downloaded the ISO to. (Click here to download MSCDCRC)
  2. 2. Open a Command Prompt window and navigate to the folder from Step 1
  3. 3. Type “MSCDCRC InstallDVD.iso” (without quotes)
  4. 4. The integrity check will take a few moments to complete. After the check is complete compare the CRC and SHA hashes to the hashes posted above
  5. 5. If the hashes match then you have successfully downloaded the ISO

Windows Server 2012 R2 Essentials Preview

Microsoft has released the public preview of Windows Server 2012 R2 Essentials. Windows Server 2012 R2 Essentials is Microsoft’s “first server” solution.

Included in Windows Server 2012 R2 Essentials are:

      • Backup of client computers
      • Support for Windows 8 and Windows 8.1 File History
      • Support for Storage Spaces
      • Remote Web access to files, folders, and computers
      • Remote Domain Join
      • New Modern-style app for Windows 8 and Windows 8.1 for accessing files and folders stored on the server
      • Integration with Office 365 or on-premise Microsoft Exchange
      • Improved dashboard
      • and more!

To download the preview of Windows Server 2012 R2 Essentials, go to http://technet.microsoft.com/en-us/evalcenter/dn205288.aspx

For additional resources go to http://technet.microsoft.com/en-us/evalcenter/dn205289

Windows Server 2012 R2 Preview Now Available

Tonight Microsoft has made available the public preview release of Windows Server 2012 R2. With this release, Microsoft is laying out its vision for what it calls the Cloud OS.

The Cloud OS is the platform that Microsoft is building with the release of Windows Server 2012 R2, System Center 2012 R2, SQL Server 2014 and Windows Azure. The four key tenets of the Cloud OS are:

      • Transform the Datacenter
      • Enable modern business applications
      • Empower people-centric IT
      • Unlock insights on any data

New to Windows Server 2012 R2 are such features as:

        • Storage Tiering within Storage Spaces
        • Software-defined networking
        • Virtual IP Address management
        • Windows Powershell 4.0
        • Windows Server Essentials Experience

To get started with the Windows Server 2012 R2 Preview, go to http://technet.microsoft.com/en-us/evalcenter/dn205286.aspx