Stack Overflow
Stack Overflow

Questions tagged [azure-sql-server]

548 questions
0
votes
1 answer

Active Directory Password Authentication for Azure SQL not working

I followed all the mentioned steps but couldn't get it to work with "Active Directory Password Authentication" for AD principal which is a contained user in my SampleDB. I get this error: Cannot connect to sql01.database.windows.net. ADDITIONAL…
Sam
  • 519
  • 1
  • 7
  • 32
0
votes
1 answer

Azure Data Lake External Data Source: Row size is too big

I tried reading from an external Azure Sql Db both with CREATE EXTERNAL TABLE xyz ....FROM LOCATION "dbo.xyz" and SELECT * FROM ExternalDataSource EXECUTE @"SELECT a,b,c FROM dbo.xyz WHERE DATALENGTH(a)<128000" approaches and getting a Row size too…
chi
  • 471
  • 3
  • 18
0
votes
1 answer

azure sql connectivity from local sql server

I am working with azure based application. In which, I need to get connected with azure sql server. I had already configured firewall setting on azure portal for my IP address. But still even when I tried to get connected to azure sql server, it…
techV
  • 935
  • 3
  • 23
  • 41
0
votes
1 answer

Cross database DML query in azure SQL

Is it possible to use DML commands like insert, update from cross database in azure SQL. In my requirement I'm running one SP on DB1 after execution i want to update status in a table that belongs to DB2. I'm using azure SQL. Is there any way to…
Vandana
  • 1
  • 2
0
votes
2 answers

Using sqlsrv_connect() in live environment

I've developed a web application in php that connects to an azure sql database using sqlsrv_connect(). This is a function from the SQLSRV driver by Microsoft. The application runs great locally (Using the azure database). I can select, insert and…
OutOfTheBox
  • 25
  • 7
0
votes
2 answers

Deployed database to Azure using SSMS 2016 is not accessible inside web portal

I used Microsoft SQL Server Management Studio 2016 to deploy my database to Azure and everything went OK with no problem and it managed to create the database on Azure however the imported database is not visible outside the Azure SQL Server(Web…
MHOOS
  • 5,146
  • 11
  • 39
  • 74
0
votes
1 answer

Copy Database Content (Schema) from one SqlAzure Database to another existing SqlAzure Database

I'm looking for good ideas how to copy the whole Schema from a SqlAzure Database to another SQL Azure Database. (Tables, Data) Goal: I'd like to use a "template" Database seperated with Schemas. Each schema represent another kind of "template" data.…
Cyril Iselin
  • 596
  • 4
  • 20
0
votes
1 answer

azure sql server Client disconnected during login

I'm getting the below error from the Azure SQL server, can someone help me resolve this? Error: Err 26078, Level 14, State 1, Server SQL Azure, Line 1, Message "Client disconnected during login"
Dilshad
  • 1
  • 1
-1
votes
1 answer

DBCC OpenTran in Sql Azure

In On Premise SQL Server we have used DBCC OpenTran but we have found that DBCC OpenTran is not available in Azure. What is the alternative for this?
Imran Qadir Baksh - Baloch
  • 32,612
  • 68
  • 179
  • 322
-1
votes
1 answer

Azure SQL Databases with bi-directional replication having read/write on all database instances

We are looking to try to implement the following in Azure SQL Server / databases. Our solution we provide has the following resources: 2 azure app services database backend in Azure SQL Server with SQL Databases within an elastic pool Goal: We…
Jason
  • 1
  • 1
-1
votes
2 answers

Unable to access Azure SQL Server from my Azure VM SSMS

I'm getting the message when I attempt to access the my SQL Server from SSMS Cannot connect to xxxxxxxxxx.database.windows.net. Cannot open server 'xxxxxxxx' requested by the login. Client is not allowed to access the server. (Microsoft SQL Server,…
Patterson
  • 1,927
  • 1
  • 19
  • 56
-1
votes
1 answer

Connect to Azure sql in Python Using Service Principal

I have a Service principal with a client id and client secret. It has permission to the Azure SQL DB. I want to use python to generate an access token and use it to authenticate to my sql server. Could someone guide me. I am new with python and…
Zoltaire
  • 21
  • 3
-1
votes
2 answers

Multi-Column check constraint

Consider a simple table.. create table dbo.car( car_guid UNIQUEIDENTIFIER default(newid()) , car_type varchar(20) not null , wind_protector varchar(20) not null ) insert into dbo.car(car_type,…
codingguy3000
  • 2,695
  • 15
  • 46
  • 74
-1
votes
1 answer

Azure SQL VM - Premium Storage Caching or P50 or more disks?

I have a 50 TB SQL server to host on Azure. I want to benefit from the premium storage caching (mentioned in the Azure best practices for SQL VM) but then I will have to use P30 at most and a lot of them. The other option is to use P70-80 disks but…
lepecheoriginel
  • 1
-1
votes
1 answer

Wildfly 11 : Adding multiple last resources is disallowed. Trying to add LastResourceRecord

I am facing the below issue in cloud environment while opening any messages in GUI. But the same works fine in my local environment. Database: Azure SQL server App Server: Wildfly 11 ERROR: "STATUS_MARKED_ROLLBACK - could not prepared…
Chammu
  • 103
  • 3
  • 13
1 2 3
…
36 37