Database Logins

Instead of using the "sa" database login, create a SQL user with administrator rights for every database, and limit the access of this user to one of the databases. You do this by:

1. Creating SQL server users.

2. Limiting database access.

3. Replacing the "sa" user within BizTalk Server.

Before you begin, you need to shut down BizTalk Server to prevent the interchange services being locked out, then perform the following steps:

1. Open the SQL Server Enterprise Manager (Start | Programs | SQL Server 2000 | Enterprise Manager).

2. Expand the Microsoft SQL Servers | SQL Server Group | SQL Server | Security folder.

3. Select Logins.

4. Right-click Logins, and select New Login... The SQL Server Login Properties dialog opens.

5. Enter a name; for example, for the Message Managing database, use "sa_InterchangeBTM" (Figure 8.22).

Figure 8.22 Creating a New Login Using the SQL Server Login Properties Window

Figure 8.22 Creating a New Login Using the SQL Server Login Properties Window

6. Under Authentication, select SQL Server Authentication and enter a Password.

7. Under Defaults, select the appropriate database for the user; for this example, choose InterchangeBTM and English for the Language.

8. Select Server Roles tab, and be sure that all the Server Role entries are unchecked.

9. Select the Database Access tab.

10. Place a check in the Permit box at the appropriate database; in our example, Interchange BTM. The login will appear in the User field.

11. In the Permit in database Role list, check db_owner.

12. Press OK. A dialog asks you to confirm the password. If it is correct, the user is created.

13. Repeat step 4 through 12 for the other two users: sa_Interchange_DTA and sa_Interchange_SQ.

Was this article helpful?

0 0

Post a comment