connection string question

I've been reading that I can't do this so I'm hoping someone smarter than I
can prove me wrong. Here is the scenario:
I have a SQL 2005 Report server running joined to Domain A.
I have a SQL 2000 server running on a workgroup machine with Windows Only
authentication enabled.
No trust can be established and the SQL 2000 box can't be switched to Mixed
mode authentication.
Can I create a connection string that would pass Windows creds instead of
SQL creds?
Thanks in advance for any advice!No. Windows credential of the Reporting Services box cannot be authenticated
by the SQL Server2000 box in this case. The only way is enable SQL
Server2000's mixed security mode and use SQL Server login username/password.
End of story.
"Zarborg" <Zarborg@.discussions.microsoft.com> wrote in message
news:4849EED4-788E-4EA3-A1DA-B764C13DC711@.microsoft.com...
> I've been reading that I can't do this so I'm hoping someone smarter than
> I
> can prove me wrong. Here is the scenario:
> I have a SQL 2005 Report server running joined to Domain A.
> I have a SQL 2000 server running on a workgroup machine with Windows Only
> authentication enabled.
> No trust can be established and the SQL 2000 box can't be switched to
> Mixed
> mode authentication.
> Can I create a connection string that would pass Windows creds instead of
> SQL creds?
> Thanks in advance for any advice!|||Poop. That's what I was reading. Thanks for the crushing blow to my
project! ;-)
"Norman Yuan" wrote:
> No. Windows credential of the Reporting Services box cannot be authenticated
> by the SQL Server2000 box in this case. The only way is enable SQL
> Server2000's mixed security mode and use SQL Server login username/password.
> End of story.
> "Zarborg" <Zarborg@.discussions.microsoft.com> wrote in message
> news:4849EED4-788E-4EA3-A1DA-B764C13DC711@.microsoft.com...
> > I've been reading that I can't do this so I'm hoping someone smarter than
> > I
> > can prove me wrong. Here is the scenario:
> > I have a SQL 2005 Report server running joined to Domain A.
> > I have a SQL 2000 server running on a workgroup machine with Windows Only
> > authentication enabled.
> > No trust can be established and the SQL 2000 box can't be switched to
> > Mixed
> > mode authentication.
> >
> > Can I create a connection string that would pass Windows creds instead of
> > SQL creds?
> >
> > Thanks in advance for any advice!
>