Category: System Administration

Resetting the MS SQL sa Password – The Correct Way

If the user forgets the SQL password, then the user can ask the SQL SA (system administrator). It is because the SQL SA can easily reset the user’s password. But, what need to do if the administrator forgot the password?

Here is how to Resolve the issue;

Step 01

Try to Login into SQL Server using Windows Authentication (always try start with Run as Administrator)

If you can log into the SSMS, check whether SQL Server and Windows Authentication mode is enabled under the SQL server properties.

Continue reading “Resetting the MS SQL sa Password – The Correct Way”

Enable WDS Server selection from multiple WDS Servers

If you have multiple Windows Deployment Servers provisioned in the environment, you will need to enable the WDS server selection feature as below;

Simply go to (this needs to be done on the WDS role running instance):

HKLM\SYSTEM\CurrentControlSet\services\WDSServer\Providers\WDSPXE\Providers\BINLSVC and set AllowServerSelection to 1.

Then restart the Windows Deployment Service. After doing this you get the option to press F11 and the PXE client will now discover local PXE Servers and allow you to select which one you want to use.

Then you will get the opportunity to select the desired WDS instance.