How to Enable Sql server Authentication in Sql server 2017 || Create a new User in Sql server 2017

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.

youtube :

instagram :

[muhtasimfuadshowmik]

I was actually stuck with an issue all day and kept trying everything out there to get my login to work and allow my project to gain access to my database. This video saved me! That last issue you fixed from the services was something unknown to me and not suggested on any other site that I'd visited so far. Thanks a bunch.

[sakshithakur]

Only this video can help it on YouTube.
Thanks a lot sir
I have been stuck in this issue since 3days and no one is able to help me from it team.
Truly helpful

[amriiheb]

the only guide that actually works ! thanks mate

[FamousSquad-qtpj]

One of the most helpful videos.Finally someone showed the right way to connect it❤

[ARV]

The only person that showed me the rigth way. Tried so many similar and different things. You sir got a like and sub. Thanks a lot

[chamodck]

very helpful, clearly straights to the point 🤝

[perskona]

Thanks alot ... This is exactly what i wanted . Because of this setting i was not abl to connect from my java aswell.

[NguyenTran-idod]

Thanks a lot, I was struggling with this one. Appreciate!

[mohamedmadi]

This was a very supportive, very appreciate your efforts bro, many thanks

[burakabdulbakiulu]

Thank you very much. I was struggling with this for hours...

[muhammadtalib]

it worked as expected
. thanx for the video

[michaelchinye]

Thanks a lot man. This was absolutely amazing

[surajprajapati]

Thank you salman sir ! You are solved my problem, thank you & you're great

[vishaljhaveri]

Thank you so much! Worked like a charm.

[hendrag]

Hi Salman, I followed your steps but failed during the restart process. Why? The reason I wanted to change from Window to SQL Server Authentication because I got an error during the Data Source stage in SSAS project. The error message stated about Authentication. As such, I hope by switching these authentication, the error in my SSAS project could be solved. Please advise thanks.

[Sureshyejju]

Finally I thought to do the uninstallation but i just gone through this video and tried, it helps me to don't do the uninstallation😅 thanks a lot ❤

[lzkcpmy]

This prob stucked with me for days, thank you very much

[anu]

Big thanks for you solving my major problem ☺

[samerco]

it tooks me 4 days trying to solve that error until i found your video
thaks alot ❤

[hritikapal]

Such a saviour video this was can't thankyou enough:)