I upgraded to SQL Prompt 10.4.0.16033 in SSMS 18.6 and now table suggestions stopped working

• 
  Same here.
  
  I get the error: The Target Principal Name is incorrect. Cannot generate SSPI context.
  
  Nothing changed other than updating SQL Prompt on SSMS 18.6
  
  SQL Server version I'm running is SQL 2017.

  chris_ford2020 September 18, 2020 00:09

  - 0 +
• 
  I also have the same problem,
  The error I get is: 
  Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. when sql promt tries to read master db.
  I have full access to the master database
  Info: 
  
  

  • SQL Server Management Studio 15.0.18338.0
  • SQL Server Management Objects (SMO) 16.100.41011.9
  • Microsoft Analysis Services Client Tools 15.0.19205.0
  • Microsoft Data Access Components (MDAC) 10.0.19041.1
  • Microsoft MSXML 3.0 6.0 
  • Microsoft .NET Framework 4.0.30319.42000
  • Operating System 10.0.19041 
  • SQL Prompt: 10.4.0.16033

  Tretli September 18, 2020 09:19

  - 0 +
• 
  Hi All,
  
  Apologies for the inconvenience this is causing.
  
  The development team is investigating this issue at the moment, we'll keep you posted.
  
  In the meanwhile, please downgrade to https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.3.10.15950.exe if necessary.

  Tianjiao_Li September 18, 2020 12:11

  - 0 +
• 
  When I click the link above and try to install, I get a message saying "A later version of this product is already installed," and the option to Continue is grayed out.  How can I downgrade?  I don't want to totally uninstall and reinstall because I'll lose all my settings, snippets, etc.  Do you have an ETA on a fix for this?  For the record, it works fine when I log onto a SQL Server with Windows auth, but I have servers not on my domain that I'm using 'sa' for, and they fail to load the master database.

  NerdGirlSteph September 18, 2020 12:59

  - 0 +
• 
  NerdGirlSteph - I had to uninstall SQL Prompt then install the file linked above. 
  
  I did not lose my tabs, history, snippets, or settings.
  
  To save your settings, go into Options -> Export
  
  save your snippets by going into Snippet Manager, and seeing the path, and moving them somewhere else.
  
  That's the safest way, I didn't do any of that.
  
  

  chris_ford2020 September 18, 2020 13:54

  - 0 +
• 
  Hi @NerdGirlSteph
  
  As @chris_ford2020 pointed out it will be necessary to uninstall SQL Prompt and then reinstall the previous version. This should not remove your snippets and settings, however you can make a backup of this by using the settings menus or by copying this folder: 
  
  %localappdata%\Red Gate\SQL Prompt 10
  
  We are working on the issue as a top priority and aim to resolve it soon.
  
  Thanks
  
  Owen

  ostandage September 18, 2020 14:05

  - 0 +
• 
  Hi all,
  
  Thanks for your patience with us!
  
  We've just released 10.4.1 which contains the fix to the reported issue. Please upgrade and let us know if there are still any issues.
  
  Thanks.

  Tianjiao_Li September 22, 2020 13:02

  - 0 +
• 
  Thank you!  I just wanted to confirm this works for me now.

  NerdGirlSteph September 25, 2020 11:54

  - 0 +

Add comment

Please sign in to leave a comment.