Before you can query an Azure Search index, you must populate it with your data. If the data lives in an Azure SQL database, an Azure Search indexer for Azure SQL Database (or Azure SQL indexer for short) can automate the indexing process, which means less code to write and less infrastructure to care about.
This article covers the mechanics of using indexers, but also describes features only available with Azure SQL databases (for example, integrated change tracking).
In addition to Azure SQL databases, Azure Search provides indexers for Azure Cosmos DB, Azure Blob storage, and Azure table storage.
Yeah, we're using Azure Active Directory Auth with MFA for our SQL instances and AZ-DWH (now Synapse) instances. Neither SQLSearch or SQLPrompt seems to like this as neither provides anything useful.
Looks like it doesn't support this form of Auth
The error that gets logged is Cannot open server "mydomain.com" requested by the login. The login failed.
we are logging in using our AAD mail addresss as our login
Comments
This article covers the mechanics of using indexers, but also describes features only available with Azure SQL databases (for example, integrated change tracking).
In addition to Azure SQL databases, Azure Search provides indexers for Azure Cosmos DB, Azure Blob storage, and Azure table storage.
Looks like it doesn't support this form of Auth
The error that gets logged is Cannot open server "mydomain.com" requested by the login. The login failed.
we are logging in using our AAD mail addresss as our login
:: [email protected]
We get the same error in Prompt:
The error logs for Search look like this
Full - Text Search is now available in Azure SQL Database
Please go through below link and get the information.
https://azure.microsoft.com/en-in/blog/full-text-search-is-now-available-for-preview-in-azure-sql-database/
Happy to help you
Thanks & Regards,
Anita
Full - Text Search is now available in Azure SQL Database
Please go through below link and get the information.
https://azure.microsoft.com/en-in/blog/full-text-search-is-now-available-for-preview-in-azure-sql-database/
Happy to help you
Thanks & Regards,
Anita