Reason: Not associated with a trusted SQL Server connection.

[Rudy]

Hello all,

I posted this on SQL newsgroup as well, not sure who may know the answer.

I'm developing a asp.net program. Everything works great, exceppt...
When I moved my database from my developer machine, that has SQL on it, to
my SQL server 2000 machine, I get the following error - "Login failed for
user '(null)'. Reason: Not associated with a trusted SQL Server connection. "

I checked all my permisions for my server, and DB. I'm working with IIS
5.0, and as far as I can tell, everything is set up fine. I'm just using
windows auth, so at this point trying to make it as simple as possible. Do I
need to link the computers together.

Oh yeah, and it's on a domain. My domain server and SQL server are running
on the same computer., my developer computer is also part of the domain. Any
other info you need, I will be happy to supply. Any tips and help would be
great!!

TIA


Rudy

 

[Ken Schaefer]

Answered in the m.p.sqlserver.security group

Cheers
Ken