Text only | Text with Images

Visio Guy

Visio Discussions => Programming & Code => Topic started by: AndyMacrae on November 08, 2016, 08:52:27 PM

Title: SQL Server Login Box displaying when not needed?
Post by: AndyMacrae on November 08, 2016, 08:52:27 PM
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 :).
Title: Re: SQL Server Login Box displaying when not needed?
Post by: jik_ff on November 11, 2016, 02:30:41 AM
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...
Text only | Text with Images
Browser ID: smf (is_webkit)
Templates: 1: Printpage (default).
Sub templates: 4: init, print_above, main, print_below.
Language files: 1: index+Modifications.english (default).
Style sheets: 0: .
Hooks called: 48 (show)
Files included: 25 - 925KB. (show)
Memory used: 747KB.
Tokens: post-login.
Cache hits: 8: 0.00126s for 22,302 bytes (show)
Cache misses: 2: (show)
Queries used: 11.

[Show Queries]