> I'm getting Not associated with a trusted SQL Server connection
> errors on a .Net windows service I wrote, when it's running on my
> application server.
>
> It's not a problem with mixed mode security. I'm set for mixed mode and
> I've been running the service on the app server for over a month with
> no problem. My database is running on a second server and both are
> under the same domain.
>
> The problem has occurred twice over the last two months.
>
> The windows service queries a table every 30 seconds, looking for
> records to process. It's using a connection string and the user id is
> setup and working in SQL. That when it's generating the error.
>
> I've changed the connection string user id to sa and I still get the
> problem. (server=xxx;database=yyy;user=sa;pwd=xyz)

> Well, if you get that error when you proivde user id/password, that
> usually means that SQL Server is configured for Windows
authentication
> only.

> What happans if you change the connection string to use integrated
> security?

Erland Sommarskog wrote:
> epaetz (epaetz41@hotmail.com) writes:
> > I'm getting Not associated with a trusted SQL Server connection
> > errors on a .Net windows service I wrote, when it's running on my
> > application server.
> >
> > It's not a problem with mixed mode security. I'm set for mixed mode
and
> > I've been running the service on the app server for over a month
with
> > no problem. My database is running on a second server and both are
> > under the same domain.
> >
> > The problem has occurred twice over the last two months.
> >
> > The windows service queries a table every 30 seconds, looking for
> > records to process. It's using a connection string and the user id
is
> > setup and working in SQL. That when it's generating the error.
> >
> > I've changed the connection string user id to sa and I still get
the
> > problem. (server=xxx;database=yyy;user=sa;pwd=xyz)
>
> Well, if you get that error when you proivde user id/password, that
> usually means that SQL Server is configured for Windows
authentication
> only.
>
> What happans if you change the connection string to use integrated
> security?
>
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp