Setting up a new User name and Password for SQL Server Authentication
Windows Authentication is a default mechanism to connect to the SQL Server database. If you want to connect to a SQL Server database from a different network, you need to have SQL Server Authentication.
To use SQL Server Authentication, you first need to create a SQL Server Authentication Login ID.
Follow the steps given below...
1. As we don't have any User name and Password, connect with the Windows Authentication.
2. Before go ahead, you need to make some security changes to your SQL Server Management Studio.
Right-click on your SQL Server, and go to the Properties window.
3. You can see the Server Properties window, now go to the "Security" and select "SQL Server and Windows Authentication mode".
Press the OK button.
4. Now, Restart SSMS. You follow the steps given in point no.2 and press the Restart button.
5. After completing the above steps, expand the Security item from the Object Explorer and right-click Logins, and select New Login...
6. You can see the "Login- New" window on your screen. Enter the "Login name", I have entered the login name "KalpTalk", then select "SQL Server authentication" and type the Password and Confirm Password.
7. To complete the setup, go to "Server Roles" and select the last option "sysadmin" given in the image below.
8. You have completed all the steps, click on the "OK" button.
After completing all the steps, close SSMS and open it again, and log in with the User name and Password you created under SQL Server Authentication.
Written by: Kalpesh Agrawal (Actuarial Intern-IIB)