AzureSQL Target should not need access to the master database
The AzureSQL Target should not need access to the master database
Current version of PII4BA gives this error message:
Ref the error message
The server principal "sqluser" is not able to access the database
"master" under the current security context.
“Generally, non-administrator accounts do not need access to the master database”
note: The error message shows up when clicking the "Connect" button in the Web UI to populate the database dropdown.
Workaround is to set target database in AF.