473,396 Members | 2,154 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

very strange problem with connection

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?

Nov 17 '05 #1
3 1684
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**********@qui.it> wrote in message
news:ev**************@TK2MSFTNGP10.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?

Nov 17 '05 #2

"Cowboy (Gregory A. Beamer)" <No************@comcast.netNoSpamM> wrote in
message news:eA**************@TK2MSFTNGP09.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

Nov 17 '05 #3

"Jacob Yang [MSFT]" <ji***@online.microsoft.com> wrote in message
news:VF**************@cpmsftngxa06.phx.gbl...
Hi Trapulo,

Thank you for using Microsoft MSDN managed newsgroup.

I noticed that you post the same question in the
microsoft.public.dotnet.framework.adonet group. Please check that thread
for this issue.


Ok, but we are not going ahead on that ng..

Regards
Nov 17 '05 #4

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

Similar topics

1
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:...
9
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...
3
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...
2
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...
0
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...
12
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...
2
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...
9
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...
112
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...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
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...
0
Oralloy
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,...
0
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...
0
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...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
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...

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.