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

Support me on Patreon : / 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 : learnfromsal...
youtube :
/ @codewithsalman
instagram :
/ salmanmasood_ideas

[@codewithsalman]

Support me on Patreon : www.patreon.com/salmanmasood1991

[@sakshithakur5391]

Only this video can help it on RUclips.
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

[@muhtasimfuadshowmik1820]

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.

[@codewithsalman]

This video has been helpful to thousands of the people . I am glad that it is still helping out the developers in different regions

[@amriiheb]

the only guide that actually works ! thanks mate

[@FamousSquad-qt9pj]

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

[@chamodck]

very helpful, clearly straights to the point 🤝

[@NguyenTran-id4od]

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

[@ARV971]

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

[@codewithsalman]

Welcome man. Please subscribe 🥺

[@ARV971]

​@@codewithsalmanI did! You deserved it. Thanks again!

[@perskona]

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

[@codewithsalman]

Welcome. Subscribe plZ

[@burakabdulbakiulu3509]

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

[@michaelchinye7993]

Thanks a lot man. This was absolutely amazing

[@santosh_ksh7]

Major help, outstanding work.

[@surajprajapati6596]

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

[@vishaljhaveri7565]

Thank you so much! Worked like a charm.

[@mohamedmadi8401]

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

[@user-lz3kc6pm9y]

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

[@muhammadtalib7827]

it worked as expected
. thanx for the video

[@ajbotha7232]

This video is the only on that is simple as works first time thanks man

[@gorhakobyan1384]

Thank you. You solved my problem.

[@shankarghimire4492]

Thank you so much. You solved my problem.

[@samerco11]

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

[@codewithsalman]

Welcome

[@independentnavbcdeveloper3342]

helpful. straight to the point thanks!

[@codewithsalman]

Subscribe plz

[@silpisilpi1983]

Thanks bro this video very useful

[@hritikapal683]

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

[@codewithsalman]

Please subscribe:)

[@nehachaudhary1541]

Your video saved me since 2 days my logins not working. But I am good now. Thanks a lot

[@codewithsalman]

Glad to know that it helped you. Please subscribe and share

[@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 ❤

[@codewithsalman]

I am glad that it helped ! Plz subscribe

[@pktouk5077]

Awesome ... This made my day

[@anu8997]

Big thanks for you solving my major problem ☺

[@atpro9356]

thank you very much bro. i was searching it all day. from vietnam with luv

[@codewithsalman]

Welcome. Please subscribe

[@user-ys5nj5gh6r]

Thank you Salman! This video helped me a lot!!!!

[@abbas6023]

Thank you brother for solving my problem :)

[@brianpesci3896]

This is the most concrete tutorial, thx a lot

[@codewithsalman]

Welcome
Subscribe

[@shubhamchauhan9065]

It solved my problem. Thank you soo much for this tutorial.

[@codewithsalman]

Great
Thanks

[@abdullahakram1752]

Thanks alot brother for ur video. It helps alot

[@honeybcomb]

Thank you! Helped a lot!

[@twyyre5385]

Thanks for this video. Helped me know the problem with my login.

[@codewithsalman]

Welcome. Subscribe

[@thediego215]

thanks a lot for the tutorial i was resolved this problem correctly.

[@chanduvemula3987]

Thanku sir, nice video I hanged out on this problem for two days ..🙏🏻🙏🏻🙏🏻

[@codewithsalman]

glad to resolve your issue

[@ilkegunduz7820]

I tried 1 million things to fix this shit. Thanks man!!!

[@jonassolevaag]

This helped me much. Thank you :-)

[@tarunnukala52718]

it's working, Thanks a lot

[@simplifyingeducation7689]

Thank you sir for the tutorial 🙃

[@eightuponatime]

thank you, helped me a lot!

[@honeyverma2572]

thanks for this video it was very helpful for me.

[@venu2120]

Thanku mam,this video helps me alot🤝

[@kishoredas9171]

Great Sir
Very helpful video.
Pls make a video for job scheduler by Stored Procedure.
waiting

[@rohitwase9885]

thanks sir, it really help me a lot

[@brendonmakara380]

Thank you very much, much much appreciated.

[@yukifernando6693]

It is a very helpful video thankyou so much

[@rakeshadupa948]

Good Video its really Helpful..

[@programmerguide.]

Thanks alot you solved my problem

