Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [azure-sql]

Azure SQL Database is a general-purpose relational database-as-a-service (DBaaS) based on the latest stable version of Microsoft SQL Server Database Engine.

0
votes
0answers
3 views

Resource Governor on Azure SQL Database (Not managed instance)

my problem is the following: when an user run a very long and CPU-intensive query, the entire database is lock (when another user try to run another query, that's one iw blocked by the first one). So ...
0
votes
4answers
219 views

How to create database user and assign role to it with terraform

I have created sql server and database with terraform now I have to create database user and assign role to it. How I can do it. Please suggest me.
0
votes
1answer
13 views

Autoscaling Azure SQL Database

I'm looking to set up some type of method to autoscale (vertically) my Azure SQL Databases based on CPU or some other performance metric. My environment is in govcloud and I don't see any options for ...
2
votes
1answer
22 views

How can I configure an Azure VM to act as a proxy for connecting to SQL Database over a Service Endpoint?

Currently, Azure does not allow for SQL Databases to be accessed through a Service Endpoint over a VPN Gateway. My idea to circumvent this limitation is to set up an Azure VM to function as a proxy so ...
1
vote
1answer
28 views

Change Azure Master Database Collation ARM Template

I'm deploying an environment in Azure using ARM Templates. I'm using Azure SQL Server and 4 databases. I went to restore a bacpac file and got an error complaining about different collation settings ...
0
votes
0answers
8 views

Can azure data factories use timestamp as a watermark?

I am trying to create a lookup in an azure data factory pipeline that extracts a max(timestamp) from a sql server on premise database and pass it to a copy data activity, but I can't seem to get it to ...
0
votes
1answer
42 views

Azure Webapp and SQL Secure networking

I believe i'm trying to do simple pretty basic with Azure, yet so far I didn't found anything "safe". Basically, I just want to have a Azure WebApp and a Azure SQL Server (no VMs) communicating to ...
0
votes
2answers
85 views

Convenient way to dump Azure SQL DB database

Using geo-replication is a nice way of duplicating data but it requires the two servers to be registered on the same Azure account. That could be a potential security risk if an employee decides to ...
0
votes
1answer
224 views

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' on Azure SQL with Active Directory Admin via SSMS

When I attempt to connect to an Azure SQL Server via SQL Server Management Studio using the "Active Directory - Universal with MFA support" method with an account that is configured as the Active ...
3
votes
4answers
3k views

How do I connect to an Azure SQL Server via an Azure VPN Gateway?

I have setup an Azure SQL Server with an Elastic Pool into which I have created a Test database. I have also setup an Azure Virtual Network and a Point-to-Site VPN. The Virtual Network has 2 subnets -...
0
votes
0answers
113 views

Identity value incorrect after migration to Azure SQL

I used the new MS Data Migration Assistant (v4.1 link) to migrate a database from a SQL 2008 R2 server to an Azure SQL database. The process worked well and the data migration worked great! However, ...
1
vote
0answers
144 views

Cannot Connect to Azure Database from Azure Web Application

We have a SQL Server database in Azure. In the same resource group is an App Service. The App service connects to the database, using the connection string: Server=tcp:[server].database.windows.net,...
1
vote
2answers
1k views

Add Azure SQL Server in to Azure VNET

Is it possible to add Azure SQL Server into a Azure Virtual Network? Currently I see only a separate firewall for SQL server. But I want to maintain a single Network Security Group and have all my ...
0
votes
1answer
33 views

Pricing for SQL database/ per SQL server

I'd like to know if I'm doing something wrong about Price Tiers and SQL Databases. Is the price paid per server or per database? I thought it was per database, só if I get a client, they can pay X ...
1
vote
1answer
244 views

How to minimize latency between Azure App Service and Azure SQL Database?

We have an Azure App Service application using Java Tomcat 8.5 running in West US Region. The Service Plan for this Service is Standard, Big. This App Service application is connected to a SQL ...
0
votes
0answers
80 views

Azure Mysql Database service generate failed connections when too many connections needed

We have a problem when applying stress test (sending too many users in the same time) to our application, our application trying to create new connections to serve users, but azure Mysql DB service is ...
1
vote
0answers
11 views

Azure SQL Built-in Backup not completing

I've configured the retention policy in 'Manage Backups' for my Azure SQL Server but nothing is appearing under 'Available Backups'. Does there need to be an associated storage account? If so, how do ...
0
votes
2answers
57 views

AZURE SQL DATA IMPORT

I want to move data from one azure sql database to new azure sql database. From the first one I have exported .bacpac file. I import it to the second one and I get Import operation for <...
0
votes
0answers
12 views

What are the [dbname]_[some_GUID] databases in Azure SQL?

I see a lot of databases named like [dbname]_[some_GUID] in the list of deleted databases as well as in billing details. These databases are created daily and deleted in few minutes. I have multiple ...
-1
votes
1answer
31 views

How to create (or use the existing) database on an SQL 2017 deployed via Azure VM?

Please note the question is about the SQL 2017 that comes inside an Azure VM, not the Azure Databases. Basically, I deployed an Azure VM with SQL 2017 Enterprise installed on it already, by MS. Now, ...
0
votes
0answers
82 views

Azure Cloud VM take too much time to create Tenant on WSO2 Identity Server 5.1

I have configured WSO2 Identity Server 5.1 with MSSQL Server in the same region in the Azure cloud.(Canada East) I have successfully configured this setup in the cloud, but whenever I am creating ...
0
votes
0answers
34 views

SSIS C# task runs fine in local server and azure server - doesn't work in other azure servers

Moving the question here, as advised on Stack Overflow I'm facing a very strange issue when deploying a SSIS package that is part of a project: I have 3 Azure SQL Servers running 2014. I've written ...
1
vote
2answers
2k views

Azure automation runbooks access to Azure SQL Database

I am trying to run some SQL statements against my Azure SQL database using an Azure Automation runbook. In all examples I can find on https://docs.microsoft.com they are using an Automation credential ...
0
votes
1answer
904 views

Azure ARM Template - multiple Microsoft.Compute/virtualMachines/extensions for VM

I am trying to do auto restore of a bacpac to azure mssql VM when it is provisioned but failing to do so using custom scripts extensions. I generated the Azure MSSSQL VM ARM template using automation ...
2
votes
1answer
2k views

How to give an Azure SQL DB instance a private IP?

I have an Azure SQL DB. Is it possible to give it a local IP address for connections from within my network and vnet so that it forces the traffic over expressroute?
3
votes
1answer
3k views

Exporting on-prem SQL Server to Azure SQL using BAPAC fails because of users with Windows Auth

I have an on-prem SQL Server 2014 database - the schema itself is fine and fully Azure SQL compatible. However, it has a USER object that is bound to a Server LOGIN which is configured to use Windows ...
1
vote
0answers
296 views

Azure VPN cannot connect to sql server

We have setup our VPN connection in Azure to our on-premises database, the connect is working with no problems. I have written a MVC app that tries to connect to our on-premise database in SQL Server ...
1
vote
2answers
482 views

What's the difference between Azure Database Backup, Copy, and Export

I tried searching online for an answer to the above question but all I see are the long documentations on performing these operations. What I'm looking for is a brief description of how do the ...
1
vote
1answer
906 views

Unable to connect as a database contained user to an Azure SQL database

On my free trial Azure account, I'm working on Exercise 5 of this official Azure lab tutorial to work on the section Connect as a database contained user to an Azure SQL database. I've successfully ...
2
votes
1answer
285 views

Using domain Active Directory account for connecting to SQL Server running on an Azure VM

According to the first note on this Microsoft Azure article: Connecting to SQL Server running on an Azure VM is not supported using an Azure Active Directory account. Use a domain Active Directory ...
1
vote
1answer
69 views

Unable to login to Azure SQL Server using Azure Active Directory account

Using Azure Trial Free account to practice on their lab tutorials. I'm not clear on steps 5 and 6 of Exercise 4 on this Azure Official Lab. When I login using ADSQLAdmin it says (as expected) account ...
1
vote
1answer
63 views

Azure elastic database pool storage limit briefly drops to zero

Yesterday and today I my azure web app experienced bunch of timeouts and 502's for few minutes. While investigating I found out that database storage limit and storage used dropped to zero at that ...
3
votes
1answer
319 views

Cannot Enter-AzureRMVM - Azure CloudShell (PowerShell)

I have a SQL Server on IaaS Windows 2016 using the default marketplace image (SQL Server 2016 SP1 Enterprise on Windows Server 2016) today, after fighting the East US region problem yesterday which ...
0
votes
0answers
94 views

Error moving Sql Server Azure between subscriptions

I’m trying to move a SQL Azure Server that has 2 databases from one subscription to another. The databases’ sizes are 10G and 1G. I’m using the azure portal to do it and I’m getting the following ...
2
votes
2answers
2k views

How to set up a nightly job that runs a script on Azure SQL?

I'm looking for a way to set up a nightly job that will run a small SQL Script, to rebuild fragmented indexes on an Azure SQL database. Resources I have found online seem to be either dated, or ...
0
votes
2answers
334 views

Azure IaaS Client VM to PaaS SQL Connection Issues

I'm trying to get a website hosted on Azure IaaS VM to communicate with a database hosted on Azure PaaS SQL. However, I am receiving an exception when trying to connect: A network-related or ...
0
votes
2answers
126 views

SQL Azure used by Azure VMs, Encrypted connection or virtual network?

We Have an Azure SQL Server which is going to accept connections from four VMs also in Azure. My question is, Which one is better? Using encrypted connections protected by certificates and Azure SQL ...
2
votes
1answer
250 views

Azure - can't remove SQL server

Something went wrong, I can't connect to Azure SQL server. I try to remove it but get an error: Failed to delete the server: ***. ErrorCode: 504 ErrorMessage: {"error":{"code":"GatewayTimeout",...
0
votes
1answer
364 views

How to connect multiple sql instances installed in same azure vm via internet

I have an Azure VM which has installed two sql server instances (Sql server 2012 and sql server 2016). First I installed the SQL server 2012 and could able to connect via internet using Sql Server ...
4
votes
1answer
102 views

Migrate SQL 2008 database to Azure

I am migrating a SQL server 2008 R2 production database to Azure SQL database service in the cloud. Is it possible to mirror/replicate the Azure database from the 2008 R2 database? So I can just ...
1
vote
2answers
631 views

How to accomodate very large SQL database in Azure?

I have a database with a growth of more than 100 Gb per week, and 5 TB yearly. Since this is financial data, we can't purge it. If we keep this data for at least 10 years, size will become 50 TB. ...
1
vote
1answer
1k views

What cross-subscription communication & connectivity is possible in Azure?

I work in a large distributed org, and several divisions have purchased their own subscription to Azure. I am a co-administrator to all the accounts, and can see all the resources in all ...
1
vote
1answer
218 views

Move SQL 2008 database to Azure

I need to move a SQL 2008 R2 on-premis database to an Azure SQL cloud database. The database is to big to script out with data and Azure SQL cloud cannot restore a standard .bak file. Trying to use ...
4
votes
1answer
680 views

Cant delete Azure Database

Created this a database from a backup. I want to delete this database because I selected the incorrect backup. When trying to delete the database I get the following error: Failed to delete the ...