Showing posts with label Product. Show all posts
Showing posts with label Product. Show all posts

Friday, February 26, 2010

Cannot open user default database. Login failed. Login failed for user ‘UserName’. (Microsoft SQL Server, Error: 4064)

Obliviously, I deleted the database which I had set as the default database to my login in SQL Server 2008. To change it, I double-clicked on my login under Security -> Logins but it threw me an error stating unable to login to default database. After a headache of 20 minutes, I found the solution:
1. In the Connect to Server window, click on the Options button.

2. Under the Connection Properties tab, type the name of the existing database or the default database (usually 'master') at 'Connect to database:' option. (Drop-down will again try to connect so its no use of trying).

3. Then click Connect. Voila!



Thought this might be helpful than to try other sqlcmd options from the command prompt.

Friday, July 3, 2009

Windows Activation

Finally I have learnt the art of cracking Windows Activation after much research. Before I get into the steps, it would be justified if I throw light on the technical aspect of this Windows Activation.

In order to reduce Windows OS piracy, Microsoft came up with an idea which is the Windows Activation. Even though you own a genuine copy of Windows OS, you cannot use it every time you reinstall the OS. You would need to acquire Microsoft's permission (now that's really irritating) which is the Windows Activation. Once the OS is installed using the genuine OS discs, a message would pop up stating that Windows needs to be activated within 30 days.

When you opt to activate it immediately, it would open the Activation window providing the option to activate either thru Internet or Phone. If Internet is chosen, it would connect to Internet and the product would be activated. If Phone option is chosen, it would display an installation ID. You would need to choose the country for the phone number, call them and provide this ID and they would return another ID which you would require to enter in the provided box.

Now what is this ID that is displayed in the window? The ID corresponds to your hardware components like your motherboard, RAM and processor and the Windows Product Key. When you install the OS for the very first time, your hardware information is stored against the particular Product Key. Then every time you re-install in the same computer, Microsoft checks whether the OS is installed in the same computer or another by checking the installation ID that you provide to them (brilliant, huh?). If the ID differs, they might ask you the reason for the re-installation and after some time, they would say that the OS has expired and cannot use it anymore.

No, we'll beat them by using the genuine OS without the activating.

First, if you are re-installing it in the same machine, then all you need to do before re-installing is to a backup of two files: wpa.dbl and wpa.bak. These files can be found in the system32 folder of your Windows installation directory. After the re-installation, restore these two files to the same folder in Safe Mode.

Second, if you are installing it in a different machine, then there are series of steps to be followed:
  1. After the re-installation, start the computer in Safe Mode and log on using an administrator account.
  2. Click on Start -> Run, type regedit and hit Enter. The Windows Registry would be displayed.
  3. ExpandHKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\WindowsNT\CurrentVersion\WPAEvents.
  4. Take a backup of the registry before modifying (find instructions towards end of blog).
  5. On the right panel, you would find a key named OOBETimer. Double click on it to modify its contents.
  6. Delete all the values and then type the following (without the quotes): "FF D5 71 D6 8B 6A 8D 6F D5 33 93 FD"
  7. Click Ok.
  8. Then right-click on the WPAEvents key on the right panel and select Permissions.
  9. Click on SYSTEM under Group or user names and select Deny Full Control. Click Ok.
  10. Close the Registry window and restart.
When clicked on the Windows Activation pop-up, it will display "Windows is already activated. Click Ok to exit."

Voila! We did it.

Wait, wait, its not over. This will work only till the 30 days. After 30 days, Windows will prompt to activate the product while logging in. Now since we had activated the product thru the back door, Windows would display the "Windows already activated" depicted in the image above. When you click Ok, it would log you out. This will go on in an endless loop. Now, don't ask what's the point in using the OS only for 30 days. Where there's a will, there's way.

What we need to do is to remove the script to check the product activation during the startup.
  1. Start the computer in Safe Mode and log on to an administrator account.
  2. Click on Start -> Run, type regedit and hit Enter.
  3. In Registry Editor, expand My Computer, and then expandHKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/WindowsNT/CurrentVersion/Winlogon/Notify.
  4. Under Notify, right-click RESETS, and then click Delete.
  5. Click Yes to confirm the removal of the RESETS subkey.
  6. Exit the Registry window and restart.
Now, you will not get the prompt to activate windows during Windows logon.

Don't curse me if this didn't work or the Resets key is not found in the Registry. There's another workaround for the same. Take a copy of the winlogon.exe (found in system32 folder of Windows installation directory, e.g.: c:\windows\system32) from any activated computer and replace it in the same folder in your machine where the product needs to be activated. Do this in the Safe Mode. If you are unable to replace, rename the existing one and then copy this to the system32 folder.

Steps to backup and restore registry:
  1. Once you are the location where the key needs to be modified, click on File -> Export in the Windows Registry window.
  2. The following dialog box will be displayed:
  3. Make sure that the key you want to update is mentioned properly under the Expand Range column.
  4. Then click on Save.
  5. To restore, just double-click on it and confirm the same.
Guys, that was a really huge article that I'm writing after so many days. I have verified the steps and assure that it works. If it doesn't work, please contact Microsoft for further instructions.

Thursday, June 11, 2009

Sun Direct DTH

After reading reviews after reviews about different DTH services (Tatasky, AirTel, DishTV and Sun Direct) and comparing which one is better, I finally chose Sun Direct. Now don't say that I made a wrong decision. Lemme justify my decision.

Pros:
1) Being in the southern part of the country, majority of the channels I would subscribe would be the regional ones. Since SUN Direct originates from the southern part, they can cater to the needs of the southerners in a better way.

2) On comparing with the first time fee (includes installation, cost of STB and free subscrption), Sun Direct offered 5 months free subscription to an amount almost touching the rates of other service providers.

Cons:
1) On reading numerous reviews, the first black mark I came across against Sun Direct is their poor customer service. It is because of the estimated time the IVRS provides - sometimes it is more than 20 minutes just to speak to a service personnel either for an enquiry or a recharge/addon. However, when I started experimenting it, I found their 1800 number is quicker. Also, there were numerous complaints about their web site not loading properly. Also, they do not have an option to recharge thru Credit/Debit card. So you need to purchase the recharge coupon from its retail outlet and end up waiting on the call to its customer service. So why I did chose in spite of these many after sales-service complaints? Its because the recharge, add-on packages and checking balance options are available thru the SMS option which is better and faster than their customer service.

2) Yes, few of their channels like Star Cricket, Ten Sports, etc. lack the quality where you can experience shadowing of images on screen but it is tolerable when the service comes cheaper.

To conclude, if you are from the southern part, better opt for Sun Direct. Remember, every thing in this world has its own pros and cons. Better way would be to know how to overcome it than regretting for it.