Custom SQL7.0 database _ MySQL for ASPWeb site

This section describes how to use the EnterpriseManager of the SQL7.0 server to create and configure a sample database. We will also demonstrate how to add users with proper permissions to access data from Web servers. The first thing to do is to create a new SQL database. The operation is: start EnterpriseManager from the SQLServer7.0 menu. expanding SQL service shows how to create and configure a sample database using Enterprise Manager of SQL 7.0 server. We will also demonstrate how to add users with proper permissions to access data from Web servers.

The first thing to do is to create a new SQL database. The operation is to start Enterprise Manager from the SQL Server 7.0 menu, expand the SQL Server Group node, expand the specified SQL Server for which you want to add a database, click the database icon, and then click Action) select New Database from the menu ).

Select New Database from the Action menu. in the Database Properties dialog box, enter the name of the New Database. we will name this example Database WEBPAGES. In this dialog box, you can see that SQL 7.0 is the most powerful: You do not need to specify the database size, you only need to specify the initial size. SQL 7.0 will automatically expand the database files when the database needs to be expanded, based on the specified growth size or a certain percentage of the current database size. We accept the default value of the system and click OK to create the new database.

Next, you must configure the new database so that users can access it. At least two users must be granted access permissions: users who manage the Web server and Webmaster (Web site administrator ). Because different users have different access needs for the database, we reasonably configure the database users to reflect different needs.

To add new users, you must first create a server login. Operation: Under the selected server node, click the Login icon and select New Login from the Action menu, as shown in, the SQL Server logon attribute-new logon dialog box is displayed.

Select New Login from the Action menu. in this dialog box, select the Windows NT authentication radio button, select your domain from the drop-down list box, and then, enter the user name in the name editing box. Because you cannot browse and search for users, you need to know the user name of the Web server. By default, the user name used by the Microsoft IIS server is IUSR_ServerName (after IUSER _ is followed by the name of the server ). In our example, the server user name is IUSR_EARTH and the SQL Server name is EARTH.

After entering the user name, you must specify the user's default database and language. Click the Database Access tab to grant the user Access to the WEBPAGES Database and check the options shown in. Finally, click OK to create a user logon.

Specify the user's default database and language

Repeat the preceding process to create a Webmaster account. Because there is no default Webmaster user, you must determine which user has the right to manage the Web page before creating this logon. The difference between creating a Webmaster logon and creating a Web server logon is that in addition to the public (public) database role assigned to Web server logon, the Webmaster user must be assigned the db_owner (database owner) server role.