473,857 Members | 1,748 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Intermittent SQL Server login problem

pvl
Hi

We have the following scenario:
1. SQL server 2000 on Windows 2003 Server
2. Web server 1, running web service 1 on Windows 2003 Server
3. Web server 2, running web service 2 on Windows 2000 Server
4. Client application.

1, 2 & 3 are all on the same Windows 2003 domain.

Client application connects to web service 2 from the internet.
Web service 2 uses impersonation in web.config to impersonate a domain
account. It then connects to web service 1, which in turns connects to
SQL server using a trusted connection.

Web service 1 only allows windows authentication.
All servers are trusted for delegation.

Now for the problem: The first call after an idle period of 20 - 30
minutes always fails with SQL server reporting that the login failed
for user null.

Web service 1 impersonates the HttpContext.Use r.Identity before every
call to SQL server.

This works every time after the first failure, but leave it for 20
minutes and it fails again.

I can see that the impersonation from web service 2 works correctly,
because I trace HttpContext.Ide ntity.Name as well as the currect thread
identity. These are always correct.

Any help will be appreciated
Thanks
Pierre-Andre

Nov 19 '05 #1
2 2073
Sounds like Session Timeout to me. Are you using Session or Application
State in either Web Service?

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
What You Seek Is What You Get.

"pvl" <pv*@gendac.co. za> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.com.. .
Hi

We have the following scenario:
1. SQL server 2000 on Windows 2003 Server
2. Web server 1, running web service 1 on Windows 2003 Server
3. Web server 2, running web service 2 on Windows 2000 Server
4. Client application.

1, 2 & 3 are all on the same Windows 2003 domain.

Client application connects to web service 2 from the internet.
Web service 2 uses impersonation in web.config to impersonate a domain
account. It then connects to web service 1, which in turns connects to
SQL server using a trusted connection.

Web service 1 only allows windows authentication.
All servers are trusted for delegation.

Now for the problem: The first call after an idle period of 20 - 30
minutes always fails with SQL server reporting that the login failed
for user null.

Web service 1 impersonates the HttpContext.Use r.Identity before every
call to SQL server.

This works every time after the first failure, but leave it for 20
minutes and it fails again.

I can see that the impersonation from web service 2 works correctly,
because I trace HttpContext.Ide ntity.Name as well as the currect thread
identity. These are always correct.

Any help will be appreciated
Thanks
Pierre-Andre

Nov 19 '05 #2
We're not using any session state in the web services.
I've also been playing round with the settings on the application pools to
see if it has anything to do with that, but it doesn't seem so.

"Kevin Spencer" <ke***@DIESPAMM ERSDIEtakempis. com> wrote in message
news:ek******** ******@TK2MSFTN GP10.phx.gbl...
Sounds like Session Timeout to me. Are you using Session or Application
State in either Web Service?

--
HTH,

Kevin Spencer
Microsoft MVP
.Net Developer
What You Seek Is What You Get.

"pvl" <pv*@gendac.co. za> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.com.. .
Hi

We have the following scenario:
1. SQL server 2000 on Windows 2003 Server
2. Web server 1, running web service 1 on Windows 2003 Server
3. Web server 2, running web service 2 on Windows 2000 Server
4. Client application.

1, 2 & 3 are all on the same Windows 2003 domain.

Client application connects to web service 2 from the internet.
Web service 2 uses impersonation in web.config to impersonate a domain
account. It then connects to web service 1, which in turns connects to
SQL server using a trusted connection.

Web service 1 only allows windows authentication.
All servers are trusted for delegation.

Now for the problem: The first call after an idle period of 20 - 30
minutes always fails with SQL server reporting that the login failed
for user null.

Web service 1 impersonates the HttpContext.Use r.Identity before every
call to SQL server.

This works every time after the first failure, but leave it for 20
minutes and it fails again.

