 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
rnan
Joined: 12 Jul 2012 Posts: 56 Country: Faroe Islands |
|
New server - no autocomplete ? |
|
We have created a new sql server ( new server) ( replaced the old one)
Same credentials.
the problem is that we can't see autocomplete .
We also refreshed + connect+ refresh in Sql assistant : but there is no tables at all :
Image :
this used to work .
Is there any port/permissions for sqlassistant ?
PS the query DOES yields results :

|
|
Tue Jun 30, 2015 10:28 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
What do you mean by refreshed connect?
SQL Assistant normally shares connections with SSMS. What you see in SSMS is what should be visible to SQL Assistant. There should not be separate connect prompts.
Please try disabling and then reenabling SQL Assistant's plugin for SSMS.
|
|
Tue Jun 30, 2015 5:02 pm |
|
 |
rnan
Joined: 12 Jul 2012 Posts: 56 Country: Faroe Islands |
|
|
|
Thanks for reply.
By "refreshed & connect " - I mean those two :
Regarding : "Please try disabling and then reenabling SQL Assistant's plugin for SSMS." — How do I do it ?
|
|
Tue Jun 30, 2015 5:08 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
Tue Jun 30, 2015 6:05 pm |
|
 |
rnan
Joined: 12 Jul 2012 Posts: 56 Country: Faroe Islands |
|
|
|
I removed the registration and closed SSMS and run again ( make sure it is connected) — but still no tables.
You can see here :
https://goo.gl/photos/kHSuXuWayJUdmQ4H6
(Already checked if tables are listed in "List Items") - but it must have something else.
We have another 6 servers ( sql servers - all fine with them !) - sqlassistant works great with them
it's just that one new server is problematic. ( and as you can see in the previous post - the query & connection is valid and there're results.)
|
|
Wed Jul 01, 2015 2:40 am |
|
 |
rnan
Joined: 12 Jul 2012 Posts: 56 Country: Faroe Islands |
|
|
|
Just wanted to update
the problem was missing service pack which solved all problems.
Now it's ok.
Thank you.
|
|
Wed Jul 01, 2015 8:01 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Thank you very much for the status update
|
|
Wed Jul 01, 2015 9:14 am |
|
 |
|
|
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
|
|
|