• Go to Start->All programs->Microsoft SQL Server(client)->Enterprise Manager.
• Once the window opens, click on Action (second on the menu bar) and choose New SQL Server Registration. Make sure that before you click Action, you have SQL Server Group selected, under the Console Root.
  
• The Register SQL Server Wizard will open:
  • screen 1: just click next.
  • screen 2: double click on IISQLSRV to select it, then click next (If IISQLSRV does not appear in the available server list, type in IISQLSRV and click Add).
  • screen 3: select the second radio button for SQL Server Authentication.
  • screen 4: enter your username and password.
  • screen 5: click next
  • screen 6: click finish!
  • You will receive a message saying "IISQLSRV Registered Successfully". Congratulations!

CHANGING YOUR PASSWORD

The next thing you need to do right away is change your password. On the Console Root, expand Microsoft SQL Servers, then expand SQL Server Group, then expand IISQLSRV (Windows NT). Expand the Security folder and double click on Logins. All server logins will be listed on the right. Find your login, right click on it, and select properties. Type in your new password in the password field, and click OK. You will be prompted to re-enter the password. Do so,  and click OK. Now you are all set to start using SQL Server.