Hi Rick,

I do have the same problem of end users getting prompted for SQL server authentication.

May I request you for the work around?

THanks

Mahidhar

"Mahidhar Rao" wrote in message news:200861293226mahidharb@indiatimes.com...
> Hi Rick,
>
> I do have the same problem of end users getting prompted for SQL server
> authentication.
>
> May I request you for the work around?
>
> THanks
>
> Mahidhar

Hi Mahidhar

To use SQL Server Authentication, you will need to make sure that your
instance is configured to accept SQL Server and Windows Authentication. For
SQL 2000 the connection string is something like:

Driver={SQL
Server};Server=myServerAddress;Database=myDataBase ;Uid=myUsername;Pwd=myPassword;

For SQL Server 2005 you can use the Native driver:

Driver={SQL Native
Client};Server=myServerAddress;Database=myDataBase ;Uid=myUsername;Pwd=myPassword;

John