Version 7.2.4.291 Azure Intellisense

DWJenkins

Hi there,

I can't seem to get my SQL Prompt Version 7.2.4.291 to work in Azure. I have refreshed the cache multiple times, it doesn't see the database and as a result nothing in it. I can see all objects in the explorer window and my query window is created against the database.

Weird as my colleague is having no issues and the setup is exactly the same!

Regards,

Dave.

Aaron L

Hi Dave,

If you navigate to the log (under SQL Prompt->Help->Show Log) after refreshing suggestions do you see any warnings or errors listed?

Thanks,
Aaron.

DWJenkins

Hi Aaron,

Thank you, I didn't know about the logs!

It's given me a pointer that it cant login. I've got my trusty DBA looking into it and checking all the relevant permissions.

Regards,

Dave.

DWJenkins

Actually, we're a bit stumped.

This is the test from the error log:
28 Oct 2016 10:12:04,698 [56] WARN RedGate.SqlPrompt.Cache.Candidates.ServerCandidate - Failed to load server XXXX
System.Data.SqlClient.SqlException (0x80131904): Cannot open server "XXX" 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)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
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 ..(ConnectionProperties )
at ..()
at ..()
ClientConnectionId:4effdc05-c687-44d3-9b59-ab27cb26f71f
Error Number:40532,State:1,Class:20

Is this because we are using "Active Directory Password Authentication"? and it's detecting everything after the @ symbol?

When we use SQL Server Authentication method on a different login, we get no error. However, we need to do "Active Directory Password Authentication".

Regards,

Dave.

Aaron L

Hi Dave,

Unfortunately SQL Prompt doesn't currently support Azure Active Directory Authentication, it's something we're planning to release support for soon however.

We've literally just merged in the first set of changes that should allow for SQL Prompt to offer suggestions using Azure AD, but we haven't finished testing against it yet (and it's just suggestions, no other features like smart rename or find invalid objects). If you don't mind being a guinea pig I could send you a private build to try out?

The related UserVoice request for it is here - if you vote against it you'll get a notification when release a public build with support in.

Thanks,
Aaron.

dillecd

I'm having the same issue as OP and am willing to be a guinea pig.

Aaron L

Hi dillecd,

The latest beta build supports both Azure Active Directory password and integrated authentication methods, you can download it from the forum post here.

We're still investigating adding support for the new Azure AD universal authentication however, so if you're using universal authentication please let me know and we might be able to send you a private build soon.

Thanks,
Aaron.

dillecd

Thanks! I'm using password auth so I've downloaded and installed the beta. Loving it so far.

knighteagle

Can you send me the private build for Azure AD Universal Authentication?
Thanks,
Jeremy

kbartschssb

Hi Aaron -

We are currently using Active Directory Universal Authentication and cannot get SQL Prompt to work properly. Is the "private build" (that supports this authentication method) you mentioned available?

Thanks -

Kyle

Harry Frankish

Hi Kyle and Jeremy

The private build for Azure Active Directory Universal Authentication is here: http://download.red-gate.com/EAP/SQLPro ... .0.235.exe

Please let us know if you have any problems with it.

Cheers
Harry