Eliminate Data connection Security Prompt

  • Thread starter Thread starter DLG
  • Start date Start date
D

DLG

I have an Excel file that get data from a SQL Server Stored Procedure that
is accessed through a SQL Server login. Currently a Login box comes up and I
need to enter the user and password. Is there any way that I can prevent the
login dialog from showing. The SQL Server Login that I am using has readonly
permissions without a password and I would like to make it easier for my
users to refresh the data in the workbook.
TIA
Dean
 
yeah, screw Excel use Access

without a password you ****ing dipshit; never, ever, ever, ever, ever
do that

-Aaron

(but yuo should be able to setup a DSN that would do this without a
problem-- i just dont know when it occurred to me that Excel has a
bigger brother (Access and SQL Server); i refused to use Excel)
 
Aaron, I've used Access for over 10 years and am very familiar with when it
should and should not be used. It is not the right tool for the problem I
have. It is not the solution to everything. You need to get a wider
perspective.
 
i dont believe you.

if you knew Access well enough; you wouldnt' EVER use Excel.

lose the training wheels you're fighting for the dark side
 
DLG said:
I have an Excel file that get data from a SQL Server Stored Procedure that
is accessed through a SQL Server login. Currently a Login box comes up and I
need to enter the user and password. Is there any way that I can prevent the
login dialog from showing. The SQL Server Login that I am using has readonly
permissions without a password and I would like to make it easier for my
sers to refresh the data in the workbook.
Click to expand...

I'd guess you need to talk with your database administrator. It's possible
your company requires logins for every database access. Even if you have
read-only access to these tables so you can't modify them inadvertently,
there's the possibility of unauthorized access to sensitive data.
 
Back
Top