All Questions
Tagged with azure sql-server
124
questions
1
vote
0
answers
39
views
Unable to restore an MSSql Database from an Azure Storage backup
We have a simple sql script to restore an MSSql DB from an Azure storage blob. We backup our PROD DB to Azure Storage.
Trying to run this script (which we swear used to work a while ago).. now errors:
...
- 6,548
0
votes
0
answers
582
views
Ingesting SQL Server Logs into Azure Sentinel
I have been following the guide below and have set up the auditing from the two SQL server boxes. I don't understand how to do the Sentinel part as our Sentinel doesn't have the options shown in the ...
- 595
1
vote
1
answer
411
views
How to tell what is accessing my Azure SQL Server?
I have a legacy Azure SQL Server that I want to decommission but we have a LOT of legacy systems that no one knows about.
I want to confirm what accesses this server and/or its databases.
It doesn't ...
- 155
0
votes
1
answer
52
views
Connecting to SQL server on a virtual machine is more computationally expensive than a dedicated SQL instance?
I have two options:
I can connect my web app to a SQL server hosted on a virtual machine, or I can connect it to a dedicated SQL server instance. All will be hosted in the same zones in Azure / AWS e....
- 123
-1
votes
1
answer
423
views
Azure Security Alert - Login from an unusual data center
Azure Security Center generates an alert for a SQL Database that someone authenticated from an "unusual datacenter". Provided IP is Microsoft owned. Hostname is nothing recognizable.
- 149
0
votes
1
answer
308
views
How to setup an Azure Windows VM for multiple users to RDP to their unique MS Access file?
I have 2 Azure VMs. One will act as an application server. The application is an Access file. This Access file connects to a separate Microsoft SQL Server database on a different Azure VM which will ...
0
votes
0
answers
53
views
SQL Server - Optimizing Performance of a Large Dataset
I'm using SQL Server running on an Azure VM with 8 SSDs. The SSDs are grouped together in Storage Spaces as 1 disk - in order to increase the capacity and also to combine the IOPS/Throughput. But the &...
- 111
1
vote
1
answer
410
views
Azure Serverless SQL will not pause due to Azure service queries keeping it online
There is a database we use for archiving old data which I want to be 'serverless' so that it only fires up when we make a query.
I changed the size from standard to serverless without issues. I have ...
- 415
0
votes
2
answers
2k
views
Azure Sql Database stuck "Restoring"
I aborted the restore of an Azure Sql database over 2 weeks ago. While no longer visible in the Azure Portal it continues to appear in the list of database In Sql Server Management Studio. "(...
- 1
0
votes
1
answer
168
views
Can't connect to SQL Server setup on Azure VM
I've got Azure VM setup with SQL Server Express installed.
I can connect with SSMS that's on the VM just fine, but can't connects from my computer.
I've tried this guide, but still can't connect: ...
- 123
0
votes
1
answer
939
views
Allow external inbound connection to Azure Windows Server 2019 Virtual Machine on specific port
I want to allow TCP connection to 1433 port (SQL Server) on the Azure Windows Virtual Machine. TCP is enabled for SQL Server and I can telnet to this port from the local machine as well (telnet ...
- 111
0
votes
2
answers
978
views
Azure SQL Server - Firewalls and virtual networks - Azure ignoring my virtual network connection
I'm trying to connect to an Azure SQL server instance via a virtual network. I have it set up and it's connecting fine. Then I added the vnet to the Firewalls and virtual networks. Endpoint status is '...
- 41
3
votes
1
answer
3k
views
How to resolve: "SQL Server database port 1433 is exposed to the Internet. We ...suggest only exposing them to your front-end tier inside your vn"
I can't find anything online that explains how to resolve this error, does anyone have any idea?
SQL Server database port 1433 is exposed to the Internet. We do not recommend exposing database ports ...
- 41
1
vote
0
answers
479
views
Azure Web App suddenly stops communicating with external SQL Server
I have an issue with my Azure Web App that it once in a while stops communicating with our external SQL Server. Everything was working fine until a few hours ago. It's a simple setup with an asp.net ...
- 111
1
vote
1
answer
137
views
Can't identify where SQL backups are being initiated from
A little background on my skill: I am new to running SQL on Azure and, although I've done a bit of development on SQL Server, I would still consider myself a novice with SQL Server as well.
We ...
- 979
0
votes
4
answers
1k
views
Azure SQL Server login failure
Brand new Azure account.
Created a vnet (10.25.0.0/16) and an SQL DB/Server (no AD, just an admin login: sadmin/***)
Using SSMS, I can connect the SQL server through its public endpoint (prompted ...
- 419
0
votes
1
answer
44
views
Migrating MS SQL Server database to Azure
I have an issue migrating my database from my PC to Azure. I cannot install the Data Migration Manager. I have already allowed port 1433 in my firewall and I am getting further in the installation ...
0
votes
1
answer
1k
views
Proxy Azure SQL database with firewall enabled on IP range
I have following setup
Azure SQL Database with firewall enabled, so that it will allow connections only from 104.x.x.x IP addresses
Azure hosted Linux VM, within the same location as Azure DB, with ...
- 103
0
votes
0
answers
150
views
Windows 2019 server on Azure, SQL memory crash
I'm running a website on Azure, I've got my own VM with Windows 2019, MSSQL server and IIS installed.
This is the second time the following happend now in about 3 months. The website has been up for ...
- 1
2
votes
1
answer
3k
views
How do I disconnect a VM from a Log Analytics workspace that has already been deleted?
I created a Log Analytics Workspace (LAW) and connected the SQL Server to it in order to test a theory. I then deleted the Log Analytics Workspace (LAW) but did not "Disconnect" it from the LAW.
I ...
- 21
1
vote
1
answer
335
views
Windows Server Authentication on SQL Server for Site-to-Site VPN
We are trying to expand our company network infrastructure to the cloud with Azure.
One of the things that we will be starting with is to replicate our Domain Controller to Azure as shown in the ...
- 143
2
votes
2
answers
48
views
Decreasing OS drive free space on Azure VM running SQL Server 2016
Recently I noticed that drive C: is decreasing in free space on my Azure VM running Windows Sql Server 2016 (doing daily azure VM backups in Recovery Services Vault). Drive C: keeps adding 100-250mb ...
- 21
-2
votes
1
answer
96
views
What is “localcomputer” or domain and how to get it?
I am trying to install a program (Microsoft SQL Data Sync Agent), and in one step it is asking me the following:
Enter the account you want to run Windows Service under. E.g. domain\user. ...
- 101
37
votes
7
answers
12k
views
Can Microsoft employees see my data in Azure?
I have sensitive data stored in both Azure DB and Azure SQL VM.
An authorised DBA can log on and query the database, but in theory could a random Microsoft employee do the same without asking ...
- 1,583
0
votes
1
answer
180
views
How to connect Azure Database migration service with on premise based source SQL server
I am trying to connect Azure Database migration service with SQL server which is in On premise VPN. Not able to establish the connection.
0
votes
1
answer
894
views
Azure sql server cannot create database
I am trying to create a database in Azure SQL server. However, when I try to create it, it prompts "Gen4 family is not available in this region" and cannot create the database. What is the problem?
1
vote
1
answer
96
views
Sudden Disk Issues During Database Restore
Environment:
Azure Windows 2016 VM with SQL Server 2016 Standard installed
Machine Size: DS12_v2 (previously DS3_v2, which is the same except for less RAM)
4-cores
28 GB RAM
14 GB RAM for SqlServer
...
- 11
-1
votes
1
answer
4k
views
ADO NET Destination has failed to acquire the connection with the following error message: "Login failed for user
Created a SSIS package, it is running fine when I run it on premise but when i try to execute it from sql server agent it gives me error for login failed for user, I am using SQL authentication to ...
- 1
1
vote
0
answers
56
views
Allow Guest User in Azure Access to SQL Server (DEV, Read/Write)
I'm a bit new to Azure AD. I have some software development offshored and have already created a guest account in Azure for the developer. I've create an account in SQL Server (Manually via the ...
- 111
0
votes
2
answers
606
views
How do I back up my Azure SQL Server Database to my local machine?
I have an Azure SQL Server database that I need to get rid of off of Azure, but that I don't want to lose the data within it.
I cannot figure out how to backup/export the data.
How do I do so?
- 101
0
votes
2
answers
2k
views
Connecting from Java Azure function to managed Azure SQL instance
I have a Java Azure function that connects to an SQL Server database, and it used to work fine with "Azure SQL Service". The DB is now being migrated to Azure SQL "Managed Instance", so I changed the ...
- 101
4
votes
2
answers
915
views
What are the drawbacks of putting my staging and production dbs into one Azure Elastic Pool?
I have a STAGING and PROD environment, web apps, SQL databases, etc in Azure. Currently, the scale of the SQL db for PROD is much higher than STAGING - no surprises there.
I suppose there is some ...
- 505
0
votes
1
answer
87
views
Azure Scheduler that updates both Azure Database and On Premise SQL Server Database
I have a REST Service that needs to update data into Azure SQL Server database and also into On Premise SQL Server database. Both databases should have same data in certain database tables.
...
2
votes
1
answer
1k
views
"Someone logged on to your SQL server from an unusual location."
I'm using SQL Server on Azure and just received this security threat message.
Unauthorized access that exploits an opening in the firewall; legitimate access from a new location.
Google searches ...
- 123
2
votes
0
answers
652
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,...
- 31
3
votes
2
answers
9k
views
Connect SQL Server Profiler 2017 to Azure SQL Server
The title is pretty explicit, how can I connect my profiler to Azure?
So, I begin by opening the software, then a connect to my server:
However, I am getting this:
So I began to search what it ...
- 133
4
votes
3
answers
361
views
Azure high availability solution with synchronization of website and SQL server data
We have a web solution that we sell and it comes with 1 dedicated Azure VM containing everything it requires to run the application:
ASP.NET web application
Production environment
QA environment
SQL ...
- 107
0
votes
1
answer
96
views
Azure SQL to On-Premise SQL Server Data Transfer
I need to securely transfer data from a SQL Server in Microsoft Azure to a SQL Server on-premises. I have been researching different methods but I have not found the right way.
Following is the list ...
- 1
2
votes
0
answers
1k
views
Importing BACPAC via SSMS to Azure SQL Server fails with AzureAD user
Recently, trying to import a BACPAC to an Azure SQL Server using SSMS (SQL Server Management Studio) has been failing with the following error:
Failed to connect to server ___.database.windows.net.
...
- 141
0
votes
1
answer
306
views
CustomScriptExtension on Azure with SQL Server Image not downloading the file because of already used Sequence Number from a Golden Image
I'm trying to deploy a Windows SQL Server on Azure and running a script on it using the CustomScriptExtension resource.
I've been using CustomScriptExtension successfully when deploying Windows ...
- 101
1
vote
0
answers
215
views
SQL Server outbound IP address inconsistency in Azure VM
I have this setup:
Azure VM (B-series)
Static public IP
SQL Server running outside of Azure, with IP whitelisting on the firewall set tot he public static IP of the Azure VM
Two ASP.NET apps that ...
- 469
-1
votes
1
answer
44
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, ...
- 139
-1
votes
1
answer
446
views
SQL Cluster Between Cloud Providers - Multi Cloud SQL
I want to explore the options available to me in setting up MS SQL replication between Azure and Amazon AWS.
Has anyone got any ideas? I think Always On Availability Groups is off the table.
-- ...
- 149
0
votes
1
answer
3k
views
Exception of type "System.OutOfMemoryException" deploying database to Azure
I installed SQL Server Express 2017 on a VM in Azure and restored my 2 Gig Kentico 9 database to it.
Then I tried to deploy to an Azure database.
Things seemed to be going well for 30 minutes, then I ...
- 185
0
votes
1
answer
2k
views
Unclosed quotation mark after the character string restoring from Azure blob
I am using the following command ( with altered blobname and datbase name) to try to restore into an Azure SQL Server database from a backup of a 2014 database
I am using Australia South East with my ...
- 185
1
vote
1
answer
501
views
Terrible performances using a remote Azure SQL Database
We're currently evaluating Azure's SQL Database service (vs local installation) because we would like to have the "Always Encrypted" feature integrated in our (java-based) application.
Problem is, ...
- 113
0
votes
1
answer
167
views
How to migrate from "Pay-As-You-Go" SQL Server VM to standard Windows VM with perpetual SQL Server license
We currently operate two (2) VM’s on our Azure cloud configured into an Availability Group (AG) for SQL Server DB workloads. We use “Pay-As-You-Go” licensing model for SQL Server operation in these VM’...
0
votes
1
answer
5k
views
Migrating FileStream database to Azure
We are migrating our existing client databases to Azure soon. Our current database uses FileStream and has some data stored in columns of type varbinary(max). From what I have read, FileStream is not ...
- 101
1
vote
1
answer
1k
views
SQL on Azure VM Disk Striping and Location of Data/Log Files
Per the Performance best practices for SQL Server in Azure Virtual Machines documentation:
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-performance
...
- 143
0
votes
1
answer
35
views
Converting VM Subscription to not include sql
I have a VM running on Azure running an A2 subscription with SQL Standard.
Is there a way to remove SQL standard from the subscription?
Do I have to spin up a new instance and migrate everything ...
