Windows 8 Treasure Hunt – The Series

Windows 8 Pro has been like a treasure hunt to me. On regular use I find some interesting things which I didn’t knew they existed.

I am going to list the features I like most whenever I encounter them and list them here.

Note: Windows® is a trademark of the Microsoft group of companies

Launching Windows control panel from run or command line

With Window 8 Pro ditching the start menu Nope, people have to resort to the multiple steps to launch control panel.

If you are in desktop mode all you need to do to launch control panel is, do the following.

  1. Press Windows Key + R to launch “Run” dialog
  2. Type “control” and hit enter

There… the control panel is launched Happy

Setting password for Managed Account

Password for Managed Account in SharePoint 2010 can be set in the following ways.

Set a new password for Managed Account

To update the account password to a new automatically generated value, from the Windows PowerShell command prompt, type the following:

Set-SPManagedAccount –Identity domain\user -AutoGeneratePassword $true

Update the password for a Managed Account that has already been reset through Active Directory

If the password for a managed service account has been manually changed outside of SharePoint (such as directly in Active Directory), you can update the password to the new value in SharePoint 2010 as follows

To update the account password to a already changed password, from the Windows PowerShell command prompt, type the following:

Set-SPManagedAccount -Identity domain\user -UseExistingPassword

For more information look at

Digitally Imported – Windows Radio Player

Music broadcast has come a long way from age old radio stations to digitally downloadable to online streamed contents. Online radio stations have survived for almost a decade and with decreasing internet tariffs they are fast becoming popular.

Couple of my favourite online radio station are and which have some awesome channels. These stations stream content in various formats such as MP3, AAC etc. The only problem with them is, you have to rely on their website to change the channels if used from desktop based systems.

Coming back to the problem of relying on website to change channels, I was planning to develop my own Windows desktop based client. While doing research related to this came across a project at DI’s forums called as “DI Radio Player”

It has some good features and few of my favourites are listed below.

  • Listing of current track
  • Choose radio stations
  • Choose channels
  • Auto Update
  • Visualization options

This radio player is based on .NET 2.0.

You can follow the following link to discuss and download the player.


Both these Digital Imported & Sky FM channels have awesome mobile clients (DI, Sky) in almost all mobile OS categories + For the upcoming Window 8 Pro OS based tablets, this app will be a good option. Especially with Intel Clover Trail

Installing SharePoint 2013 Prerequisites Without an Internet Connection

When a SharePoint 2013 needs to be deployed in a server which doesn’t have internet access, and SharePoint requires prerequisite to be installed, we can do couple of things.

  1. Download prerequisites in a different machine which has access to internet.
  2. Move that to the actual server where SharePoint needs to be deployed.
  3. Use prerequisite installer to use local folder for installing the prerequisite.

Downloading prerequisites

We can download prerequisites using Powershell. Please use the following script.

 Once all the prerequisites are downloaded, copy them to server in a particular path and create the following batch file.

 Installing prerequisites


Windows 8 – PC & Device Requirements

Following is the text from engadget regarding Windows 8 PC & Device Requirements.

  • ARM-based tablet users won’t be able to deactivate secure booting and (therefore) install another operating system.
  • Ctrl + Alt + Del for tablets without physical keyboards will be supplanted by Windows Key + Power.
  • There’s a mandatory five points of touch — which we already knew thanks to our hands on with Synaptics at CES.
  • If your gear has NFC, physical “touch marks” will be visible on the hardware so people know where to plonk their devices.
  • All tablets must have Power, Rotation Lock, Windows Key, Volume Up and Volume Down buttons.
  • After all operating system updates, there must be 10GB free space.
  • All machines must run UFEI Firmware.
    All hardware must include one USB 2.0 port, a magnetometer, speakers, Bluetooth 4.0, WLAN, gyroscope and accelerometer.
  • Any camera must have a minimum resolution of 720p.
  • The minimum display for any tablet is 1366 x 768.
  • You’ll be able to update your graphics drivers without rebooting.
  • Source:

If you want more detailed information take a look at Windows 8 Hardware Certification Requirements

Resetting an SQL Server account when there is no access through SQL Server Authentication


  1. SQL Server ‘sa’ or any user id is locked out.
  2. User has no access to SQL Server authenitcation.
  3. Windows Logged in user is part of Windows local Administrators group where the SQL Server is running and has currently logged into the machine.

Microsoft has removed the functionality of automatically adding the local windows system admin to SQL 2008 Users. The following solutions are workaround to get inside the SQL server by adding a user to SQL Users Table.

Note: Since this involves SQLCMD and starting, stopping of SQL Instance the logged in user should be an administrator of that server where the SQL Server is running and both solutions should be run under an elevated command prompt.

Solution 1 : (Little difficult Solution. Check Solution 2 for automated script by Microsoft)

Open command prompt.

  • If you have default instance run following command on command prompt to stop SQL service: “net stop mssqlserver”
  • Now go to the directory where SQL server is installed. In my case the directory is “C:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLBinn”. So need to run CD C:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLBinn.
  • Now run the following command to start sql server in single user mode. As we have specified “SQLCMD”, now only SQLCMD connection can be made.

sqlservr -m”SQLCMD”

  • Now open another command prompt window and write command SQLCMD
  • Run following two commands

EXEC sys.sp_addsrvrolemember @loginame = N’testAdmin’, @rolename = N’sysadmin’;

  • Go back to first command window and press Ctrl+C to stop the SQL server and then type ‘Y’ for confirmation. This will stop the sql server.
  • Start SQL server again and no startup parameters need to specified this time.
  • Now using SSMS, try to connect with “testAdmin” as user and “test@1234” as password.
  • Create your own logins.
  • Drop testAdmin as it is not required any more.

Note: If you do not have SQL authentication enabled then you can try adding your windows user and replace setp-6 with below queries. Here <<DOMAINUSERNAME>> is placeholder for your user name

create login [<<DOMAINUSERNAME>>] from windows;
EXEC sys.sp_addsrvrolemember @loginame = N'<<DOMAINUSERNAME>>’, @rolename = N’sysadmin’;


Solution 2 : (Easy Solution)

Download the following file, extract and run the cmd file in elevated command prompt.

%1 specifies the instance name to be modified. Defaults to SQLEXPRESS.
%2 specifies the principal identity to be added (in the form “<domain><user>”).
If omitted, the script will request elevation and add the current user (pre-elevation) to the sysadmin role.
If provided explicitly, the script is assumed to be running elevated already.

1) restart the SQL service with the ‘-m’ option, which allows a single connection from a box admin (the box admin is temporarily added to the sysadmin role with this start option)
2) connect to the SQL instance and add the user to the sysadmin role
3) restart the SQL service for normal connections

Messages indicating success/failure.
Note that if elevation is done by this script, a new command process window is created: the output of this window is not directly accessible to the caller.