How can we help you today? How can we help you today?

Why does sql prompt 9.1.1.4243 not work with sql authentication

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
0

Comments

4 comments

  • scmchugh
    Update. Support does not have a clue what the problem might be.
    scmchugh
    0
  • 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.
    scmchugh
    0
  • 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
    RichardL
    0
  • 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.
    Martinro73
    0

Add comment

Please sign in to leave a comment.