Reset all user passwords within an ou to the same password

A quick and easy way to reset all the passwords for users in a particular OU is to run the following command in a command prompt window on the domain controller. The below will reset all the passwords to “password”.  Change your OU references to your own settings.

C:\>dsquery user OU=tech,OU=australia,DC=waynestorey,DC=com | dsmod user -pwd password

If you have more than 100 users within that OU then use the following command changing the number after -limit to a number greater than the number of user objects

C:\>dsquery user -limit 100 OU=australia,OU=tech,DC=waynestorey,DC=com | dsmod user -pwd password

Add a static route to Windows

To add a static route to windows you can use the route command:

To view the existing routes on a machine. Open a command prompt and type the following:

route print

To add a static route:

route add <target> mask <netmask> <gateway IP> metric <metric cost> if <interface>

eg. route add 192.168.1.0 mask 255.255.255.0 10.10.1.1 metric 1

The above static route will only be available till the machine in rebooted. To add a persistane route (one that lives after a reboot of the machine) add the -p switch to the command.

eg. route -p add 192.168.1.0 mask 255.255.255.0 10.10.1.1 metric 1

The following registry key holds the values for static routes.

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters\PersistentRoutes

As with other command prompt commands you can view all the options this command offers by typing route /? at the command prompt.

Fatal Error when clicking on Services and Applications in Computer Management

This error came about when upgrading to MS SQL 2005 on a Windows 2003 SBS R2 Server from MS SQL 2000 on SBS 2003. During the process of upgrading we encountered a blocking condition which made us fully uninstall all instances of MS SQL 2000 Standard and the 2005 Desktop Engine.

To get this error we need to go to Computer Management and click on Services and Applications.

—————————
Fatal Error
—————————
Execution cannot continue as the language dependent resource file C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\3081\sqlmmc.RLL could not be loaded.
—————————
OK
—————————

After clicking on the OK button it appears that everything works correctly but it’s still annoying for the client and myself.
To get rid of this error I found a copy of sqlmmc.dll in the folder “C:\Program Files\Microsoft SQL Server\80\Tools\Binn” and copied it to C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\3081\ (I had to create the 3081 folder) and renamed the file extension to .rll.

The error has now disappeared.