SQL Server Login Box displaying when not needed?

Started by AndyMacrae, November 08, 2016, 08:52:27 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

AndyMacrae

Hi,

I manage a large test lab and we use visio to track and manage all the hardware.  I have written custom code that detects when another user has added/removed/changed a workstation in some way and refreshes that info on my version of the visio.  The problem is it presents the SQL Server Login screen for each and every one.  If a user moves 12 workstations, the dialog pops up 12 times for anyone trying to refresh their version of the visio.  The code works fine.  The issue is how can I suppress the SQL Server Login dialog?

Thank you for any information you can provide.  This site has saved me a number of times :).

jik_ff

the only thing that comes to mind is the user's permissions on the SQL server.  On the connection string, is there a login specified?  Might be that the password is old...

Browser ID: smf (is_webkit)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 144 (show)
Files included: 34 - 1321KB. (show)
Memory used: 1094KB.
Tokens: post-login.
Cache hits: 12: 0.00216s for 26,583 bytes (show)
Cache misses: 1: (show)
Queries used: 17.

[Show Queries]