SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Asking for credential every time

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Asking for credential every time
Author Message
hcoello



Joined: 05 Feb 2009
Posts: 5
Country: Honduras

Post Asking for credential every time Reply with quote
Every Time that i connect is asking for credential, i'm using 3.5 and the database is SQL2000, the SO of my machine is Vista, the sql client is "Microsoft SQL Server Management Studio" is the one that come with SQL2005.

it doesn't store my credential.
Fri Feb 06, 2009 12:23 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7849

Post Reply with quote
1. You need to register SQL Assistant add-on for SSMS (please see documentation for details)
2. Start SSMS as an administrator (please don't assume that when are logged in as an admin and you double-click SSMS icon, it starts in admin mode, Vista doesn't work that way), you need to right-click on the icon as chose Run As Administrator. In that case SQL Assistant will be able to share connections with SSMS and you won't see connection prompts appearing on the screen.
Fri Feb 06, 2009 12:28 pm View user's profile Send private message
hcoello



Joined: 05 Feb 2009
Posts: 5
Country: Honduras

Post Reply with quote
But this about run the SSMS as Administrator it will be just one time, or every time that i start it.
Mon Feb 09, 2009 10:39 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7849

Post Reply with quote
Yes, in version 3.5 you need to start SSMS it as an admin every time, otherwise Vista will not allow SQL Assistant to access correct files and registry settings (this is all transparent to SQL Assistant and caused by Vista design, that doesn't happen on XP, Win2003 and other systems).

The only way to avoid it using admin mode is to upgrade to SQL Assistant v4.5 and use the Auto-Connect feature available in that version.
Mon Feb 09, 2009 3:18 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.