Stack Overflow
Stack Overflow

Questions tagged [azure-sql-server]

548 questions
0
votes
2 answers

Error creating sql server when applying terraform plan

I have the following resources to create a sql server and database using terraform # Configure the Microsoft Azure Provider provider "azurerm" { version = "0.2.2" } # ... resource "azurerm_sql_server" "demo" { name =…
Victor Martinez
  • 980
  • 1
  • 8
  • 14
0
votes
2 answers

Migrate SQL Server database from Azure to AWS

I need to migrate a SQL Server database from Azure to AWS. I've tried to create a backup on Azure but it seems that option is not available, not even through a script.
Rich Montero
  • 11
  • 1
0
votes
1 answer

Error in Azure when a Web App tries to insert into a SQL Server database for the first time after tables created

This is a question that involves Azure with SQL Server and a Web App. Everything works fine locally. The problem exists only in Azure. I have set up a SQL Server with a database, and published a web app. They are using the same region. Everything…
xoda
  • 73
  • 1
  • 7
0
votes
1 answer

How to deny port 1433 access to SQL Server VM while allowing SQL query from Integrated Web App

I have integrated Azure WebApp to SQL Server VM so that these can communicate via Vnet instead of public internet. I have denied all TCP port 80 for incomings for security reason. I see that http posts reach successfully from WebApp to VM. However…
Kenny_I
  • 2,001
  • 5
  • 40
  • 94
0
votes
0 answers

Azure ML Import Data connection has special character in password

Azure ML Import Data from Azure SQL DB connection has special character ] in password. In connection wizard it is successfully connected. But when run the experiment, it gives error with no error message. After long analysis this issue is…
sangram parmar
  • 8,462
  • 2
  • 23
  • 47
0
votes
0 answers

Azure DB prevent from Scaling up without permission

I've been on the cheapest Azure SQL DB plan (Basic + 5 DTUs) for about 10 months. Bills were low such as usage. I check the bill once in a while after checking my July one was really confused as it went up by 5 times. I went to the resource manager…
Dmitry
  • 1
  • 1
0
votes
2 answers

Creating a foreign key to compound primary key

I have two tables - Educators and Faculties: CREATE TABLE [dbo].[Educators] ( [UserId] [nvarchar](128) NOT NULL, [FacultyId] [smallint] NOT NULL, [InstitutionUserId] [nvarchar](128) NOT NULL, CONSTRAINT [PK_Educators] …
No1Lives4Ever
  • 6,430
  • 19
  • 77
  • 140
0
votes
0 answers

SQL Server: hierarchyid and nvarchar

I have a SQL Server database which includes a Users table with the following columns: UserId: nvarchar(128) email: nvarchar(256) ... I want to add a users hierarchy to my system. This means, one user will be the "administrator". Other will be the…
No1Lives4Ever
  • 6,430
  • 19
  • 77
  • 140
0
votes
0 answers

How to configure the SQL Server with SQL Assessment?

I added the SQL Assessment solution in my OMS workspace for collecting the SQL server health information. For that I followed this documentation, even I added the SQL Assessment solution in my OMS workspace still I am not getting any data from my…
Pradeep
  • 5,101
  • 14
  • 68
  • 140
0
votes
1 answer

How to set up SQL Server Auditing with blob storage in ARM template

I'm trying to update my SQL Server ARM template to use blob storage instead of table storage. What I have doesn't fail entries appear in the blob storage account but it doesn't update the Azure portal. Has anyone else experienced this? { …
David Williams
  • 401
  • 3
  • 15
0
votes
0 answers

Azure SQL Server SSL certificate verification fails

I am seeing some strange results with SSL certificate verification in relation to Azure SQL Server. I have an application that is making a secure connection to SQL server. When I run the application on my local PC, the certificate returned by the…
shattar
  • 66
  • 6
0
votes
1 answer

Azure SQL Database v12 AD authentication, some users not able to login

Hi I have configured Azure active directory authentication on Azure SQL Server. After that I have added contained DB users on a SQL Database by using the following queries Created user CREATE USER [John.Marsh@contoso.com] FROM EXTERNAL…
narendramacha
  • 550
  • 6
  • 24
0
votes
0 answers

Application does not connect to the database after deployment on Azure

When publishing MVC app on Azure, the connection string is picked automatically but I fail to understand how the deployed app connects to the database using this connection. There's server error: SqlException (0x80131904): A network-related or …
Mazolo
  • 307
  • 4
  • 19
0
votes
1 answer

Amount of Azure SQL Database space required

I want to save the addresses of some 100,000 people in Azure SQL Database. The schema for the address table will look like this. The size of each table field is 250 NVARCHAR. First Name Middle Name Last Name Email Phone 1 Phone 2 Phone 3 Fax…
wonderful world
  • 10,969
  • 20
  • 97
  • 194
0
votes
1 answer

Update a row of a table in a elastic pool Db using Elastic Query

I have a SQL Server in which I have created 'n' numbers of elastic pool DB with identical schema and tables. I want to update a column Column1 in a table table1 in a elastic pool database as ElasticDB1 using Elastic query. Is it possible? If yes,…
Skull
  • 1,204
  • 16
  • 28
1 2 3
…
36 37