Token-based server access validation failed with an infrastructure error.

Recently I went in a newly built MS SQL Server 2008 R2 instance on Windows Server 2008 R2 server, I got login failure when trying to connect to SQL Server instance through SQL Server Management Studio (SSMS) using windows authentication. And I have added my account as SA in the SQL instance. I checked the error message detail. It was:

Error: 18456, Severity: 14, State: 11.

Login failed for user 'Domain\myuser'. Reason: Token-based server access validation failed with an infrastructure error.

This is the first time I got this error since I didn’t run any SQL server on Windows Server 2008 R2 before. After a little bit research, it was caused by UAC (User Access Control). I ran SSMS with option “Run as Administrator”. And I was able to login to SQL Server successfully. Here is a blog post explaining very clear about it.

How to enable new resolutions on Lenovo S10-3t

The best resolution for S10-3t is 1024x600. But actually it can support better resolution than that. Here is the trick to edit the registry to get new screen resolutions:

• Run "regedit.exe"
• Go to 
• HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\
  Control\Class\{4D36E968-E325-11CE-BFC1-08002BE10318}\0000
  
• Find "Display1_DownScalingSupported" and open it.
• Change the value to 1
• Close the registry and restart your system.
  

A best explanation of REST

Recently found a blog post has a clear explanation of REST protocol “Clarifying REST”.

Mobile’s three kingdoms story…

iOS: New versions are coming out every month. I have to upgrade again…

Android: New version is out. But when can I get the upgrade…

Windows Phone: New version is finally coming. But why can’t I get the upgrade…

Protect your information online

Here is a true story about how a hacker wiped out one tech writer’s online info, his iPhone, iPad and Mac. You may have heard about it.

http://www.wired.com/gadgetlab/2012/08/apple-amazon-mat-honan-hacking/all/

Here is a useful link to protect yourself.

http://gizmodo.com/5932663/9-things-you-absolutely-must-do-to-keep-your-online-identity-secure

How to drop a database with publication

I got a database on a log shipping subscriber server which I want to drop it. But the publisher database has some active publications. SQL Server doesn't allow you to drop it directly because it thinks it has replications going on. So the way to drop it is putting the database into Offline mode first. Then you should be able to drop it. (NOTE: PLEASE ALWAYS MAKE SURE YOU HAVE A BACKUP BEFORE DROPPING ANY DATABASE!!!)

ALTER DATABASE MyDB SET OFFLINE;