not associated with a trusted sql connection

[Guest]

Hi in my page i am getting the following error

Message "Login failed for user '(null)'. Reason: Not associated with a
trusted SQL Server connection." String

This only happens in ASP.net and doesn't happen in windows applications how
can i stop it from happening.

regards

 

[Miha Markic [MVP C#]]

Hi Steven,

That's because your asp.net application is running on local asp.net account.
Either use username/password when connecting to sql server (not recommended)
or run your asp.net application under a trusted account.
If your sql server is on the same machine then you could add asp.net account
to the sql server logins.
What OS are you running on?

 

[Guest]

I'm running on windows xp the sql box is on a server i'm currently doing
testing locally on my pc through vs.net

Hi Steven,

That's because your asp.net application is running on local asp.net account.
Either use username/password when connecting to sql server (not recommended)
or run your asp.net application under a trusted account.
If your sql server is on the same machine then you could add asp.net account
to the sql server logins.
What OS are you running on?

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Hi in my page i am getting the following error

Message "Login failed for user '(null)'. Reason: Not associated with a
trusted SQL Server connection." String

This only happens in ASP.net and doesn't happen in windows applications
how
can i stop it from happening.

regards

 

[Guest]

also i have set iis to use windows authentication

Hi Steven,

That's because your asp.net application is running on local asp.net account.
Either use username/password when connecting to sql server (not recommended)
or run your asp.net application under a trusted account.
If your sql server is on the same machine then you could add asp.net account
to the sql server logins.
What OS are you running on?

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Hi in my page i am getting the following error

Message "Login failed for user '(null)'. Reason: Not associated with a
trusted SQL Server connection." String

This only happens in ASP.net and doesn't happen in windows applications
how
can i stop it from happening.

regards

 

[Paul Clement]

¤ I'm running on windows xp the sql box is on a server i'm currently doing
¤ testing locally on my pc through vs.net
¤

See the following:

http://harishmvp.blogspot.com/2005/05/you-may-receive-error-login-failed-for_25.html


Paul
~~~~
Microsoft MVP (Visual Basic)