Questions tagged [azure-managed-database]
36 questions
0
votes
1 answer
Is there a REST API alternative to Set-AzSqlInstanceDatabaseBackupShortTermRetentionPolicy?
I am currently working on automating the setting of retention policies of databases within an Azure managed instance. At the moment I am using the Azure Set-AzSqlInstanceDatabaseBackupShortTermRetentionPolicy PowerShell Cmdlet. It would be…
Wes Toleman
- 311
- 5
- 12
0
votes
0 answers
Website stopped working after we changed the connection string from sspi to azure active directory integrated
Our Website uses Windows Authentication for both UI and SQL, we are now migrating to Azure. Our On-Prem Active Directory is already federated to Azure Active Directory. we created a new VM and hosted our site and it worked.
Now we migrated our SQL…
sainadh Nani
- 29
- 2
0
votes
1 answer
Give DBAdmin access on multiple DB's
I am trying to provide DBAdmin privilege for a user on multiple databases.
I know how to do from on premises SQL database, I can directly map the user to required databases.
Can anyone let me know how to do it in Azure managed instance. Since the…
Kowser
- 101
- 3
0
votes
3 answers
How to connect Azure Managed Instance in Azure Linked service
I am trying to make the "Managed Instance" as destination in Azure Data Factory(copy data). But, I couldn't see any option to select "Managed Instance" in Linked service.
Here is the list of Azure supported data stores,
Source :…
Pரதீப்
- 91,748
- 19
- 131
- 172
-1
votes
2 answers
Unable to drop schema 'jobs_internal' because it is being referenced by object 'id_list' in Azure Managed SQL
I'm trying to export database from Azure and facing various issues.
One or more unsupported elements were found in the schema used as part of a data package. Error SQL71501: Error validating element [jobs_internal].[visible_targets_formatted]: View:…
Sergei Prokopov
- 39
- 3
-2
votes
1 answer
DB mail configuration on Azure managed instance
How to configure dbmail on azure managed instance?
What should be smtp server name? email account?
Will on_prem smtp server work?
And how SMTP authentication should configure on azure mi?
ReddyEsh
- 1
- 3