>> Adding New User
Adding a New User for the BanManPro database using SQL Server 2005 Express
Always create a separate user for your Ban Man Pro database.  Do not use an existing user such as the SA account for security purposes.

  1. Launch SQL Server Management Studio Express edition from your Start--Programs--Microsoft SQL Server 2005 menu and connect to the server.

  2. Create New Login for the BanManPro database.  Within SQL Server Management Studio Express, expand the tree down to Security then expand logins.

  3. Right-mouse click on Logins and Select New Login.

  4. Enter the Login name as "BanManPro" or choose another desired username.

  5. Choose SQL Server authentication.

  6. Enter a unique password then confirm the password.

  7. Uncheck the box "Enforce password expiration".

  8. Under Default Database, select the appropriate BanManPro database.

  9. On the left side, click "User Mapping".

  10. Check off the Map checkbox next to the BanManPro database.  At the bottom, click db_owner in addition to public.

  11. Click OK.  If you get an error relating to the password you must enter a longer password.

 

 
Copyright 1999-2007 AdComplete.com, LLC     |    Privacy Policy