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