tailieunhanh - Microsoft SQL Server 2005 Express Edition for Dummies phần 3

Điền vào các giá trị cho tất cả các thiết lập có liên quan cho người sử dụng mới của bạn. Có năm các trang thông tin tài sản mà bạn có thể cung cấp: • General: Đây là nơi bạn nói với tên đăng nhập SQL Server 2005 Express mới của người sử dụng, chọn một phương pháp bảo mật, và yêu cầu một cơ sở dữ liệu mặc định và ngôn ngữ. | 68 Part II Administering a SQL Server 2005 Express System 6. Fill in the values for all the relevant settings for your new user. There are five properties pages of information that you can provide General Here s where you tell SQL Server 2005 Express the new login user s name choose a security method and request a default database and language. Server Roles Using this page you can associate this new database user with a set of predefined security profiles. User Mapping Here s where you associate a database user with one from the Windows operating system. Securables This is where you can set up highly specific security criteria. Status Here s where you can set high level permissions such as whether the user can connect to the database as well as whether the login is enabled or not. 7. Click OK to complete the operation. Your database login is now ready to go. If you re curious about security check out Chapter 11. Chapter 5 Maintaining a SQL Server 2005 Express System Jn This Chapter Taking advantage of user instances Customizing your database server s operation Monitoring and improving performance lthough SQL Server 2005 Express comes with an attractive price free and a truthful promise of low maintenance requirements you re still not completely off the hook with your babysitting responsibilities. In this chapter I show you how to get these chores done with the least amount of effort. To begin you find out how SQL Server 2005 Express allows you to easily run separate user instances thereby granting normal database users extra powers within their own workspace. With that out of the way I show you how to configure the database server followed by some helpful performance tips. Master of the Database Domain User instances are a handy feature offered by SQL Server 2005 Express that let regular users run their own separate instance of the database server. When you request a user instance the primary SQL Server 2005 Express service spawns a unique process containing the .