I notice that with Release 14, shortcuts I've created in the toolbar to launch query analyzer windows for frequently used databases now require authentication each time they are clicked. This was not the case with older versions. Is this a change to how the shortcuts work or is this is a defect? I personally do not like having to re-authenticate each time I click on one of my database shortcuts - especially when launching query analyzer from the database browser does not require re-authentication.
We're not able to reproduce this if the shortcuts were created in v13 and we're clicking them in v14.
You shouldn't have to reauthenticate. If they worked in your previous ADStudio, and you didn't reorganize items in your registered servers list by moving them to new subfolders, they should still function.
Can you:
1. check the shortcut properties for the shortcuts and verify that the Link points to their appropriate connection file. (If you right click the shortcut you can view its individual properties. If you right click and choose "Configure Shortcut Toolbar" you get a list of them all)
2. verify that the connection the shortcut points to has the "Remember Password" checkbox enabled.
Let us know your results
I've confirmed that the shortcut is pointing to the right database
connections for each of the 3 shortcuts I have. All 3 of them prompt me
for authentication when clicked. So, I dug further. It turns out, I do
need to re-authenticate when choosing the database from the Database
browser. As soon as I click the + sign next to the database connection I
get the same authentication box.
It looks like Windows Single Sign-on Login Authentication connectivity is
the culprit. Clicking a shortcut that uses SQL Server Authentication works
fine as does the same connection using the database browser. To your
point, with SQL Server Authentication, the Remember Password box is
checked. With Windows Single Sign-on, you don't have that option.
I hope that helps.
I've confirmed that the shortcut is pointing to the right database
connections for each of the 3 shortcuts I have. All 3 of them prompt me
for authentication when clicked. So, I dug further. It turns out, I do
need to re-authenticate when choosing the database from the Database
browser. As soon as I click the + sign next to the database connection I
get the same authentication box.
It looks like Windows Single Sign-on Login Authentication connectivity is
the culprit. Clicking a shortcut that uses SQL Server Authentication works
fine as does the same connection using the database browser. To your
point, with SQL Server Authentication, the Remember Password box is
checked. With Windows Single Sign-on, you don't have that option.
I hope that helps.
Actually, as it turns out, a local database connection (a SQL Server Database on my local machine) with Windows Single Sign-on works fine. So apparently it's only with Windows Single Sign-on connections to databases located on other servers on the network.
Actually, as it turns out, a local database connection (a SQL Server Database on my local machine) with Windows Single Sign-on works fine. So apparently it's only with Windows Single Sign-on connections to databases located on other servers on the network.
The root cause of this seems to be that Windows Single Sign-On is not keeping "Remember Password" checked after saving server properties. Windows Single Sign-On should never let "Remember Password" get unchecked.
The root cause of this seems to be that Windows Single Sign-On is not keeping "Remember Password" checked after saving server properties. Windows Single Sign-On should never let "Remember Password" get unchecked.
We have a fix for this issue
Patch Download: http://dd1.aquafold.com/download/v14.0.0/ads-14.0.3-patch.zip
Patch Update Instructions: http://www.aquafold.com/support-update.html#v14
Once you update with this patch, let us know if it resolves the issue for you.
We have a fix for this issue
Patch Download: http://dd1.aquafold.com/download/v14.0.0/ads-14.0.3-patch.zip
Patch Update Instructions: http://www.aquafold.com/support-update.html#v14
Once you update with this patch, let us know if it resolves the issue for you.
Guys, I installed 14.0.3 and am still getting the authentication prompt. See screenshot I have emailed
Guys, I installed 14.0.3 and am still getting the authentication prompt. See screenshot I have emailed
Let me know if you need a screenshot. I can't seem to get it to copy/upload via the comment box
Let me know if you need a screenshot. I can't seem to get it to copy/upload via the comment box
Let me know if you need a screenshot. I can't seem to get it to copy/upload via the comment box
fyi - to add an attachment, you can click on the 'Add Attachment' link located under where the existing attachments are displayed. You can't directly insert an attachment into the comment.
We are no longer able to reproduce the issue after running ADS 14.0.3. Could you go to Help > Support Information to verify the patch has been applied? Also, could you try registering a new server connection and configure it for Single Sign On and let us know if that works.
Let me know if you need a screenshot. I can't seem to get it to copy/upload via the comment box
fyi - to add an attachment, you can click on the 'Add Attachment' link located under where the existing attachments are displayed. You can't directly insert an attachment into the comment.
We are no longer able to reproduce the issue after running ADS 14.0.3. Could you go to Help > Support Information to verify the patch has been applied? Also, could you try registering a new server connection and configure it for Single Sign On and let us know if that works.
ok, so if I go into each of the settings using server > properties and hit save, the issue goes away. I confirmed this with each connection. To be sure, I closed ADS and reopened it and all of the connections continue to work without re-prompting. Problem solved. Anyone experiencing this issue will likely need to go in and re-save their connections. Thanks for your help
ok, so if I go into each of the settings using server > properties and hit save, the issue goes away. I confirmed this with each connection. To be sure, I closed ADS and reopened it and all of the connections continue to work without re-prompting. Problem solved. Anyone experiencing this issue will likely need to go in and re-save their connections. Thanks for your help
Issue #10433 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build 14.0.3 |
No time estimate |
1 issue link |
depends upon #10459
Issue #10459Windows Single Sign On - user should not be prompted for password |
We're not able to reproduce this if the shortcuts were created in v13 and we're clicking them in v14.
You shouldn't have to reauthenticate. If they worked in your previous ADStudio, and you didn't reorganize items in your registered servers list by moving them to new subfolders, they should still function.
Can you:
1. check the shortcut properties for the shortcuts and verify that the Link points to their appropriate connection file. (If you right click the shortcut you can view its individual properties. If you right click and choose "Configure Shortcut Toolbar" you get a list of them all)
2. verify that the connection the shortcut points to has the "Remember Password" checkbox enabled.
Let us know your results