Shulou(Shulou.com)05/31 Report--

How to establish new users in sqlserver, many novices are not very clear about this, in order to help you solve this problem, the following small series will explain in detail for everyone, there are people who need this to learn, I hope you can gain something.

method/step

If you do not open sqlserver authentication, first windows identity into the management system open

Properties-Right click-Security-Open

Then you need to restart (right click summary)

Then in Security-Login-Add New Login

Enter username, password; password preferably Enforce password policy

And then you want to open user permissions in the database to find security-right-new-user

Enter the user name just now, and then check the user architecture and role; check db-owner (full permissions) here

Finally link with this account

If you click on another database, you will be prompted that you do not have permission

Did reading the above help you? If you still want to have further understanding of related knowledge or read more related articles, please pay attention to the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.