How to install a new unique database user of the System for effective management bb workspace instead of user "sa"?
Follow the procedure to install a new sql-user of the Microsoft SQL Server:
- Run the Enterprise Manager (is a part of the SQL Server 2000 package) or Management Studio (for SQL Server 2005/2008) and click on the main menu "Action -> New Login" or, as an alternative, you can open the tree: Console Root -> Microsoft SQL Server -> SQL Server Group -> 'SERVERNAME' -> Security -> Logins -> right click New Login.
- A form will appear to add a new user. Specify the name of the new user (ex.: bbadmin, eDocsAdmin, systema, business, etc.), grant a password for the new user. Remember the password or write it down and keep in a save place.
- On the tab Database Access grant access to all operational and archival databases, flag as db_owner. Do not forget to set the same access to archives database.
- After the access have been given, click OK and re-enter the password, granted for the new user.
- Now specify this new user in the System Configuration Utility (bbconfig.exe) for the access to operational and archival databases.
<< back
| Was this answer helpful for You? |
|
|
