How can we improve PI Integrators?

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.

Microsoft's words:
“Generally, non-administrator accounts do not need access to the master database”
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-manage-logins

1 vote
Sign in Sign in with OSIsoft
Signed in as (Sign out)

We’ll send you updates on this idea

jrro shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in Sign in with OSIsoft
Signed in as (Sign out)
Submitting...
  • jrro commented  ·   ·  Flag as inappropriate

    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.

Feedback and Knowledge Base

Posted ideas will have one of the following statuses.
Full definition of these statuses can be found on the Home Page.
No status
NEEDS MORE DISCUSSION
RESEARCHING/EVALUATING
DECLINED
PLANNED
STARTED/IN DEVELOPMENT
IN BETA
COMPLETED