I’m trying to connect with database SQL server. But the authentication that I want to use is Azure Active Directory - Universal with MFA is it possible to do it? Because with what I usually worked with is only windows authentication and SQL server authentication.
Welcome to the community
Please check this
Yeah I even tried in myself in advance but I don’t have any place to put the password in
Another thing that I tried was to put the connection string myself , but still I get an exception:
A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The target principal name is incorrect). I have checked multiple time and the name and password are assigned correctly.
“Data Source=server_name;Initial Catalog=db_name;Persist Security Info=True;User ID=”+UserCode+“;Password=”+passcode+“;Encrypt=True;Authentication=ActiveDirectoryPassword”
I just found the solution, I played with the options and here it is the connection string:
“Data Source=server_name;Initial Catalog=Database_Name;TrustServerCertificate=True;Encrypt=False;Authentication=ActiveDirectoryPassword;User ID=Username;Password=password”
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.