How to create a User and SQL server authentication

SQL Server Authentication is a default mechanism to connect to MS SQL Server, but there are times that you need to use SQL Server Authentication to connect to the server, like when you have to connect to an MS SQL Server Database on a different network or when you have an SSPI problem. In order to use SQL Server Authentication, you need to create a SQL Server Authentication Login ID first. we will create a new SQL Server account. Run Microsoft SQL Server Management Studio. with local windows Authentication    Expand the Security folder,…

Read More