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

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



(prashantnerkar@yahoo.com)




	
Quote:
	

	

		

			
				Originally posted by Scott Thompson 

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 
			
		
	
	

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:

[vbcol=seagreen]

>

>Are you able to fix this issue. I also get similar popups. What fix did

>you applied?. Please let me know

>

>(prashantnerkar@yahoo.com)

>

>Scott Thompson wrote: