Comments
Sort by recent activity
@AdrianB As mentioned in previous posts, the user running the converter has access to both folder locations, the SSMS path is to a directory containing snippet files, and the ADS path is a file path of the sql.json of ADS. I understand this product is in preview and I will receive limited support through this forum, but I hope this can be resolved in a future release. I would migrate from SSMS to ADS permanently if SQL Prompt works properly, but your product is not quite there yet. / comments
@AdrianB As mentioned in previous posts, the user running the converter has access to both folder locations, the SSMS path is to a directory containing snippet files, and the ADS path is a file pat...
@AdrianB, I am able to navigate to this location without issue. As a test, I created another location and explicitly mapped ADS SQL prompt to that location. Still had an access denied error. See attached. It also triggers a system log warning event ID 10016. The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID {2593F8B9-4EAF-457C-B68A-50F6B8EA6B54} and APPID {15C20B67-12E7-4BB6-92BB-7AFF07997402} to the user xxxxxxxx from address LocalHost (Using LRPC) running in the application container Unavailable SID (Unavailable). This security permission can be modified using the Component Services administrative tool. / comments
@AdrianB, I am able to navigate to this location without issue. As a test, I created another location and explicitly mapped ADS SQL prompt to that location. Still had an access denied error. See at...
@AdrianB I ran the command line statement as administrator and received the same error. / comments
@AdrianB I ran the command line statement as administrator and received the same error.
Snippets are not importing from SSMS with v0.2.6. My SSMS and ADS snippet files are currently residing in the default locations listed in this thread. However, the ADS snippet file - sql.json - only contains {}. I tried to explicitly enter the file paths in the Ads Snippets file and Ssms Snippets folder. When I do, I receive an access denied error in ADS when trying to open the ADS snippet sql.json file. How do I resolve this? / comments
Snippets are not importing from SSMS with v0.2.6. My SSMS and ADS snippet files are currently residing in the default locations listed in this thread. However, the ADS snippet file - sql.json - onl...