Welcome to HostingForumz.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Windows requires sign on

  
   Web Hosting Problem Solving Community! (Home) -> IIS RSS
Next:  IIS 6 pool stops  
Author Message
vhaakmat

External


Since: Mar 11, 2004
Posts: 3



(Msg. 1) Posted: Sat Mar 13, 2004 12:20 pm
Post subject: Windows requires sign on
Archived from groups: microsoft>public>inetserver>iis (more info?)
Hi. I wrote an vb.net/asp.net 1.1 app that runs fine partially. The menus (a
datgrid) and dropdown lists contents are coming from a sql table, and those
load fine. But whenever a user needs to get info from a sql server residing
on that server (win2003), A login screen keeps on popping up. If the users
presses cancel, then it continues whith displaying the results.
How can I solve his problem?

Thanks

Vincent

 >> Stay informed about: Windows requires sign on 
Back to top
Login to vote
user658

External


Since: Aug 26, 2003
Posts: 1525



(Msg. 2) Posted: Sun Mar 14, 2004 5:14 pm
Post subject: Re: Windows requires sign on [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Sat, 13 Mar 2004 09:20:28 -0400, "Vincent Haakmat"
<vhaakmat.RemoveThis@caribeserve.net> wrote:

 >Hi. I wrote an vb.net/asp.net 1.1 app that runs fine partially. The menus (a
 >datgrid) and dropdown lists contents are coming from a sql table, and those
 >load fine. But whenever a user needs to get info from a sql server residing
 >on that server (win2003), A login screen keeps on popping up. If the users
 >presses cancel, then it continues whith displaying the results.
 >How can I solve his problem?

Hard to tell for sure with your lack of details, but most likely is
the SQL authentication is using Windows Integrated and you're not
passing a valid Windows login. Of course, posting a code snippet in
the .NET groups might get you further, since IIS is working fine.

Jeff<!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: Windows requires sign on 
Back to top
Login to vote
user1382

External


Since: Feb 04, 2004
Posts: 24



(Msg. 3) Posted: Mon Mar 15, 2004 6:53 pm
Post subject: RE: Windows requires sign on [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Hi Vincient,

What type of authenication are you using for your application? When you get
the prompt is it for username, password and
domain? Sometime if you run filemon during the request it will give you a
bit more information, you will at least find out what type of error is
being call that would then give you the prompt, for example a 401.1.

If you are using Windows Integrated, then some follow up questions I would
have would be:

Is the SQL Server Win2000 as well?

Are both machines in the same domain?

Is the user that is accessing the site a domain user and not a local user?
If the domain user is also a local user on the client machine. Delete the
local user.

You could run SQL Profiler to see how the user is comming in. This
determines if there is
any problem for authentication.

If the SQL Profiler does not get any hits , then use Netmon to trace the
trafic between SQLServer and IIS Server.
This should tell, what type of authentication is used.

Also make sure the SQL Server is also set up for integrated.

I hope this helps

Best Regards,

Jeff MacLeod, MCSD
Microsoft IIS Support Professional
This posting is provided "AS IS" with no warranties, and confers no rights.
 >> Stay informed about: Windows requires sign on 
Back to top
Login to vote
Display posts from previous:   
   Web Hosting Problem Solving Community! (Home) -> IIS All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]