I can see that the impersonation from web service 2 works correctly,
because I trace HttpContext.Ide ntity.Name as well as the currect thread
identity. These are always correct.

Any help will be appreciated
Thanks
Pierre-Andre


Nov 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2157
by: Anthony | last post by:
I have a php app that is in the final stages of testing and has been tested by over 30 separate users. One of the testers is having an intermittent problem which seems to be caused by a session variable not being read properly in about 1 in 3 requests even though the variable is getting set correctly in the session temp file. It only happens after a form has been submitted (using POST or GET doesn't seem to make a difference). This...
10
5295
by: Dan | last post by:
We have a fairly large set of ASP.NET applications running on Windows 2003 SP1 server. The entire suite of software was originally written in ASP and ran on a Win 2k server. For about the last year, we have been working toward converting everything to .NET and we are close to have it all done. In the mean time, we still have a few portions of the software running in classic ASP. Here is the problem. The ASP pages have been pretty reliable...
0
292
by: deevoy | last post by:
Hi- I'm developing a asp.net web application and everything has proven fine on the dev and acceptance environment. We've moved the code up to our windows server 2003 prod environment and get the following intermittent error when browsing the web page through a client browser (the action causing this is paging though a datagrid- although it randomly errors, rather than erroring all the time): ________________ Invalid character in a...
8
5055
by: trinitypete | last post by:
Hi all I have a strange problem with IIS windows pass through authentication. Heres the setup IIS running with Windows Authentication for our intranet site. ACL has been set to everyone for all web directories. This is all on a windows 2003 server. We add the intranet site to the intranet zone so the windows credentials will automatically get passed to IIS 90% of the time it works fine, but Intermittently we get access forbidden -...
2
1871
by: Mike Krajewski | last post by:
We are having an intermittent problem using an ExecuteScalar command on a asp.NET page accessing SQL Server. 2 characters of the sql statement get intermittently altered. The code looks as follows: SqlCommand command = new SqlCommand("SELECT fkOWSStatusID FROM vwUsersCleanups WHERE pkCleanupID = 123", connection); object nReturn = command.ExecuteScalar(); About 10% of the time, the 'rs' in vwUsersCleanups get altered into...
3
2046
by: Lee Chapman | last post by:
Hi, I have a problem where my ASP.NET application occasionally generates a MissingFieldException exception. This unexpectedly happened on my development box, and so I was able to extract some information from the debugger: The field that is "missing" is called 'logger'. Here's it's description taken from ildasm.exe: ..field public static class log4net.ILog logger
1
1232
by: deevoy | last post by:
Hi- I'm developing a asp.net web application and everything has proven fine on the dev and acceptance environment. We've moved the code up to our windows server 2003 prod environment and get the following intermittent error when browsing the web page through a client browser (the action causing this is paging though a datagrid- although it randomly errors, rather than erroring all the time):
0
1228
by: Shane C | last post by:
Intermittent Error: Server was unable to process request  Object reference not set to an instance of an object I have windows application that references a XML web service on our web server. The application sends and receives information fine most of the time. We do, mostly during peak usage hours, receive the above mentioned error. 1. What would cause the intermittent nature? 2. What can be done to fix this problem?
3
1726
by: Velvet | last post by:
I'm having an intermittent problem with IE 6.0.2900.2180.xpsp_sp2_gdr.050301-1519 installed on Windows XP. The images, style sheets and JavaScript files are not loading to the browser. Sometimes a refresh will fix the page, sometimes I have to delete the cache before it will load properly again, sometimes that doesn't help either. This only seems to happen with IE. Netscape and FireFox seem fine. I have only been testing this on one...
0
9923
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, weíll explore What is ONU, What Is Router, ONU & Routerís main usage, and What is the difference between ONU and Router. Letís take a closer look ! Part I. Meaning of...
0
9768
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10711
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10394
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7940
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Duprť who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7104
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5774
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5971
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
3
3215
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.