Questions tagged [azure-sql-managed-instance]

258 questions
2
votes
0 answers

How to create a new database user with limited privileges for Azure SQL

How to using SQL statements to do below config for case 1 and 2? Case 1: There are multiple databases DB1, DB2, DB3, ... in the Azure SQL managed instance How to create a new database user User1 that can only access DB1 and hide the other databases…
J.W
  • 671
  • 7
  • 23
2
votes
1 answer

Azure SQL Server Managed Instance

Currently ran into a bug? on a SQL Managed Instance in Azure. On SSMS whenever we create a Login to associate with a user we dont see that login on the security tab on SSMS but do see the user on the database, is this by default in SQL Managed…
2
votes
1 answer

TSQL CREATE ASSEMBLY FROM varbinary breaks the class_name parameter

I have migrated my on-premise SQL Server 2008 R2 databases to Azure SQL Server Managed Instance (SQL Server 2017). One database is an archive (read-only) database, one is the OLTP database, and the third is an utility database, where I keep generic…
2
votes
2 answers

Azure Managed Instance and Failover / DR Options

Azure SQL Managed Instance became generally available on 1-October, 2018. However, I've seen virtually nothing written about what options we have with regards to fail-over and disaster recovery. Specifically I would like to know what happens in the…
Randy Minder
  • 47,200
  • 49
  • 204
  • 358
1
vote
1 answer

Is there a command line tool to connect Azure SQL MI on Solaris11

According to Microsoft document, there is a sqlcmd utility which can be used on Windows server/system that can execute sql statement and bcp operation in command-line. Reference:…
Carson
  • 21
  • 2
1
vote
1 answer

Stop/Start Azure SQL Server Managed Instance

So Azure has stop/start feature in preview Following docs it's available only for: Managed instances in the General Purpose service tier and Managed instances with the November 2022 feature wave enabled. I have an azurerm_mssql_managed_instance with…
1
vote
1 answer

Importing .bak file into Azure SQL Database

I have received a .bak file that contains a database backup, and I need to import it into an Azure SQL Database. I have tried using the "Restore" feature in Azure portal, but it seems that Azure SQL Database does not support direct restore from a…
1
vote
2 answers

az account not prompting for login but still granting access

I'm building a powershell script which interacts with SQL MI There are a number of methods to do this. For various reasons I choose the .Net framework described here: https://www.sqlshack.com/connecting-powershell-to-sql-server/ To authenticate I…
1
vote
0 answers

Unable to create Databases in Azure SQL Managed SQL

When running the create DB from the managed instance I get this message. { "status": "Failed", "error": { "code": "LinkedInvalidPropertyId", "message": "Property id '' at path 'properties.recoverableDatabaseId' is invalid.…
1
vote
2 answers

How to Setup Alert on Azure SQL MI instance for % storage space used?

We need to setup Alert if 80% of space used by Azure SQL MI instance then it should be alerted. In existing Alert metrics not provide option to use value in percentage(%). So anyone have any idea how we can setup alert on % space used by azure mi?
1
vote
0 answers

SQL Server Managed Instance database properties window getting “Subquery returned more than 1 value” error message

Error Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. (.Net SqlClient Data Provider)" window prompt when opening database properties Tried to…
Rap
  • 11
  • 1
1
vote
1 answer

Can't connect to SQL Managed Instance from Azure Function App (Login timeout expired)

I'm trying to connect to a SQL managed instance from an Azure Function App written in Python. The managed instance is under a Network Security Group and has multiple Inbound-rules that controls access to it. The function app is hosted in the same…
1
vote
2 answers

SQL Server job error on email notification

I have configured a database email, operators, and such on my SQL managed instance, to receive an email when a job fails. In the email, we get something like this "The yyy_job failed on step 3". But my question is... Is there a way to add the error…
1
vote
1 answer

Azure SQL DB - Scale Up - vCore Hyperscale or Azure Managed Instance?

We are currently using Azure SQL DB for our data warehouse project. Though it is an OLAP application, it has partial OLTP functionality as well. Our DB's current configuration is Basic, DTU based. Now the requirement is that the DB size may increase…
1
vote
0 answers

SQL Database Managed Instance file name change

I have SQL db on Azure, this is SQL Database Managed Instance. There are some differencees between SQL Server, one of them is that I cannot ALTER DATABASE to change file…
ThisOne
  • 13
  • 3
1 2
3
17 18