Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP .Net Security > Trusted sql connection failure

Reply
Thread Tools

Trusted sql connection failure

 
 
Arie
Guest
Posts: n/a
 
      02-13-2005
Hi all

I have a asp.net application, developed in Beta 2. It is working fine when
the project is stored in a web file system mode. I had to switch to work in a
local IIS mode, and at this mode I'm failing to connect to the database
(MSSql). This is the message in the SqlException: Login failed for user
'(null)'. Reason: Not associated with a trusted SQL Server connection.

Thnx
AZ
 
Reply With Quote
 
 
 
 
Ken Schaefer
Guest
Posts: n/a
 
      02-14-2005
Is the SQL Server located on a different machine to the IIS webserver? If
so, you probably need to run ASP.NET under a domain account (or find some
other way of sending the credentials from IIS -> SQL Server). At the moment
it appears that you are running ASP.NET under a local account (either
Machine\ASPNET or NT AUTHORITY\Network Service) and local accounts can't be
assigned permissions to remote resources.

Cheers
Ken

"Arie" <> wrote in message
newsD45121B-BDBC-4F57-90D1-...
> Hi all
>
> I have a asp.net application, developed in Beta 2. It is working fine when
> the project is stored in a web file system mode. I had to switch to work
> in a
> local IIS mode, and at this mode I'm failing to connect to the database
> (MSSql). This is the message in the SqlException: Login failed for user
> '(null)'. Reason: Not associated with a trusted SQL Server connection.
>
> Thnx
> AZ



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
trusted sql server connection problem!? Brian Henry ASP .Net 5 10-15-2003 07:33 PM
Trusted connection doesn't work with SQL server and ASP.Net Peter Afonin ASP .Net 1 08-29-2003 03:05 PM
Not associated with a trusted SQL Server connection vlad ASP .Net 3 08-21-2003 04:37 PM
Newbie Question - "trusted SQL Server connection" Greg Smith ASP .Net 1 08-20-2003 06:43 PM
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Blake Versiga ASP .Net 2 07-09-2003 07:30 AM



Advertisments
 



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57