Customizing SQL 7.0 Database for ASP Web Site_PHP Tutorial

Will demonstrate how to create and configure a sample database using Enterprise Manager of SQL 7.0 server. We also demonstrate how to add 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 named this example database WEBPAGES.
In this dialog box, you can see one of the most powerful features of SQL 7.0: you do not need to specify the size of the database, only the initial size. SQL 7.0 will automatically expand the database file when the database needs to be expanded. The expansion is based on the specified growth size or a certain percentage of the current database size. We accept the system's default values, click OK, and the new database is created successfully.
Next, this new database must be configured so that users can access it. Access rights must be given to at least two users: 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 a new user, you first need to create a server login. The operation is: click the Login icon under the selected server node, select New Login from the Action menu, as shown, the login properties of the SQL server - New login dialog box will pop up.
Select New Login from the Action menu. In this dialog box, first select the Windows NT Authentication radio button, select your domain from the drop-down list box, and then, in the name edit box Enter username. Because you can't browse to find a user, you need to know the username of the web server. By default, the user name used by the Microsoft IIS server is IUSR_ServerName (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 entering the user name, specify the user's default database and language. We are going 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 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 authority to manage Web pages. 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 Web server login, the Webmaster user must also be assigned the db_owner (database owner) server role.

http://www.bkjia.com/PHPjc/631159.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/631159.htmlTechArticle will demonstrate how to use Enterprise Manager of SQL 7.0 server to create and configure a sample database. We'll also show you how to add a user with the appropriate permissions so that you can access data from the web server...