-
Create
New Login for the
ROIWiz
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 "ROIWiz"
-
Choose
SQL Server authentication.
-
Enter
a unique password.
-
Under
Database, select the appropriate
ROIWiz database.
-
Select
the Database Access tab.
-
Click
the Permit check box for the
ROIWiz database. Next
check the db_owner box under
"Permit in database
role".
-
Click
OK and confirm password.