SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[7.2.338] SQL 2014 Unsupported Window Class

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[7.2.338] SQL 2014 Unsupported Window Class
Author Message
judahr



Joined: 09 Mar 2007
Posts: 319
Country: United States

Post [7.2.338] SQL 2014 Unsupported Window Class Reply with quote
I'm having an issue trying to get SQL Assistant to connect to SQL 2014 32bit. Things I've tried:

Uninstall/reinstall SQL Assistant
Run as admin unregister/register add in for SQL Management Studio.

When I try the target options, I get this:

---------------------------
SQL Assistant - Warning
---------------------------
Unsupported window class (HwndWrapper[DefaultDomain;;281b22ed-c334-49f7-8fd5-543e8a67e4c1]).
---------------------------
OK
---------------------------

I explicitly run ssms.exe from programs (x86) directory to ensure I am running the 32 bit version.
Mon Aug 24, 2015 11:24 am View user's profile Send private message
judahr



Joined: 09 Mar 2007
Posts: 319
Country: United States

Post Reply with quote
If I run both as under a local admin account, it works. But I can't do that day-to-day.
Mon Aug 24, 2015 2:25 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7948

Post Reply with quote
You only need to do that once, the add-on registration should complete, and then you can do it normally.
PS. SSMS comes 32-bit edition only, so is Visual Studio and all other Visual Studio based IDEs and tools.
Mon Aug 24, 2015 5:33 pm View user's profile Send private message
judahr



Joined: 09 Mar 2007
Posts: 319
Country: United States

Post Reply with quote
Here is what I did to fix (replace <USERNAME> with login name)


Copy a file called extension.vsixmanifest to (copied from my Admin logon)
C:\Users\<USERNAME>\AppData\Local\Microsoft\SQL Server Management Studio\12.0\Extensions\SoftTree Technologies\SqlAssist.vs\1.0


Added following registry keys

[HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio\12.0\ExtensionManager\EnabledExtensions]
"SqlAssist.vs..3d117742-b761-4b83-86ce-ca2aa58a8660,1.0"="C:\\Users\\<USERNAME>\\AppData\\Local\\Microsoft\\SQL Server Management Studio\\12.0\\Extensions\\SoftTree Technologies\\SqlAssist.vs\\1.0\\"


[HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio\12.0_Config\Initialization\LoadedUserExtensions]
"ext001"="C:\\Users\\<USERNAME>\\AppData\\Local\\Microsoft\\SQL Server Management Studio\\12.0\\Extensions\\SoftTree Technologies\\SqlAssist.vs\\1.0\\"


Open SQL 2014
CTRL-Shift-F5 (target - which now no longer throws an error)
Set that up

Then it works. Hope this helps someone and you guys to check those conditions when registering.
Wed Aug 26, 2015 3:05 pm View user's profile Send private message
judahr



Joined: 09 Mar 2007
Posts: 319
Country: United States

Post Reply with quote
The only problem with the above, is that it doesn't stick. If you close and reopen, the integration goes away. You have to do the whole CTRL-F5 setup every time it opens.
Wed Aug 26, 2015 3:11 pm View user's profile Send private message
judahr



Joined: 09 Mar 2007
Posts: 319
Country: United States

Post Reply with quote
I uninstalled another addin SSMS tools. For some reason they work fine together when running as Administrator. When as a normal user, it does not. I filed a request with them, and I will file one with you.

Their support contact:
support@ssmstoolspack.com
Wed Aug 26, 2015 3:44 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7948

Post Reply with quote
All the issues are security related, caused by Windows UAC and by domain rules that make Windows silently wipe out all your configuration changes. If you disable UAC, make changes, then they should stick. You can reenable UAC later.
Wed Aug 26, 2015 5:48 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.