SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SQL Assistant tab not showing in SSMS

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
SQL Assistant tab not showing in SSMS
Author Message
xterradjr



Joined: 18 Sep 2020
Posts: 1
Country: United States

Post SQL Assistant tab not showing in SSMS Reply with quote
Hi

Im not able to get the SQL Assistant tab showing in SSMS when I open a query window

Running the diagnostics, i see this error:

Loading SqlAssist.CSmsAddin10... FAILED
Error = 0x80070002: The system cannot find the file specified.

Here is my sql assistant info
Version 10..0.187 Professional Edition
with a valid license

Here is my ssms info

Microsoft SQL Server Management Studio 14.0.17285.0
Microsoft Analysis Services Client Tools 14.0.1016.283
Microsoft Data Access Components (MDAC) 10.0.17763.1
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.11.17763.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 6.3.17763

Sql assistant is running on my machine, and in ssms if i right click on the object explorer db, i do see the SQL Assistant appear in the context menu

Also, all my sql assistant options do target SQL Server

However no sql assistant features work in my query window, like code snippets, intellisense

Thoughts?
Fri Sep 18, 2020 9:13 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7141

Post Reply with quote
I suggest to try disabling and reenabling the SQL Assistant add-on for SSMS. If something has changed in the system, it should refresh the registry entries and the integration files too

In the Target settings in the Options dialog find MS Management Studio, expand the Advanced section on the right, and change the value of "Register SQL Assistant Add-on" to No. Click Apply and then change it back to Yes, and apply again. After that restart the SSMS.

If that doesn't help, you may want to try installing a SQL Assistant upgrade. Version 10.0 is about 2 years old. Your Windows system surely had some patches installed, perhaps SSMS got updated too along with other dependencies and some files changed. The latest SQL Assistant version is 11.3. There've been lots of updates in versions 10.1, 10.2, 11.0, 11.1, 11.2, 11.3, you are currently behind by 6 releases. More details can be found here http://www.softtreetech.com/sqlassist/whatsnew11.htm. I don't know if upgrading is an option for you, but I kind of expect it to resolve the issue you are having. Along new features added, the maintenance releases provide software compatibility fixes, things change with time and require updates.
Fri Sep 18, 2020 12:55 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.