Administering a SQL Server 2005 Express System

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.