Adding a New User for the eNewsletterPro database using SQL Server Express
  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 eNewsletterPro 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 "eNewsletterPro" 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 eNewsletterPro database.

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

  10. Check off the Map checkbox next to the eNewsletterPro 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.

 

AdComplete.com, LLC    4536 Grove Park Dr.    Tallahassee Florida,  32311
Phone (407) 551-0777 
Copyright (c) 2001-2007 AdComplete.com, LLC All Rights Reserved