execute a query in SQL Azure to the on-premises SQL Server
Jan 11, 2013 · linked servers from azure to on-premise servers is wishful thinking I think, given that in Azure itself you cant even do cross-database queries. besides, to enable that linked server, you will …
SQL Sync portal doesn't see any tables or schemas
Jan 10, 2013 · The same login doesn't seem to see anything (either directly on the Azure SQL dB or thru the agent for local SQL) What's interesting is that if I create new tables from scratch in testdata, then …
Cannot set password in datasource connection string
Oct 25, 2019 · The model is deployed successfully with one exception. The password that is coded into the datasource's connection string is not saved. If I try to process the database AAS cannot connect …
SQL Azure + trigger + send email - social.msdn.microsoft.com
Sep 20, 2013 · I'm using DataSynch to replicate the Azure data to a local db where I have access to SQL Server and I can add the triggers locally and the triggers and email works fine but....
The operation is not permitted for namespace
Oct 21, 2019 · When I select 'resource providers', I cant find the option 'Microsoft.Storage' to enable. I am using de portal and I tried with (Pacific Asia) Australia Central and Brazil zones. I have a student …
Alternates for Federated tables in mySQL
Feb 24, 2020 · Currently we are in the process of migrating MySQL db from in premise to Azure mysql PaaS . The current in premise implementation having few Federated tables in use. According to the …
azure database and SQLServer studio users/credentials do not work
Mar 31, 2015 · Please if you could help I would appreciate it. I loaded the Adventure DB to Azure but when I tried to connect to it through SQL Server studio I do not have access to it. But if I created a db …
Restore Azure DB from BACPAC file in Blob Storage
Jul 13, 2015 · To import a BACPAC file from Azure Storage into an existing empty DB you can use Azure Powershell. You will need to run the Start-AzureSQLDatabaseImport cmdlet.
error : MySQL #1030 - Got error 1 from storage engine
Aug 17, 2018 · However, my Azure server does not run the script,and it gives the same error the error is #1030 - Got error 1 from storage engine. I have used MySQL Workbench and PhpMyAdmin, but …
Setting Active Directory Admin for Azure SQL Managed Instance Fails
Mar 26, 2020 · I am not able to add an active directory administrator to a newly created SQL Managed Instance in the Azure portal or with the Cloud Shell.