Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP .Net Security > Intranet access to SQL Server security issue

Reply
Thread Tools

Intranet access to SQL Server security issue

 
 
chris.nolan@feltex.com
Guest
Posts: n/a
 
      03-29-2006
I've lost count of the number of postings I have read on this subject
yet I can not find an answer.

I've set up my config file with impersonation as true, IIS is set to
Basic and Integrated authentication. The web page works fine on my
local machine, but on the intranet server I get the error Login
failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.

The SQL server security is set as Windows and SQL Server. I have added
the Domain Users group to SQL Server and given it access to the
database.

Anybody have any ideas?

My local machine uses IIS 5.1 and the intranet server uses IIS 6.0 .
Could this be the issue?

 
Reply With Quote
 
 
 
 
chris.nolan@feltex.com
Guest
Posts: n/a
 
      03-29-2006
Sorry, I meant IIS is set to Anonymous and Integrated authentication.

 
Reply With Quote
 
 
 
 
Dominick Baier [DevelopMentor]
Guest
Posts: n/a
 
      03-29-2006
http://msdn.microsoft.com/msdnmag/is...s/default.aspx

---------------------------------------
Dominick Baier - DevelopMentor
http://www.leastprivilege.com

> I've lost count of the number of postings I have read on this subject
> yet I can not find an answer.
>
> I've set up my config file with impersonation as true, IIS is set to
> Basic and Integrated authentication. The web page works fine on my
> local machine, but on the intranet server I get the error Login
> failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
>
> The SQL server security is set as Windows and SQL Server. I have added
> the Domain Users group to SQL Server and given it access to the
> database.
>
> Anybody have any ideas?
>
> My local machine uses IIS 5.1 and the intranet server uses IIS 6.0 .
> Could this be the issue?
>



 
Reply With Quote
 
chris.nolan@feltex.com
Guest
Posts: n/a
 
      03-29-2006
I thought I was there for a second. Unfortunately we are not running
AD. How do I get around this?

 
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
Access denied due to security settings for intranet K Viltersten ASP .Net 2 10-06-2008 09:14 AM
Help. Getting a An error has occurred while establishing a connectionto the server. When connecting to SQL Server 2005, this failure may be causedby the fact that under the default settings SQL Server does not allow remote aboutjav.com@gmail.com ASP .Net 0 05-03-2008 12:43 PM
ACCESS AN ACCESS DATABASE FROM ASP.NET INTRANET SCENARIO =?Utf-8?B?a21jY29za2V5?= ASP .Net 7 04-30-2007 07:44 PM
ACCESS AN ACCESS DATABASE FROM ASP.NET INTRANET SCENARIO kmccoskey ASP .Net Security 2 04-27-2007 02:45 PM
ASP:NET on Intranet - Windows Authentication to Access SQL Server andy ASP .Net 2 11-16-2005 07:15 PM



Advertisments