...
| Info |
|---|
You can access Azure SQL Managed Instance without entering credentials when you are logged in to a domain-joined machine. |
...
Run the following scripts:
| Code Block |
|---|
CREATE LOGIN [testuser@onmicrosoft.com] FROM EXTERNAL PROVIDER; CREATE USER [testuser@onmicrosoft.com] FOR LOGIN [testuser@onmicrosoft.com]; ALTER ROLE [db_datareader] ADD MEMBER [testuser@onmicrosoft.com]; ALTER ROLE [db_datawriter] ADD MEMBER [testuser@onmicrosoft.com]; ALTER ROLE [db_ddladmin] ADD MEMBER [testuser@onmicrosoft.com]; |
Ensure that the SQL Server JDBC Driver Authentication Library is in
C:\Windows\System32. The file name
ismssql-jdbc_auth-<version>-<arch>.dll, where version is a version number for the file.
| Tip |
|---|
Example: mssql-jdbc_auth-8.4.1.x64.dll. |
...