I have an identical SQL database on two machines (my machine and a web
server) that links to a database on a third server (S3). When I execute
a stored procedure on my machine that accesses a database on S3, it
always runs without a problem. However, when I run the same stored
procedure on the webserver (via Query Analyzer on my machine, connected
to the webserver), the stored procedure runs without a problem for
about ten minutes, and then I suddenly receive the error "Login failed
for user '(null)'. Reason: Not associated with a trusted SQL Server
connection.". If I then connect remotely to the webserver via Remote
Desktop Connection and run the stored procedure there it works, and
then I can run it again on the webserver via Query Analyzer on my
machine, but the same problem will occur again after about ten minutes.
The only difference between my machine and the webserver is that the
webserver is running Windows Server 2003, whereas my machine runs
Windows XP. All settings in SQL on the two machines are identical, so I
would love to know if anyone has a possible solution to this seemingly
random problem.
Jul 23 '05
23  9212 
You are right Damien, in that my ID does get cached. The amount of time
for which it is remembered is actually only about two to three minutes
for some reason. Anyway, the team responsible for domain and network
management here are due to speak to me today, so hopefully I will be
able to let you know what happens. Thanks again to everyone who has
offered help in this matter. I always like to feel I have explored all
avenues before getting the techies involved here.
It has taken until now for my helpdesk people to enable delegation on
Active Directory, but having done so, the problem remains. If I enable
SQL authentication on the two servers, I can connect to Server 3 from
my machine via Server 2. The person on the helpdesk claims that it must
be a problem with the SQL configuration, but I cannot see how this can
be if SQL authentication works.
ce*******@ev1.n et wrote: It has taken until now for my helpdesk people to enable delegation on
Active Directory, but having done so, the problem remains. If I enable
SQL authentication on the two servers, I can connect to Server 3 from
my machine via Server 2. The person on the helpdesk claims that it must
be a problem with the SQL configuration, but I cannot see how this can
be if SQL authentication works.
Sorry, I've got nothing more to suggest, other than trying to find some
other program/service (completely unrelated to SQL Server) which will
have the same authorization/authentication needs. Bung it on both
servers and demonstrate that the "same problem" is caused.
Unfortunately, I'm quite tired at the moment and cannot think of
anything off the top of my head. Anyone else?
Damien
My frustration has now increased further, as I am able to successfully
connect to Server 2 via Server 3 from my machine using Windows
authentication, but I cannot connect to Server 3 via Server 2 from my
machine, which is the process that I really need to have working.
Everything is set up identically on the two servers (I have checked
everything). I read that having the two servers connected could cause a
problem, so I have now removed Server 2 as a linked server from Server
3, but this did not solve the problem. I am just intrigued as to why I
now get the error "SQL Server does not exist or access denied." rather
than the "Login failed for user '(null)'. Reason: Not associated with a
trusted SQL Server connection." error that I originally experienced.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: teddysnips |
last post by:
In the script below is the DDL to create some tables and a UDF.
What I'm interested in is the UDF at the end. Specifically, these few
lines:
--CLOSE OTRate
--DEALLOCATE OTRate
ELSE -- @NumRecords <= 0
If I uncommment CLOSE and DEALLOCATE and check the syntax I get a
|
by: rrober07 |
last post by:
Hello,
My Setup is I have a Web Server machine(Devweb01), Database SQL
Machine(Devsql01), a Client Machine(local machine) I have configured the
SQL machine as follows:
1) Added local Aspnet user account (with same password as aspnet user on IIS
(Devweb01))
2) edited local machine.config file <ProcessModel> Password attribute to
same password (both on IIS and SQL Machine)
3) SQL Server security is Sql Server and Windows
|
by: pvl |
last post by:
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.
|
by: PaulOak |
last post by:
Hi all,
I have the following problem:
1. web site (asp.net 2.0 C#).
2. WebPartZone, which contains one user control.
3. SQL Server 2000 running on dedicated DB server, hosting the aspnetdb
database. Configured with aspnet_regsql.exe tool
4. Using Impersonation
5. Web.config:
|
by: Ramtin |
last post by:
Hi; when I use sql server connection or ole connection for working with
database I receive the login failed for user 'any user that I work'.I've been
granted ASPNET user in sql.
| | |
by: Daniel Knöpfel |
last post by:
Hello
On our asp.net 2.0 website we impersonate every request to the identity of
the user logged in. This works this way:
1. user logs in, providing username, password
2. user is authenticated against an active directory and the windows
identity is retrieved (and stored in the session!!)
3. user is impersonated using the windows identity (thread is now
running under the identity of the user)
|
by: Anup Daware |
last post by:
Hi All,
I am facing this very weird issue, for every server request my control
is redirecting to the login page and again coming back to the actual
page from where the request was initiated when I set my custom
Remember be cookie on the login page. Following are the details:
1. Authentication mode is ‘Forms’
2. This issue is reproducible only in deployed applications, I found
this using my trace and remote debugging
3. This issue occurs...
|
by: =?Utf-8?B?QmlsbHkgWmhhbmc=?= |
last post by:
I want to limit the user only login the system one time at the same time.
I don't want him login the system two with the same user at the same time.
How to do this?
If i have a table to record if this user has logined, this user didn't
logout and just close IE, how do i set his recoed in the table logout?
Thanks,
-Billy
|
by: Brett |
last post by:
I have an ASP.NET 2.0 application that uses Forms Authentication. The
startup page contains just a login control, and the site works well on an
IIS 6 web server. I am now setting the site up on the production web
server, which runs Windows 2008 Server and IIS 7. The login page comes up,
but when I try to log in, I get the error, "Login failed for user '(null)'.
Reason: Not associated with a trusted SQL Server connection." For debugging...
|
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: 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: 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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
