This will demonstrate how to create and configure a sample database using the Enterprise Manager of SQL 7.0 server. We will also demonstrate how to increase users with appropriate permissions so that data can be accessed from the web server.
The first thing to do is create a new SQL database. The operation is: start Enterprise Manager from the SQL Server 7.0 menu, expand the SQL Server Group node, expand the specified SQL server to add the database, click the database icon, and then select New Database from the Action menu item.
Select New Database from the Action menu item. In the Database Properties dialog box, enter the name of the new database. We name this sample database WEBPAGES. In this dialog box, you can see one of the most powerful things in SQL 7.0: you don't need to specify the size of the database, just specify the initial size. SQL 7.0 will automatically expand the database file when the database needs to be expanded. The basis for the expansion is based on the specified growth size or a certain percentage of the current database size. We accept the default value of the system, click OK, and the new database will be created successfully.
Next, this new database must be configured so that users can access it. At least two users must be given access rights: the user who manages this web server and the Webmaster (Web site administrator). Because different users have different access requirements for the database, we reasonably configure the database users to reflect different needs.
To add new users, you first need to create a server login. The operation is: Under the selected server node, click the Login icon, and select New Login from the Action menu. As shown, the SQL server's login properties - New Login dialog box pops up.
Select New Login from the Action menu In this dialog box, first select the Windows NT authentication radio button, select the domain you are in from the drop-down list box, and then enter the user name in the name edit box. . Because you cannot browse and find users, you must know the username of the web server. By default, the username used by Microsoft IIS server is IUSR_ServerName (after IUSER_, the name of the server you are in). The server username in our example is IUSR_EARTH and the SQL server name is EARTH.
After entering the user name, specify the user's default database and language. We want to click the Database access tab to grant this user access to the WEBPAGES database and check the options shown in Figure 5. Finally, click OK to complete the creation of the user's login.
Specify the user's default database and language
Repeat the above process to create a Webmaster account. Because there is no default Webmaster user, before creating this login, you must also determine which user has the right to manage the web page. The difference between creating a Webmaster login and creating a Web server login is that in addition to the public (public) database role assigned to the Webmaster user, the Webmaster user must also be assigned a db_owner (database owner) server role.