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

"Rudy" <Rudy@discussions.microsoft.com> wrote in message
news:85A7C63F-5B7A-452D-A72C-373CA201764F@microsoft.com...

> 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
>