 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
[7.2.338] SQL 2014 Unsupported Window Class |
|
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 |
|
 |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
|
|
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 |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
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 |
|
 |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
|
|
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 |
|
 |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
|
|
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 |
|
 |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
|
|
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 |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
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 |
|
 |
|
|
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
|
|
|