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

Activity overview

Latest activity by TckFahimKanji

@gp83, Jon stopped responding in this thread so I started another one and was told that SQL Prompt doesn't support Azure Synapse (haha) https://forum.red-gate.com/discussion/comment/168005#Comment_168005  I'm going back to them again - you can track the other thread for more details if they come! / comments
  1. Community
  2. SQL Prompt
  3. Synapse Serverless SQL Support
@gp83,Jon stopped responding in this thread so I started another one and was told that SQL Prompt doesn't support Azure Synapse (haha)https://forum.red-gate.com/discussion/comment/168005#Comment_16...
0 votes
@DanC can you take another closer look at this please?   I submitted this same inquiry ealrier this year and the support person was able to SHOW ME that they could crawl synapse serverless databases with SQL Prompt ...  Please help me figure this out:  https://forum.red-gate.com/discussion/comment/168118#Comment_168118 / comments
  1. Community
  2. SQL Prompt
  3. Synapse Serverless SQL Support
@DanC can you take another closer look at this please?   I submitted this same inquiry ealrier this year and the support person was able to SHOW ME that they could crawl synapse serverless database...
0 votes
Hi @DanC Thanks for the update.  That's unfortunate [image]    Do you know if and when you may be providing support for Synapse with SQL Prompt? Cheers, Fahim. / comments
  1. Community
  2. SQL Prompt
  3. Synapse Serverless SQL Support
Hi @DanC Thanks for the update.  That's unfortunate   Do you know if and when you may be providing support for Synapse with SQL Prompt?Cheers,Fahim.
0 votes
Synapse Serverless SQL Support
  1. Community
  2. SQL Prompt
Hi There,I'm having issues getting SQL Prompt to provide functionality on Synapse Serverless databases.  I'm an admin on the synapse resource and have full administrative rights inside the workspac...
2 followers 5 comments 0 votes
Hi @Jon_Kirkwood ANy update here?  I'm still struggling with this.  Happy to schedule a call with you to show you the issue first-hand! RSVP Fahim. / comments
  1. Community
  2. SQL Prompt
  3. Synapse Serverless SQL Support
Hi @Jon_Kirkwood ANy update here?  I'm still struggling with this.  Happy to schedule a call with you to show you the issue first-hand!RSVPFahim.
0 votes
Hi Jon, Same issue after the upgrade.  Here's the relevant pieces of the verbose log: 2022-01-21 12:56:07.355 -08:00 [Debug] Checking is contained or restricted 2022-01-21 12:56:08.868 -08:00 [Debug] Contained or restricted: >2012 2022-01-21 12:56:10.272 -08:00 [Debug] Loading server capabilities 2022-01-21 12:56:10.341 -08:00 [Information] Chosen server capabilities "Sql2014" 2022-01-21 12:56:10.860 -08:00 [Warning] Failed to load server XXXXXXXXXXXXXX-ondemand.sql.azuresynapse.net System.Data.SqlClient.SqlException (0x80131904):  'sysdatabases' is not supported.    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)    at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)    at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()    at System.Data.SqlClient.SqlDataReader.get_MetaData()    at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)    at System.Data.SqlClient.SqlCommand.ExecuteReader()    at RedGate.SqlPrompt.Cache.Candidates.ServerCandidate.PopulateDatabases(SqlConnection masterConnection, Boolean wasSkippedDueToFilter)    at RedGate.SqlPrompt.Cache.Candidates.ServerCandidate.LoadServer() ClientConnectionId:XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX Error Number:15871,State:10,Class:16 Screenshots of software versions.  I recall you mentioned the SQL Version before - this is synapse on-demand SQL and it's not something I choose - it's what MS provides. [image] [image] [image] Also, I'm explicitly configured as the SQL AD Admin on the resource  I'm curious about the "sysdatabases" utility in the log.  According to MS that view is just for backwards compatibility - Should updated approaches to getting the necessary information be used https://docs.microsoft.com/en-us/sql/relational-databases/system-compatibility-views/sys-sysdatabases-transact-sql?view=sql-server-ver15 / comments
  1. Community
  2. SQL Prompt
  3. Synapse Serverless SQL Support
Hi Jon,Same issue after the upgrade.  Here's the relevant pieces of the verbose log:2022-01-21 12:56:07.355 -08:00 [Debug] Checking is contained or restricted2022-01-21 12:56:08.868 -08:00 [Debug] ...
0 votes
Hi Jon, Any update on this item?  Is there something you're waiting on me to provide? RSVP Fahim. / comments
  1. Community
  2. SQL Prompt
  3. Synapse Serverless SQL Support
Hi Jon,Any update on this item?  Is there something you're waiting on me to provide?RSVPFahim.
0 votes
Hi Jon, Using the latest version of SSMS I believe [image] did the test with a SQL user - same result with db_owner provided Turned on verbose logging and tried to create "clean" logs of both scenarios for your review. RE: I did notice that you are potentially using SQL Server 2014. This is not supported past SQL Prompt v10.3 and may also be a contributing factor to this issue. This is the SQL Server compatibility version that synapse serverless SQL endpoint provides by default - I don't think it's configurable, is it? Cheers, Fahim. / comments
  1. Community
  2. SQL Prompt
  3. Synapse Serverless SQL Support
Hi Jon,Using the latest version of SSMS I believedid the test with a SQL user - same result with db_owner providedTurned on verbose logging and tried to create "clean" logs of both scenarios for yo...
0 votes
Hi Jon, So I'm an owner on the resource  [image] [image] and I don't get any intellisense on the views: [image] [image] I've even tried adding myself explicitly as db_owner on the serverless db, but doesn't seem like it's a permissions issue. I'm using version 10.9.2.25020 [image] Here's the log dump when I try to refresh the cache:   2021-11-29 09:15:23.923 -08:00 [Information] Chosen server capabilities "Sql2014" 2021-11-29 09:15:24.463 -08:00 [Warning] Failed to load server [REDACTED]-ondemand.sql.azuresynapse.net System.Data.SqlClient.SqlException (0x80131904):  'sysdatabases' is not supported.    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)    at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)    at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()    at System.Data.SqlClient.SqlDataReader.get_MetaData()    at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)    at System.Data.SqlClient.SqlCommand.ExecuteReader()    at RedGate.SqlPrompt.Engine.Cache.Candidates.ServerCandidate.PopulateDatabases(SqlConnection masterConnection, Boolean wasSkippedDueToFilter)    at RedGate.SqlPrompt.Engine.Cache.Candidates.ServerCandidate.LoadServer() ClientConnectionId:2444b62c-a133-4789-a2b5-a06f45eb229f Error Number:15871,State:10,Class:16 / comments
  1. Community
  2. SQL Prompt
  3. Synapse Serverless SQL Support
Hi Jon,So I'm an owner on the resource and I don't get any intellisense on the views:I've even tried adding myself explicitly as db_owner on the serverless db, but doesn't seem like it's a permissi...
0 votes
Total activity
11
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2