Customizing the SQL 7.0 database for ASP Web sites (1)

Will demonstrate how to create and configure a sample database using the SQL 7.0 server's Enterprise Manager. We will also demonstrate how to increase the number of users with the appropriate permissions so that data can be accessed from the Web server.
The first thing to do is to create a new SQL database. 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 increase the database, click the database icon, and then choose New Database from the Action menu item (New database).
From the Action menu item, select New database in the Database Properties dialog box, enter the name of the data base, and we'll name the sample database webpages.
The dialog box can see one of the most powerful of SQL 7.0: Do not specify the size of the database, just specify the initial size. SQL 7.0 expands the database file automatically when the database needs to be expanded, based on a specified growth size or a percentage of the current database size. We accept the default value of the system, click OK, and the new database is created successfully.
Next, you must configure the new database so that users can access it. At a minimum, give two users access: 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 users of the database to reflect different needs.
To add new users, you first need to create a server login. To do this: under the selected server node, click the login icon, select New Login from the Action menu (new login), and then eject the SQL Server login property-The New logon dialog box.
Choose New Login from the Action menu (new Login) in this dialog box, first select the Windows NT Authentication radio button, select your domain from the Drop-down list box, and then enter the username in the name edit box. Because you cannot browse for a user, you know the user name of the Web server. By default, the username used by the Microsoft IIS Server is IUSR_servername (in Iuser_ followed by the name of the server). The server username in our example is Iusr_earth, and the SQL Server name is Earth.
After you enter the user name, specify the user's default database and language. We want to click the Database Access tab to grant that user access to the webpages database, and check the options shown in Figure 5. Finally, click OK to complete the creation of the user login.
Specify the user's default database and language
Repeat the procedure above to create a webmaster account. Because there is no default webmaster user, before you create this login, determine which user has permission to manage the Web page. The difference between creating a webmaster login and creating a Web server login is to assign the db_owner (database owner) server role to the webmaster user, in addition to the public (common) database role that is assigned to the Web server login.