SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
No longer able to connect to database

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
No longer able to connect to database
Author Message
pjtaylor



Joined: 26 Sep 2013
Posts: 3
Country: United Kingdom

Post No longer able to connect to database Reply with quote
v6.4.230 with SQL Server 2012 SSMS

Has been working fine but has stopped working today in that it is not connecting to the database. I select Connect but nothing happens. I have unregistered and re-registered. Anything else I can try?
Thu Sep 26, 2013 5:34 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7948

Post Reply with quote
If you are using SQL Assistant with SSMS, nothing should happen visually when you click Connect. In a shared connection environment, the connection is owned by the host editor, this command simply attempts to repair the existing connection after it gets closed after long idle time.

Have you tried to restart your computer?
Thu Sep 26, 2013 7:40 am View user's profile Send private message
pjtaylor



Joined: 26 Sep 2013
Posts: 3
Country: United Kingdom

Post Reply with quote
Ah, I see. Yes, I've tried a reboot also without any luck. It's also not working in VS 2012 either. Any sort of logging that I can switch on?
Thu Sep 26, 2013 7:44 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7948

Post Reply with quote
Yes,. you can start it with diagnostic logging enabled. close all editors, close SQL Assistant. Start SQL Assistant from command line as

SQLAssist /SA:TraceLevel:9

This will make it output diagnostic data to SQLAssist.log file in %APPDATA%\SQL Assistant\6.4 folder.

But before you try that, try something else. Start your SSMS or VS 2012 in Run as Administrator mode and see if that does the trick.
Thu Sep 26, 2013 8:52 am View user's profile Send private message
pjtaylor



Joined: 26 Sep 2013
Posts: 3
Country: United Kingdom

Post Reply with quote
Apologies but I missed your previous post so I didn't get a chance to try your suggestions. I have reinstalled however and that seems to have worked. Thanks for your help.
Fri Sep 27, 2013 10:11 am 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.