Azure upgrade email broken link. How to upgrade?
Hi Everyone, I received an email from azure-noreply@microsoft.com stating, "Upgrade by June 23, 2024 to save your data and keep building in Azure". The email has an "Upgrade now >" link which goes…
ODBC Connection DSN and Linked Table Manager Giving Different Results: The link table manager in access database only gives the master tables
I am setting up a DSN and a Linked Table Manager link all on the same Access database on the same computer with the same database Login and associated User (and of course the same database). The DSN gives me the tables I need, but the Linked Table…
SQL Access Strategy
I would like a strategy for the use of Azure SQL with our cloud environment. The DB is in azure SQL. I would like to come up with a solution for giving access to developers and extended/other teams for dev/support needs. WE have to add users and give…
During database migration in online mode using Azure data studio status is restoring only on sqlmi.
During database migration in online mode using Azure data studio status is restoring only on sqlmi. it's not changing since long time. Though Azure data studio shows restored and Data migration service shows ready for cutover. Data is around 24 GB only.
syncdata db has this error "Database re-provisioning failed with the exception "
I have an Azure sql db that I have a data sync with an on prem db. The sync was working and all was good. 1/31 we added a column to a table in the on prem db. I added the same column to my Azure sql db and refreshed the schema for the data sync. The new…
what is best practice using Azure SQL Database ?
hi? My customer decided to use Azure SQL Database. In Azure, you can create and use multiple databases in one Azure SQL Database Server. Is there any problem if I use it like this? Or do I need to create a SQL Server for each database? The people who…
How can I use Microsoft Entra-only authentication for my nextjs application using mssql and Azure SQL Database
I'm building a fullstack application using NextJs and Azure SQL database. The database is Microsoft Entra-only authentication. I'm using NPM packages mssql for querying the database and @azure/msal-browser and @azure/msal-react for single sign on. The…
Can't able to connect the VM installed postgresql from ADF
Hi Team, We are unable to access the PostgreSQL from the ADF linked server. it's a azure PostgreSQL flexible server, and we have enabled the "Allow public services" setting within Azure for this server. However, we are still unable to create a…
Could not open a connection to SQL Server After publishing an ASP.NET Web project to azure using VS2022
There is a bug in the publishing code because I used the UI to publish my on premise app from visual studio 2022 and it didn't set the App service or the Sql Server correctly because The app service can't access the database and I get the follwing…
How to establish connections of azure data factory connectivity with AWS dynamo DB
How to establish connections of azure data factory connectivity with AWS dynamo DB - provide a Micrsoft Documentation so that we can follow that to establish the connectivity in between the Azure as well as the AWS platform.
Connection Error Between Azure SQL DB with the codebase.
I have created a SQL DB in the azure portal, setup it's server and crate a database table using the azure Data studio. Now I setup a Microsoft Entra ID and add my IP for the smooth connection. Now when I want to make a connection with my DB, I am…
ssis package upgrade fail
I am trying to upgrade my SSIS packages from sql 2016 to 2019. The steps I did is opened the project in Visual Studio 2022, and then set the targetversion to 2019. And then Upgrade all the packages. It completed without any errors. But when I open one of…
Why does impersonation (Execute as) work in a User database and not in the master database in Azure SQL DB?
Execute As User = 'User1' doesn't work in the Azure SQL DB master database. User1 account created in the master database and in a user database. Execute As User works in the user database and in the master database, receives the error: Msg 15517, Level…
Retirement of Azure SQL Database APIs 2014-04-01
The Azure SQL Database API version 2014-04-01 is retiring, I would like to understand the following things: How can we check the resources effected using the resource graph explorer? How to make the changes using code? Any prerequisite or…
how to fix Error SQL71501: Error validating element [dbo].[int ]: Column: [@tWebCheckins].[TenantID] has an unresolved reference to Built-in Type [dbo].[int ]. Error SQL71501: Error validating element [dbo].[int ]: Column: [@tAttendance].[TenantID] has an
Error SQL71501: Error validating element [dbo].[int ]: Column: [@tWebCheckins].[TenantID] has an unresolved reference to Built-in Type [dbo].[int ]. Error SQL71501: Error validating element [dbo].[int ]: Column: [@tAttendance].[TenantID] has an…
Reclaiming free space from TempDB in azure sql managed instance
the TempDB on my azure sql managed has grown to 350 GB but 99% of that space shows as unused. i tried to shrink the database and individual files but the server is not freeing up the space. the space is still reserved for tempdb. Microsoft docs is…
UpdateRows in logic app fails with error BadRequest
In my logic app I'm trying to update a row in a sql database using the SQL internal connector, executing an UpdateRows activity. I pass in the column I want to update, as well as the primary key. I don't see what could be wrong with my code, but I get a…
Can't connect to Azure Sql with SSMS or Azure Data Studio
I used to be able to get to me Azur Sql database via SSMS (Sql Server Management Studio) or Azure Data Studio but now I can't. Firewall rule error The server you specified x does not exist in any subscription in y Either you have signed in with an…
Azure SQL MI Database Manual Backup & Retention Policy
why do we get such an error when we try to do manual backup for sql server managed instance? In this backup we redirect the backup to url (storage account), but it fails due to encryption error. when we also use command line it fails with the same…
Is is possible to replicate Azure SQL Backups to a external cloud
I have configured backups for my Azure SQL database and I'm interested in replicating the LTR backups to an external cloud like AWS or GCP. For example, if I can configure Azure to place the LTR backups into a storage account, then I could build the…