Eliminate Data connection Security Prompt

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

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" <[email protected]> wrote...
>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.

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.