User,privilege and role
This is my first time using MS studio I am learning by myself
I tried going to the login properties and tweaking the properties nothing happen. My teacher didn’t teach how to use this btw. I follow the instructions, but I’m stuck here.
This is what I am aiming for result
New user login
>Solution :
What you want to do is change the server authentication mode to "SQL Server and Windows Authentication mode". Currently your server is only set to "Windows Authentication mode" which does not allow logins from SQL Server "Login" accounts.
To do so, you’ll need to login to your server as an account that has access (either an authenticated Windows account or the SA account) and then follow these instructions:
Change authentication mode with SSMS
In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.
On the Security page, under Server authentication, select the new server authentication mode, and then click OK.
In the SQL Server Management Studio dialog box, click OK to acknowledge the requirement to restart SQL Server.
In Object Explorer, right-click your server, and then click Restart. If SQL Server Agent is running, it must also be restarted.