Hi
I am trying to connect to db using the following connection string and its asking for user id:
Connection string: “Server=; Authentication=ActiveDirectoryInteractive; Encrypt=True; Database=;Connection Timeout=300”
it was working before and when i was running the bot it was opening the browser for authentication but its not working now.
Any idea?
Thanks
if you provide the user id details was it not working?
try including userid in your connection string keyword User ID
cheers
Hey @afsaneh_keivani,
ActiveDirectoryInteractive may fail if browser login or MFA policies changed.
You can check using Active Directory Service Principal or Managed Identity for unattended bots
Update the connection string to these methods for stable authentication.
Check this:
1 Like