Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intranet


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 *



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

.

Relevant Pages

  • Re: Credentials not being passed with remote access
    ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
    (microsoft.public.sqlserver.security)
  • Re: Very basic login question
    ... In order to use Windows Authentication the two computers have to be members of the same domain or trusted domains. ... you should have a login at the SQL Server on the XP Pro workstation. ...
    (microsoft.public.sqlserver.security)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intranet
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL server 2005 login issure 2
    ... My programming knowlege is pretty rusty, but if you installed SQL Server ... if you installed with Windows Authentication and then ... ALTER LOGIN sa ENABLE; ... > If by any change you have read my original post titled "SQL Server 2005 ...
    (microsoft.public.sqlserver.connect)