Create New Login for banmanproSQL database
access. Within SQL Server Enterprise Manager, expand
the tree down to Security.
Right-mouse click
on Logins and Select New Login.
Enter the name as
"banmanproADMIN" or choose another name to be assigned to this
database.
Choose SQL Server authentication.
Enter Password = “admin1”
or another unique password. For security reasons you should create
a unique password.
Under Database, select the appropriate
banmanproSQL database.
Select the Database Access tab.
Click the Permit check box for the banmanproSQL
database. Under "Permit in database role" check public
and db_owner.
Click OK and confirm password.
