database connection issue with workflow designer
Hello, I wish someone can help me on this issue:
I need to connect to an Azure SQL database for a server-side workflow. In the Run SQL Query activity, I set Provider Name to be Microsoft SQL Server, and set Connection String to be Data Source=<company>.database.windows.net,1433;Initial Catalog=<Database Name>;Integrated Security=False;User ID=<Username>;Password=<password>, but when I ran the workflow in Sandbox, F12 shows me the error that "Login Failed for user <Username>".
However, I am able to establish a connection in Geocortex Essential Manager using the same connection string (same user and same password), and I am also able to connect as well using the same user credentials in Microsoft SQL Server Management Studio. What could I have done wrong in the Workflow Designer then?
Thanks,
Jie
0
Du måste logga in om du vill lämna en kommentar.
Kommentarer
0 kommentarer