Creating a new user on the database server |
To create a login for a user with database administrator rights, you need to perform the following steps. Start the Microsoft SQL Server Management Studio, connect to the server and open the folder «Security\Logins». Click the right mouse button and select the item «New Login».
Choose the «General» bookmark. In the field «Login Name», enter the username under which you want to connect to the database. Select the «SQL Server authentication» authorization option. In the Password field, set the password for this login. Uncheck the box «User must change password at next login». In the Database field, select the SYSTEM database. In the Language field, select the language - Russian or leave <Default>.
Click «OK» button - a user with the specified username and password will be created. After creation of logins the next task of administrator - to descend to the level of the database and create objects of database users. Open the folder - «Databases\<name of the database SYSTEM>\Security\Users». Click the right mouse button and choose «New User» item.
At creation of the user you will need to specify:
Creating an object of database users:
|