> installed Sql Server 2005 Mobile Edition into an IIS6 virtual directory
> security for Anonymous with a custom application pool
>
> when configured to use a sql account name and password on the connection
> string - everything works as expected.
>
>
> however, if the connection string passed to sqlcesa30.dll is
> "Provider=sqloledb; integrated security=SSPI; persist security info=False;
> .....etc.
>
> the error in sqlcesa30.log is "Login failed for user
> 'servername\IUSR_machinename"
>
> my question is how can I get sqlcesa30.dll to run with the IIS6 Web
> Applicaton pool account credentials instead of IIS account ?
>

"Hilary Cotter" wrote:

> You should be able to pass an Internet login and internet password to use as
> a proxy account to pass an account which has the rights you require.
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Doug Richardson" <DougRichardson@discussions.microsoft.com> wrote in
> message news:9DB62F6D-6B17-4DAB-809A-EA0F9B6A3F1A@microsoft.com...
> > installed Sql Server 2005 Mobile Edition into an IIS6 virtual directory
> > security for Anonymous with a custom application pool
> >
> > when configured to use a sql account name and password on the connection
> > string - everything works as expected.
> >
> >
> > however, if the connection string passed to sqlcesa30.dll is
> > "Provider=sqloledb; integrated security=SSPI; persist security info=False;
> > .....etc.
> >
> > the error in sqlcesa30.log is "Login failed for user
> > 'servername\IUSR_machinename"
> >
> > my question is how can I get sqlcesa30.dll to run with the IIS6 Web
> > Applicaton pool account credentials instead of IIS account ?
> >
>
>