Why does sql prompt 9.1.1.4243 not work with sql authentication

scmchugh

After "upgrading" to SQL Prompt 9.1.1.4243 I can no longer load suggestions for any database where I use sql authentication. I have SSMS versions 11.0.5058.0 and 14.0.17213. Neither version has any issue with AD authentication but neither version can load suggestions for any database where I use sql authentication. This was not a problem in previous versions. I either need this fixed immediately or I need to rollback to a version that will work with sql authentication.

scmchugh

Update. Support does not have a clue what the problem might be.

scmchugh

For those who follow me down this path: SQL Prompt 8.2 will not work with SQL authentication. SQL Prompt 7.5 will work with SQL authentication but not with SMSS 14.017213 only SMSS 11.0.5058. What a joke. This used to be one of the best tools around. It is now worthless and from what I am reading this is a known issues. Time to look at the competition.

RichardL

Hi @scmchugh

Thanks for your posts and for joining.

I can see that you have a support ticket open with us and so we will be in touch through there.

Kind regards

Martinro73

What was the resolution to these problems reported?  I'm experiencing this issue, too.

UPDATE:
No need to respond I found resolution to the problem once I identified the problem errored in the log file for Sql Prompt.  The problem was resolved in this alternate post: Suggestions Not Refreshing due to Certificate Chain Error Logged.