I've two copy af the same asp.net application. The application enter on sql
server, working with two separate databases (on the same sql server
instance, of course). The connection is made with integrated security, and
the server is a domain controller.
If I start only the first application (call the web site), all right.
If I start only the second application, all right.
If I start an application, and then call a page from the second, my second
application cannot enter the database. If I kill aspnet process, the recall
the same page, this second application works fine, but I have the previuos
error if now I try to enter the first application!
This is a very strange problem!
What can I do?
3  1705 
Try without integrated security and see if it still messes up. If so, it is
likely to be a security issue. The best method to go from there is to do two
things.
1. On SQL Server, turn on profiler and see the user that is hitting the
database when it fails.
2. In ASP.NET trace out (or write out if you do not use trace) the user it
thinks it is running under
If you find that the user is IUSR, you have your problem child identified.
Once you figure this out, you have a better means to determine where to go
next.
With apps that use forms auth, you can set the cookie name and allow users
hitting the same server (same domain?) to log in once and hit all apps. This
is more FYI, as it will not solve your problem directly.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
*************** *************** *************** *************** **********
Think Outside the Box!
*************** *************** *************** *************** **********
"Trapulo" <no**********@q ui.it> wrote in message
news:ev******** ******@TK2MSFTN GP10.phx.gbl... I've two copy af the same asp.net application. The application enter on
sql server, working with two separate databases (on the same sql server
instance, of course). The connection is made with integrated security, and
the server is a domain controller.
If I start only the first application (call the web site), all right.
If I start only the second application, all right.
If I start an application, and then call a page from the second, my second
application cannot enter the database. If I kill aspnet process, the
recall the same page, this second application works fine, but I have the previuos
error if now I try to enter the first application!
This is a very strange problem!
What can I do?
"Cowboy (Gregory A. Beamer)" <No************ @comcast.netNoS pamM> wrote in
message news:eA******** ******@TK2MSFTN GP09.phx.gbl... Try without integrated security and see if it still messes up. If so, it
is likely to be a security issue.
Yes, is the same
The best method to go from there is to do two things.
1. On SQL Server, turn on profiler and see the user that is hitting the
database when it fails.
When it fails, I get a "login" and a "logout". No other operation.
2. In ASP.NET trace out (or write out if you do not use trace) the user it
thinks it is running under
If you find that the user is IUSR, you have your problem child identified.
Once you figure this out, you have a better means to determine where to go
next.
With apps that use forms auth, you can set the cookie name and allow users
hitting the same server (same domain?) to log in once and hit all apps.
This is more FYI, as it will not solve your problem directly.
I don't understand your note very well. My application uses form auth, and
the application run as IWAM (it is on a domain controller, so aspnet 1.1
runs as IWAM). The IWAM user has right permission on sql server (so SSPI can
work).
The two applications have different cookie name for forms auth (but I think
this isn't a problem anywhere... my app doesnt' enter in sql as IWAM when
try to autenticate the user).
thanks
"Jacob Yang [MSFT]" <ji***@online.m icrosoft.com> wrote in message
news:VF******** ******@cpmsftng xa06.phx.gbl... Hi Trapulo,
Thank you for using Microsoft MSDN managed newsgroup.
I noticed that you post the same question in the
microsoft.publi c.dotnet.framew ork.adonet group. Please check that thread
for this issue.
Ok, but we are not going ahead on that ng..
Regards This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: mdurliSPAMFILTER |
last post by:
Hello,
I developed a win32 .exe CGI that connects to a clustered SQLServer to
report some data.
The software is written with Borland C++Builder.
This is the oledb string:
Name=Provider=SQLOLEDB;Password=xxx;Persist Security Info=True;User
ID=xxxx;Data Source=xxxxx;Initial Catalog=xxxxx;Network
Library=dbmssocn
It suddendly stopped working on my customer network, so I made some
|
by: Wescotte |
last post by:
Here is a small sample program I wrote in PHP to help illustrates
problem I'm having. The data base is using DB2 V5R3M0. The client is
WinXP machine using the iSeries Client Access Driver ver 10.00.04.00 to
connect to the database.
The problem is that executing the exact same SQL select statement more
than twice int a row stops produces results. The first two instances
will always produce the correct results but after that it will simply...
|
by: Trapulo |
last post by:
I've two copy af the same asp.net application. The application enter on sql
server, working with two separate databases (on the same sql server
instance, of course). The connection is made with integrated security, and
the server is a domain controller.
If I start only the first application (call the web site), all right.
If I start only the second application, all right.
If I start an application, and then call a page from the second,...
|
by: Buddy Ackerman |
last post by:
I have a web app that I have setup on numerous web servers. I've set one up for a new client at their hosting facility
and cannot get it to connect to their database. I get a "SQL Server does not exist or access denied." error. Well, the
strangeness is that I have a SQL Query tool installed on this server and can connect to the database fine using the
exact same connection parameters that I have specified in my web app. Even more strange...
|
by: ivb |
last post by:
Hi all,
I am using DB2 8.1.11.1 on NT with ASP.NET 1.1
When application make connection to database (via ADO.NET), it set
"Connection timeout" parameter to 30 seconds.
After, when my webpage requests database, and query execution time
exceeds 30 seconds, the following error reported:
===
| | |
by: John |
last post by:
I can't get my head around this!
I have the following code:
<%
.... Code for connection to the database ...
.... Code for retrieving recordset ...
If Not rs.EOF Then
... Do something...
|
by: peter |
last post by:
Hi,
I have very strange situation but first description ;)
I have:
1) project in VB.NET, in this f.e. 1 function:
Public Function Login(ByVal UserName As String, ByVal UserPassword As
String, Optional ByVal ConnectionParamList As String = Nothing) As
String
|
by: dan |
last post by:
within a loop i am building a sql insert statement to run against my
(programatically created) mdb. it works but it seems unreasonably SLOW!
Sorry, dont have the code here but the jist is very standard (I
think!);
e.g:
# get connection
loop
|
by: Prisoner at War |
last post by:
Friends, your opinions and advice, please:
I have a very simple JavaScript image-swap which works on my end but
when uploaded to my host at http://buildit.sitesell.com/sunnyside.html
does not work.
To rule out all possible factors, I made up a dummy page for an
index.html to upload, along the lines of <html><head><title></title></
head><body></body></html>.; the image-swap itself is your basic <img
src="blah.png"...
|
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...
|
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,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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...
|
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();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
