-
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
AffiliateWiz
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 "AffiliateWiz"
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 AffiliateWiz database.
-
On the left side, click "User
Mapping".
-
Check off the Map checkbox next to
the AffiliateWiz 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.
-
Please go back and right click
the new user you just created and select properties.
Now double check the settings from STEP 9. Sometimes
they do not "stick" and the db_owner must be re-selected.
