MS SQL Server login Issue | Window & SQL Server Authentication Issue | MSSQL Login Error 18456 Solve

SQL Server authentication have different type of authentication like : Window authentication, Sql server authentication, and azure authentication but in this video, i will explain whats main problem we are facing during connect with SQL server via UI and This article explains how to enable SQL Server authentication, and how to use it with a mssql management studio instance. To enable SQL Server Authentication for your instance: Open SQL Server Management Studio. Connect to the SQL Server instance. Connecting to a database server (e.g., localhost) Connecting to a database server (e.g., localhost) In the Object Explorer, right-click the server, and then click Properties. Server properties Server properties On the Security page, under Server authentication, select SQL Server and Windows Authentication mode, and then click OK. Turn on SQL Server authentication mode Turn on SQL Server authentication mode In the Object Explorer, right-click your server, and then click Restart. If the SQL Server Agent is running, it must also be restarted. Restart SQL Server Restart SQL Server 3. Using SQL Server Authentication 3.1. Before deploying an instance 3.1.1. Creating a SQL Server Authentication User During the deployment of an instance with new databases, the user must have the SysAdmin role, or else all of the following: DbCreator, DiskAdmin, ProcessAdmin, and SecurityAdmin. Create a user like this in SQL Management Studio by doing the following: Open SQL Server Management Studio. Connect to the SQL Server instance you would like to use for Dundas BI. Expand the Security folder, and right click on the logins folder, and then click New Login i explain mainly 4 points : 1) check your TCP/IP connection 2) check your local server (\MSSQLSERVER) on SQL server configuration manager. 3) check whether your user has permission to access or not. 4) check your server has authentication permission for both(window and SQL server authentication)