-
Create
a new SQL user to access the Affiliate Wiz database.
From within SQL Server Enterprise Manager, expand the
tree down to Security.
-
Right-mouse
click on Logins and Select New Login.
-
Enter
the name as "AffiliateWiz" or any other
name as desired. For security reasons, you may
use something obscure.
-
Choose
SQL Server authentication.
-
Enter
Password = “admin1” or another
unique password. For security reasons
you should use something unique and obscure rather
than admin1.
-
Under
Database, select the appropriate AffiliateWiz
database.
-
Select
the Database Access tab.
-
Click
the Permit check box for the AffiliateWiz database.
-
Click
OK and confirm password.
