Does SQL Search work with Azure SQL databases?

mcr132mcr132 Posts: 2 New member
in General Forum
Trying to use SQL Search with SQL Azure database - no activity , no results...
· Share on Twitter

Comments

  • Random LengthsRandom Lengths Posts: 42 Bronze 2
    Mine gets results. Are you connected?
    · Share on Twitter
  • mcr132mcr132 Posts: 2 New member
    aha! - worked fine using SQL Authentication - Is Azure Active Directory (AAD) authentication not supported? if not, Any plans to do it??
    · Share on Twitter
  • ingridcarleyingridcarley UKPosts: 1 New member
    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.
    Activity Co-ordinaor Care Home Bexhill
    · Share on Twitter
  • BernardrichiiBernardrichii United KingdomPosts: 1 New member
    Don't know, new here.Can you tell me about Azure SQL logical server
    Project Operator Nursing Home Surrey
    · Share on Twitter
  • steve@powell.net[email protected] Posts: 6 Bronze 2
    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

    :: [email protected]

    We get the same error in Prompt:

    24 Apr 2020 08:42:00,126 [1] INFO  RedGate.Cache.Candidates.ServerCandidate - Created new ServerCandidate for server: ourdatabase.database.windows.net
    24 Apr 2020 08:42:00,398 [110] WARN  RedGate.Cache.Candidates.ServerCandidate - Failed to load server ourdatabase.database.windows.net
    System.Data.SqlClient.SqlException (0x80131904): Cannot open server "mydomain.com" requested by the login.  The login failed.


    The error logs for Search look like this

    24 Apr 2020 09:41:55.578 [112] ERROR RedGate.SQLSearch.Addin.Tab.DatabaseConnector - Could not load database list
    System.Data.SqlClient.SqlException (0x80131904): Cannot open server "mydomain.com" requested by the login.  The login failed.
       at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)
       at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
       at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
       at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
       at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
       at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
       at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
       at System.Data.SqlClient.SqlConnection.Open()
       at RedGate.SQLSearch.Addin.Tab.DatabaseConnector.OnlineDatabasesForInstance(String connectionString)
    ClientConnectionId:4fc06d6f-0ea4-4721-957a-552059d38530
    Error Number:40532,State:1,Class:20
    24 Apr 2020 09:41:55.846 [1] ERROR RedGate.SQLSearch.Addin.LoggingErrorHandler - Failed to get the object hierarchy
    · Share on Twitter
  • uforbestuforbest Posts: 1 New member
    Don't know, new here.Can you tell me about Azure SQL logical server
    i need for my coupon codes site 
    · Share on Twitter
  • JohnsontvcJohnsontvc Posts: 0 New member
    It is very informative and helpful to me. I admire SQL database information provided here. 

    · Share on Twitter
  • Anita2020Anita2020 Posts: 5 New member
    Hello,

    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
    · Share on Twitter
  • Anita2020Anita2020 Posts: 5 New member
    Hello,

    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
    · Share on Twitter
  • JustifyJustify Posts: 17 New member
    How effective this result? 
    · Share on Twitter
  • taran87taran87 Posts: 1 New member

    There is a connection string on the Azure Management portal's Configure page for the website. This connection string is used to connect to the website's database. It initially contains the User Id and Password used to create the database. Entering a different User ID and Password in the Visual Studio website project (in Web. config or in the Publish Web dialog) has no effect on the connection string in Azure. This caused a problem in my specific situation, but would also be an issue for anyone who does not use the same-like server-level user for accessing the database from the website.

    The workaround I found for this issue is to directly modify the Connection String in Azure on the website's Configure page, instead of relying on the effectiveness of a change in the Visual Studio project. This resolved the problem and now the named schema is working correctly.

    · Share on Twitter
Sign In or Register to comment.