How to Enable Sql server Authentication in Sql server 2017 || Create a new User in Sql server 2017
Support me on Patreon : https://www.patreon.com/salmanmasood1991
SQL Server authentication is recommended for connecting Dundas BI to its application and warehouse databases for security reasons. This article explains how to enable SQL Server authentication, and how to use it with a Dundas BI instance.
To enable SQL Server Authentication for your instance:
Open SQL Server Management Studio.
Connect to the SQL Server instance you would like to use for Dundas BI.
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 in Dundas BI
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….
For more video please like ,share and subscribe to my channel.
facebook :https://www.facebook.com/learnfromsalmanmasood/?ref=bookmarks
youtube :
https://www.youtube.com/channel/UCHAmv9m1l_BqbiPFvwWv1aw
instagram :
https://www.instagram.com/salmanmasood_ideas/
Comments are closed.