azure-docs icon indicating copy to clipboard operation
azure-docs copied to clipboard

Update tutorial-connect-msi-sql-database.md

Open daiplusplus opened this issue 6 months ago • 8 comments

  1. Replaced incorrect documentation re: sqlcmd in Azure Cloud Shell (which simply doesn't exist in either Bash or PowerShell environments in the Azure Portal).

  2. Replaced outdated suggestion to type one's password as a command-line argument (yikes!) with links to current instructions.

  3. Replaced suggestion to use ddl_admin with advice grounded in the principle-of-least-privilege.

  4. I also verified that the section I modified is correct by running it in my production Azure environment.

It's possible I was a bit too verbose here, so consider this a first-draft.

daiplusplus avatar May 25 '25 18:05 daiplusplus

@daiplusplus : Thanks for your contribution! The author(s) and reviewer(s) have been notified to review your proposed change.

prmerger-automator[bot] avatar May 25 '25 18:05 prmerger-automator[bot]

Learn Build status updates of commit 0b529ee:

:warning: Validation status: warnings

File Status Preview URL Details
articles/app-service/tutorial-connect-msi-sql-database.md :warning:Warning Details

articles/app-service/tutorial-connect-msi-sql-database.md

  • Line 239, Column 133: [Warning: file-not-found - See documentation] Invalid file link: '../azure-sql/database/authentication-microsoft-entra-connect-to-azure-sql'.
  • Line 240, Column 56: [Warning: file-not-found - See documentation] Invalid file link: '../sql/tools/sqlcmd/sqlcmd-authentication'.
  • Line 245, Column 141: [Warning: file-not-found - See documentation] Invalid file link: '../windows-server/administration/windows-commands/command-line-syntax-key'.
  • Line 248, Column 304: [Warning: file-not-found - See documentation] Invalid file link: '../azure/azure-sql/database/authentication-microsoft-entra-create-users-with-nonunique-names'.
  • Line 253, Column 17: [Warning: file-not-found - See documentation] Invalid file link: '../azure/azure-sql/database/authentication-azure-ad-logins'.
  • Line 239, Column 133: [Suggestion: preserve-view-not-set - See documentation] You've pinned this link to a specific version of content with the view parameter. It's recommended not to pin a version unless that version is A) not the default view and B) the context is about that version specifically. To proceed with pinning a version add the &preserve-view=true to the URL. Otherwise, remove the view parameter. URL: ../azure-sql/database/authentication-microsoft-entra-connect-to-azure-sql?view=azuresql#connect-with-ssms-or-ssdt
  • Line 248, Column 304: [Suggestion: preserve-view-not-set - See documentation] You've pinned this link to a specific version of content with the view parameter. It's recommended not to pin a version unless that version is A) not the default view and B) the context is about that version specifically. To proceed with pinning a version add the &preserve-view=true to the URL. Otherwise, remove the view parameter. URL: ../azure/azure-sql/database/authentication-microsoft-entra-create-users-with-nonunique-names?view=azuresql#t-sql-create-loginuser-syntax-for-nonunique-display-names
  • Line 253, Column 17: [Suggestion: preserve-view-not-set - See documentation] You've pinned this link to a specific version of content with the view parameter. It's recommended not to pin a version unless that version is A) not the default view and B) the context is about that version specifically. To proceed with pinning a version add the &preserve-view=true to the URL. Otherwise, remove the view parameter. URL: ../azure/azure-sql/database/authentication-azure-ad-logins?view=azuresql

For more details, please refer to the build report.

Note: Your PR may contain errors or warnings or suggestions unrelated to the files you changed. This happens when external dependencies like GitHub alias, Microsoft alias, cross repo links are updated. Please use these instructions to resolve them.

For any questions, please:

Learn Build status updates of commit a0f420f:

:warning: Validation status: warnings

File Status Preview URL Details
articles/app-service/tutorial-connect-msi-sql-database.md :warning:Warning Details

articles/app-service/tutorial-connect-msi-sql-database.md

  • Line 240, Column 56: [Warning: file-not-found - See documentation] Invalid file link: '../sql/tools/sqlcmd/sqlcmd-authentication'.

For more details, please refer to the build report.

Note: Your PR may contain errors or warnings or suggestions unrelated to the files you changed. This happens when external dependencies like GitHub alias, Microsoft alias, cross repo links are updated. Please use these instructions to resolve them.

For any questions, please:

Learn Build status updates of commit 2cf393d:

:white_check_mark: Validation status: passed

File Status Preview URL Details
articles/app-service/tutorial-connect-msi-sql-database.md :white_check_mark:Succeeded

For more details, please refer to the build report.

For any questions, please:

@cephalin - Can you review the proposed changes?

IMPORTANT: When the changes are ready for publication, adding a #sign-off comment is the best way to signal that the PR is ready for the review team to merge.

#label:"aq-pr-triaged" @MicrosoftDocs/public-repo-pr-review-team

v-regandowner avatar May 26 '25 14:05 v-regandowner

Learn Build status updates of commit c737235:

:white_check_mark: Validation status: passed

File Status Preview URL Details
articles/app-service/tutorial-connect-msi-sql-database.md :white_check_mark:Succeeded

For more details, please refer to the build report.

For any questions, please:

Learn Build status updates of commit 7f55b59:

:white_check_mark: Validation status: passed

File Status Preview URL Details
articles/app-service/tutorial-connect-msi-sql-database.md :white_check_mark:Succeeded

For more details, please refer to the build report.

For any questions, please:

@cephalin Could you review this proposed update to your article and enter #sign-off in a comment if it's ready to merge?

Thanks!

v-dirichards avatar Jun 11 '25 21:06 v-dirichards

@daiplusplus The article has been substantially updated or deleted, and this change no longer applies. If you'd still like to update the article, please open a new PR. Or if you believe this PR was closed by mistake, email the PublicPRs alias.

#please-close @MicrosoftDocs/public-repo-pr-review-team

v-dirichards avatar Jul 01 '25 21:07 v-dirichards