How can we help you today? How can we help you today?
DWJenkins
Activity overview Badges (0) Posts (1) Comments (3)

Comments

Sort by recent activity
I got a pop-up this morning saying to install 8.2. Done and I also have lost prompt in the menus, intellisense. I'm using SSMS 17.2. / comments
  1. Community
  2. SQL Prompt
  3. The latest stable build of SQL Prompt is 8.2.3.2750 (18th October)
I got a pop-up this morning saying to install 8.2. Done and I also have lost prompt in the menus, intellisense. I'm using SSMS 17.2.
0 votes
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. / comments
  1. Community
  2. SQL Prompt
  3. Version 7.2.4.291 Azure Intellisense
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.
0 votes
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. / comments
  1. Community
  2. SQL Prompt
  3. Version 7.2.4.291 Azure Intellisense
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.S...
0 votes
Total activity
6
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2