MS SQL Server Connectivity - Unexpected Login Screen When Accessing SQL Data Via .NET Intranet

Author

Unexpected Login Screen When Accessing SQL Data Via .NET Intranet

Scott Thompson

2005-07-15, 8:23 pm

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

prashantnerkar

2005-08-09, 3:23 am

Are you able to fix this issue. I also get similar popups. What fix did
you applied?. Please let me know

(prashantnerkar@yaho
o.com)

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 *

--
prashantnerkar
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message1735093.html

Sue Hoegemeier

2005-08-09, 8:23 pm

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@mail.mcse.ms> wrote:
[color=darkred]
>
>Are you able to fix this issue. I also get similar popups. What fix did
>you applied?. Please let me know
>
> (prashantnerkar@yaho
o.com)
>
>Scott Thompson wrote:

Sponsored Links