-
Launch SQL
Server Management Studio Express edition from
your Start--Programs--Microsoft SQL Server
2005 menu and connect to the server.
-
Create
New Login for the
eNewsletterPro
database.
Within SQL Server Management
Studio Express, expand the tree down to
Security then expand logins.
-
Right-mouse
click on Logins and Select New
Login.
-
Enter
the Login name as "eNewsletterPro"
or choose another desired
username.
-
Choose
SQL Server authentication.
-
Enter a unique password then
confirm the password.
-
Uncheck the box "Enforce
password expiration".
-
Under
Default Database, select the appropriate eNewsletterPro database.
-
On the left side, click "User
Mapping".
-
Check off the Map checkbox next
to the eNewsletterPro database.
At the bottom, click db_owner in
addition to public.
-
Click OK. If you get an
error relating to the password
you must enter a longer
password.