[@ajittripathi4546]

Thanks bro this video is very useful 👍👍

[@sreekarcreations534]

Thanks this video is really great

[@alhusarium7621]

thx a lot man, Greeat job !

[@reefat0904]

Thanks a lot! Helpful!

[@werthero]

Thanks a lot Salman! This was helpful!

[@codewithsalman]

Welcome Man

[@kayakhurana3271]

Very grateful to you..thank you

[@user-rl5li6oo7b]

thanks bro you've solved my problem to login with user authentication

[@codewithsalman]

Welcome . JazakAllah khair ! brother

[@gurusir2228]

That's perfect
Really work👍👍

[@codewithsalman]

Thnx, subscribe to our channel

[@ijaasmohamed1877]

Thank u! Works Fine

[@bangbangskeetskeet7631]

Holy fuck, i've just spent 2 hours trying to get this to work, didn't know i have to restart the server xD. Thanks man :D

[@codewithsalman]

I am Glad , it worked for u

[@vishaljhaveri7565]

Same happened with me. Lost 3 to 4 hours. Uninstalled reinstalled. Tried every hack. And here is this man explaining how to resolve this problem in 7 minutes. Frustration relieved.

[@mlabibkhairi7792]

it really help me, thanks

[@mouadssd2773]

thank you so much it worked

[@abhishekrai7307]

Thanks for solving my issue

[@slymanyonga7226]

absolute legend!

[@AhmedAshraf-tu6xl]

thank you , was very helpful

[@tauquirahmed3110]

Thanks you its really helpful..

[@Indian_news2468]

Amazing👍😍 Thanks a lot🙏

[@elviclozano]

I like it your explanation, thank you very much!

[@codewithsalman]

welcome ! Please subscribe

[@zeritessema9182]

Thank you so much it’s clear

[@codewithsalman]

Welcome. Please subscribe

[@tulasiaudi4370]

THANK YOU SO MUCH
IT WORKED SUCCESSFULLY

[@codewithsalman]

Welcome.please subscribe

[@souravkumarsamal6310]

You saved my life bro

[@mohammedramizsuthar5962]

thanks... it worked

[@AbdullahMubeenA.M]

Thank you so much sir it really really helps

[@codewithsalman]

Subscribe

[@bobowofol]

thank you. helped a lot

[@amaniyafaizal391]

Thank you. It worked for me 👍

[@codewithsalman]

Subscribe plz

[@rizwanreshi8673]

thank u sir it worked

[@shekhawigraphics1543]

thanks bro for your help

[@rashikashreshtha118]

Thanks
It worked

[@aamirsheraz321]

w salam, It was very helpful. Thanks

[@jazzcorptechnology4163]

Thanks bro u are so good. You solved my problem thanksssss

[@codewithsalman]

Happy to help

[@ShirtLizard]

Great information

[@RAVIKUMAR-ii4ux]

Thanks Bro, Very Useful

[@standuponyourtoes940]

CAN WE HAVE ANY WHAT'S APP PLATFORM FOR TO RESOLVE THE ISSUES RELATED TO SQL.
PLEASE PROVIDE THE LINK

[@hendrag1174]

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.

[@sahirunishshanka5338]

Thank you very much bro😀❤

[@yashmanchekar6348]

Thanks a lot for helping.

[@codewithsalman]

welcome . Subscribe plz

[@drwasabi1165]

I love u bro u r the best 😍

[@MBGROWTH22]

Awesome Man, thanks much!!!

[@codewithsalman]

Glad to help!

[@Hackers.9748]

Thank you very much 👍👍

[@harshithmurali9552]

Thank you Salman

[@AFZAALHUSSAIN]

Thanks its working!

[@codewithsalman]

You're welcome!

[@anime0506]

materimu sangat bermanfaat
terimakasi

[@kirantejatankala]

very helpful bro.

[@RajniKasbe]

Thanks a lot for solution

[@ytarek8752]

i really love you and your hole family
😍

[@santoshrokaya733]

Nice one!!

[@randomperson5772]

Thanks Man !!!!! :)

[@Filmy_recommends]

Works for me. Thanks

[@codewithsalman]

Welcome ! subscribe please

[@SandeepKaur-nt1wn]

Helpful !! Thanks

[@codewithsalman]

Welcome

[@deepakbind5543]

Thank Full video ❤️