Adding a New User for the eNewsletterPro database These instructions are for SQL Server 2000.  If you are using SQL Server 2005 Express, please click here.

Create New Login for the eNewsletterPro database.  Within SQL Server Enterprise Manager, expand the tree down to Security. Right-mouse click on Logins and Select New Login. Enter the name as "eNewsletterPro" Choose SQL Server authentication. Enter a unique password. Under Database, select the appropriate eNewsletterPro database. Select the Database Access tab. Click the Permit check box for the eNewsletterPro database. Next check the db_owner box under "Permit in database role". Click OK and confirm password.