Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intranet
- From: Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx>
- Date: Tue, 09 Aug 2005 18:02:29 -0600
It's going to depend on how you have security set up for
your web site. You'd probably want to start by checking the
authorization attribute in your web.config file for the
site. It sounds like the user may not be allowed accessed
based on whatever you have in the authorization section.
-Sue
On Mon, 8 Aug 2005 22:23:28 -0500, prashantnerkar
<prashantnerkar.1thgy3@xxxxxxxxxxxx> wrote:
>
>Are you able to fix this issue. I also get similar popups. What fix did
>you applied?. Please let me know
>
>(prashantnerkar@xxxxxxxxx)
>
>Scott Thompson wrote:
>> *I have an intranet application running on IIS 6. It accesses SQL
>> Server 2000
>> data and the SQL Server is on the same server. I know that it's not
>> great to
>> use IIS on the SQL Server, but we're behind a firewall, have a pretty
>> small
>> user base, and everything's been working fine for over a year.
>>
>> The application uses .NET designed forms to display and update data
>> (generally via stored procedures). Both the SQL Server and the site
>> are set
>> to use Windows Authentication.
>>
>> My problem is that one user has started getting a login popup
>> (Windows popup
>> - nothing I've created) when they try to access the site. They
>> should get
>> right in via Windows Authentication like everyone else and like they
>> did last
>> week. If they enter the Domain\User Name and Password, they may get
>> initial
>> access, but on each additional command back to the SQL Server, the
>> login
>> popup appears. And on further popups, it does not accept their
>> credentials
>> and they get the "not authorized to view this page" message.
>>
>> The strange thing is, other users are able to login to this user's pc
>> and
>> access the site with no problem (at least so far), and this user is
>> able to
>> access the site with their Windows login on other pc's with no
>> problem. It's
>> only an issue with their login on their pc, and perhaps some other
>> logins on
>> their pc. No other pc's are an issue, though I did have this
>> problem
>> previously on a pc that ended up being replaced anyway. I can ping
>> the SQL
>> Server. I tried performing a trace of logins on the SQL Server, but
>> only the
>> first successful login is recorded, not the subsequent failures (and
>> I did
>> set it to track failures). There's no problem opening any pages that
>> don't
>> access data.
>>
>> Specs: SQL Server 2000 SP 3a on Windows Server 2003. IIS 6.0.
>> Intranet
>> site
>> ...NET forms (I believe framework 1.1).
>>
>> I'm not sure if this is the best group to use because I don't know
>> the root
>> of the problem.
>>
>> Thanks,
>>
>> --
>> Scott Thompson
>> Programmer / Analyst
>> Teleflex Medical *
.
- References:
- Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intranet
- From: prashantnerkar
- Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intranet
- Prev by Date: Re: Insert, update does not work , until SQL server restart.
- Next by Date: Re: Insert, update does not work , until SQL server restart.
- Previous by thread: Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intranet
- Next by thread: Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
- Index(es):
Relevant Pages
|
