SQL SERVER – Change Password of SA Login Using Management Studio

RESOLUTION:

Login into SQL Server using Windows Authentication.

In Object Explorer, open Security folder, open Logins folder. Right Click on SA account and go to Properties.

Change SA password, and confirm it. Click OK.

Make sure to restart the SQL Server and all its services and test new password by log into system using SA login and new password.


APPLIES TO:
*Microsoft SQL Server 2008

Windows Mail / Outlook Express not present in Windows Server 2008

RESOLUTION:
You can install Windows Mail by installing the Desktop Experience.
To install Desktop Experience using Server Manager

1.Open Server Manager: click Start, point to Administrative Tools, and click
Server Manager.

2.In the Features Summary section, click Add features.

3.Select the Desktop Experience check box, and then click Next.

4.Complete the wizard by clicking Install.

APPLIES TO:
*Windows Server 2008 R2
*Windows Server 2008 Standard
*Windows Server 2008 Enterprise Edition

How to Create and delete User Account Via Dos Prompt ?

to add a user:

net user <username> <password> /add

to remove

net user <username> <password> /remove

Examples: net user yashraj raj143 /add
                  net user yashraj raj143 /remove

If you done correctly you got following message.

The command completed successfully. 

Try typing net help... or net help user. The former gives descriptions about each of the commands that can be used with net and the latter gives a description of the command net user.

Delete the Recycle Bin icon from the desktop

To delete the Recycle Bin icon from the Windows desktop follow these steps:
1. Open Registry Editor.
2. In Registry Editor, navigate to the following registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\Desktop\NameSpace
3. Find the following key:
{645FF040-5081-101B-9F08-00AA002F954E}
Delete the above key.

Note: As always, before making changes to your registry you should always make sure you have a valid backup. In cases where you're supposed to delete or modify keys or values from the registry it is possible to first export that key or value(s) to a .REG file before performing the changes.

4. Close Registry Editor.
There is no need to reboot. Just wait a few seconds and see how the icon disappears from the desktop.
5. In order to restore the Recycle Bin icon to the desktop just re-create the missing key (or import it back to the registry in case you've exported it earlier).
In Registry Editor, navigate to the following registry key:
KEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\Desktop\NameSpace
Create the following key:
{645FF040-5081-101B-9F08-00AA002F954E}

(just copy/paste, including the brackets).

APPLIES TO:
* Microsoft Windows XP Home Edition
* Microsoft Windows XP Professional
* Microsoft Windows 2003

How to log in automatically with Windows XP

CAUSE:
If you have recently updated your Windows with the Automatic Updates, you will notice that you will not be able to log automatically into your account. This is due to .NET Framework installation that automatically creates an additional account known as ASP.NET.

RESOLUTION:
1. Go to the "Start" button and choose "Run"
2. Then, copy and paste the command CONTROL USERPASSWORDS2. When done, click "OK"
3. From the given list, select the user that you want to allow automatic login on
4. Disable the option "Users must enter a user name and password to use this computer" and click "OK"
5. When done, enter the password for the user account to allow this option

APPLIES TO:
* Microsoft Windows XP Home Edition
* Microsoft Windows XP Professional

Task Manager has been disabled by your administrator

RESOLUTION:

Method 1

Click Start, Run and type this command exactly as given below: (better - Copy and paste)

Method 2

Download and run this REG fix and double-click it.

Method 3

• Click Start, Run and type Regedit.exe
• Navigate to the following branch:

HKEY_CURRENT_USER \ Software \ Microsoft \ Windows \ CurrentVersion \ Policies\ System

• In the right-pane, delete the value named DisableTaskMgr
• Close Regedit.exe

Method 4:  Using Group Policy Editor - for Windows XP Professional

• Click Start, Run, type gpedit.msc and click OK.
• Navigate to this branch:

User Configuration / Administrative Templates / System / Ctrl+Alt+Delete Options / Remove Task Manager

• Double-click the Remove Task Manager option.
• Set the policy to Not Configured.

Error message when you start the portable softwares

Error message when you start the portable software’s
The error reads something like:

"Application error. The instruction at "0x009452a1" referenced memory at "0x01830046". The memory could not be "read."



CAUSE:
It happened almost all the time when windows are improperly shut down or Restart

RESOLUTION: Go to Following Path where Y2k is your user name.

C:\Documents and Settings\Y2k\Application Data\Thinstall

And delete which portable software is not working.


APPLIES TO:
* Microsoft Windows XP Home Edition
* Microsoft Windows XP Professional

How to Find PHP Version of Hosting Server

Here is the Simple tip to do it easily.

Run http://yourdomain.com/phpinfo.php in your browser.

How to disable scan disk at Start up

CAUSE:
It happened almost all the time when windows are improperly shut down after a troubleshoot that scan-disk will run on the next reboot to check the contents of the hard disk.

RESOLUTION:
chkdsk is a command that check the disk surface whenever there is physical errors. To disable to chkdsk, you must run the Registry Editor (regedt32.exe)

In the Run tab type:

regedit

* Under the HKEY_LOCAL_MACHINE subtree, expand to:
\SYSTEM\CurrentControlSet\Control\Session Manager
then change the BootExecute entry to:


autocheck autochk *

*Finally exit the registry and restart your computer to save setting made to windows.

APPLIES TO:
* Microsoft Windows XP Home Edition
* Microsoft Windows XP Professional
* Microsoft Windows 2000

How To Block Websites Without Software, block websites

How To Block Websites Without Software, block websites.

Steps:-

1] Browse C:\WINDOWS\system32\drivers\etc
2] Find the file named "HOSTS"
3] Open it in notepad
4] Under "127.0.0.1 localhost" Add 127.0.0.2 www.sitenameyouwantblocked.com , and that site will no longer be accessable.
5] Save It

-So-

127.0.0.1 localhost
127.0.0.2 www.blockedsite.com

-->www.blockedsite.com is now unaccessable<--


For every site after that you want to add, just add "1" to the last number in the internal ip (127.0.0.2) and then the addy like before.

IE: 127.0.0.3 www.blablabla.com
127.0.0.4 www.blablabla.com
127.0.0.5 www.blablabla.com

etc