Graphics and text methods for creating users in SQL Server 2000 _mssql

Once the hacker gets the Webshell, the hacker knows your SQL Server administrator password, and if SQL Server is not securely set up then the hacker can easily claim and create a new system administrator account, then the hacker will be able to control your computer easily.

So be sure to make security settings, cloud-Habitat community website provides this service, help users security settings.

The following is a brief introduction to the topic if you create a new account.

Entering SQL Server's Enterprise Manager interface, you need two steps to create a new user

Step one: Security log on new login

Enter user name zz8love and select SQL Server Authentication and set the bottom of the password not to set (without prompting for an error or something)

After this is done, you need a second step.

Step two: Switch to Database "Zz8love" user




Login name Select the newly created username zz8love, be sure to check the db_owner (database owner) so that you can add modifications to the database table delete permissions

Click OK. If the problem occurs because duplicate user names already exist in the process of replacing the database, you can change the name.