Forum Widgets
Latest Discussions
Connect to Azure SQL database with Point to Site Connection and Private Link
Hallo, I'd like to try to get the following done only somehow it doesn't seem to work I have configured a Logical Server within Azure with VNet and Private Link enabled Within this subscription I've a VM configured which you only get connected to when you have P2S connection enabled Client makes Point to Site VPN to Azure with AAD Authentication. When you connect with RDP to this VM with a private IP it is working fine. Connecting from this VM with SSMS to the Logical Server is working fine. Also the connection server.privatelink.databases.windows.net is working. When customers opens SSMS on his own laptop from home, he cannot make the connection to this Private Endpoint link. The only way to solve this issue is to allow allow Public Network Access And to add the home ip-adress of the customer, but this is something we don't want, because then I've to add for everyone his home IP Is there another way to achieve the situation below. Did I missed something in the documentation. My End Goal what I want to achieve is. Connect to my sql server through a P2S without adding home ip-address from customers. I've been reading the following link https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connectivity-architecture#connection-policy but then still my situation is not working. Who can help me out. Thank in advance
Extend the period of storing telemetry of all services of my subscription.
I have had now 4 support cases in which i see strange behavior of my services in the Azure cloud. For this i created support cases. We are a software company building solution on the Microsoft stack. In case of an incident we first look to our solution and will do an RCA. Sometimes the root cause is not related to our solution but to the Azure services. When seeing this we create a MS support case. It will take some time for MS to understand the case. A lot of time the case, is moved to different engineers. Because of this we run out of the 30 days for which telemetry of our services are available for the MS engineers. So we loose all interesting data to find the Root cause. Please extend the 30 days. This is really too short for analyzing situations. In our company we store telemetry information for 1 year. It is not acceptable for our customers that we do not know the root cause of the incident.Importing bacpac to Azure database fails
I am trying to import a database from a bacpac file to our azure sql server. I am following these steps: Creating a bacpac file from our production database running on an MS SQL Server 2022. Importing it into azure using sqlpackage But, it keeps failing with *** An unexpected failure occurred: Data plan execution failed with message One or more errors occurred. (One or more errors occurred. (One or more errors occurred. (Violation of PRIMARY KEY constraint 'PK_ForexQuote'. Cannot insert duplicate key in object 'dbo.ForexQuote'. The duplicate key value is (1). The statement has been terminated.))). The ForexQuote table DOES NOT have any duplicate primary keys. If I omit this table in my bacpac export I get a similar error on another table. I dont understand. What is going on here?Copy schema (with data) from one Azure SQL database to another Azure SQL database
Hallo, We need copy 3 schemas (incl tables, indexes, keys and data) to another Azure SQL database. We decided to switch from 2 database to one more powerful. There is a lot of data, smallest database is about 1TB data. I tried do it SSMS or BCP on client VM but it does not work due amount of data and transfer speed. I am looking something to do this in Azure portal. Both Azure databases are on one Azure host. Current situation: database source A_DB schemas c11, c12, c13; about 1TB data in 300 tables database target B_DB schemes c21, c22, c23, c24, c25; Hyperscale and 3TB data Desired result: target B_DB after copying the schema consists from schemas with the date c11, c12, c13, c21, c22, c23, c24, database A_DB can be deleted Please advise what azure service or tool can i use for it. It's a simple task in Oracle but it look more complicated in Azure SQL environment. So far I have found how to exp/imp or backup/restore an entire database, but nothing about how i can import schema with a lot of data in Azure environment. Thank youLogin Failed for user '<token-identified principal>' for Azure Active Directory Admin
Hello, I am having an issue where I am unable to connect to my Azure SQL database instance w/ my user that is the Active directory admin over the instance, along w/ the databases within that instance. I have been able to connect to this instance in the past with Management Studio. Now all of the sudden, I am unable to connect to any of my azure databases with this specific user. Non-admin accounts I can get into the instance and database, but my Active Directory Admin account is unable to log in. The error I am getting is: Login Failed for user '<token-identified principal>' There is not a lot (any) help on this issue and I'm hoping someone knows why and can help. I've tried changing the default db to one of the other dbs in this instance w/ no success. I am using Active Directory - Integrated Authentication and have also tried Active Directory - Password and Active Directory - Universal with MFA Support. Like I said, usually I will connect to these databases w/ no issue using Active Directory - Integrated. Not all the sudden it's throwing this error. I checked in my Azure environment and my user is still listed as the Active Directory Admin of this Instance/DB.
Encrypted backups using Asymmetric key
Hello, I am creating asymmetric keys at the master level and at the database level. Asymmetric keys are showing in the security option, but when I am trying to take encrypted backup using asymmetric keys no keys are visible. I have already created an encrypted backup by using certificates, now I am trying to create an encrypted backup using an asymmetric key.Is general purpose serverless tier of Azure SQL DB good choice for data warehouse database ?
Hi, Is General purpose serverless tier of Azure SQL DB good choice for data warehouse database ? The ETL is impleted by data factory mapping dataflows. We are getting frequently and randomly connection timeout ( read failed) error. It seems IO properties are very less.
