473,387 Members | 1,534 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,387 software developers and data experts.

Two-hop issue

AGB
Hi all,

I have a two hop issue. I have two machines in the same domain--one
webserver and the other hosting SQL Server. I am using impersonation
and integrated windows authentication but for some reason the
connection is bailing to the database from the IIS machine. I can use
my localhost to connect to the remote database just fine.

There are tons of post to this issue but they don't seem pan out much
so I am curios if anyone has actually solved it. Here is the error:

Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection.

Again, I am using impersonation and my user account has a SQL Server
account with appropriate permissions.

Any help?

Nov 19 '05 #1
3 1114
1. Which OS's are you using on both boxes ?

2. Are you using "Trusted Connection =Yes" in your connection string ?

3. Set the SQL Server box to "Mixed Authentication", and try to connect.

4.
re:
I can use my localhost to connect to the remote database just fine.
Assuming that box is your test box, which account are you using
in it to connect to the SQL Server box. How are you authenticating
*that* account so that access is granted by the SQL Server box?


Juan T. Llibre
===========
"AGB" <ag*******@hotmail.com> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com... Hi all,

I have a two hop issue. I have two machines in the same domain--one
webserver and the other hosting SQL Server. I am using impersonation
and integrated windows authentication but for some reason the
connection is bailing to the database from the IIS machine. I can use
my localhost to connect to the remote database just fine.

There are tons of post to this issue but they don't seem pan out much
so I am curios if anyone has actually solved it. Here is the error:

Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection.

Again, I am using impersonation and my user account has a SQL Server
account with appropriate permissions.

Any help?

Nov 19 '05 #2
One way I've solved the issue is with Kerberos delegation:
http://support.microsoft.com/default...b;en-us;810572

--
Scott
http://www.OdeToCode.com/blogs/scott/
On 17 Dec 2004 20:25:46 -0800, "AGB" <ag*******@hotmail.com> wrote:
Hi all,

I have a two hop issue. I have two machines in the same domain--one
webserver and the other hosting SQL Server. I am using impersonation
and integrated windows authentication but for some reason the
connection is bailing to the database from the IIS machine. I can use
my localhost to connect to the remote database just fine.

There are tons of post to this issue but they don't seem pan out much
so I am curios if anyone has actually solved it. Here is the error:

Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection.

Again, I am using impersonation and my user account has a SQL Server
account with appropriate permissions.

Any help?


Nov 19 '05 #3
AGB
> 1. Which OS's are you using on both boxes ?

Windows 2003
2. Are you using "Trusted Connection =Yes" in your connection string ?

Yes
3. Set the SQL Server box to "Mixed Authentication", and try to connect.

Assuming that box is your test box, which account are you using
in it to connect to the SQL Server box. How are you authenticating
*that* account so that access is granted by the SQL Server box?


I am using my NT login and I do have an account in SQL Server. It just
looks like my account doesn't propogate all the way to NT. Something
on the Webserver is dropping my credentials and SQL Server is using a
NULL session.

Nov 19 '05 #4

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

Similar topics

0
by: SimonC | last post by:
I'm looking to do something similar to a feature found on Ticketmaster.com, where you select your seats at a venue, and then you have two minutes in which to take or leave them. QUESTION 1a....
8
by: John Grenier | last post by:
Hi, I have to determine the "standing" (WIN - TIE - LOSS) from confrontations between two teams on a contest. The table matchResults has fields cont_id, team_id and contest_result (int). ...
6
by: Willem | last post by:
Hi, I have a newbie question: is it possible to make a search form in asp that searches in two different databases (access)? Willem
10
by: Hank1234 | last post by:
Can I use one Data Adapter and one Command Builder to update amny tables? Currently in my data adapter I query two tables and fill them into two tables in a data set. When I make a change to a...
6
by: Matt K. | last post by:
Hi there, I have a form in an Access project that contains a subform which displays the results of a query of the style "select * from where = #a certain date#". In the main part of the form...
7
by: Prabhudhas Peter | last post by:
I have two object instances of a same class... and i assigned values in both object instances (or the values can be taken from databse and assigned to the members of the objects)... Now i want to...
0
by: clintonG | last post by:
I applied aspnet_regsql to SQL2K which was working fine throughout Beta 2 development. After installing Visual Studio and SQL Express RTM my application has blown up. Logging in to the application...
9
by: Steven | last post by:
Hello, I have a question about strcmp(). I have four words, who need to be compared if it were two strings. I tried adding the comparison values like '(strcmp(w1, w2) + strcmp(w3, w4))', where...
9
by: dhable | last post by:
I just started working with Python and ran into an annoyance. Is there a way to avoid having to use the "from xxx import yyy" syntax from files in the same directory? I'm sure it's been asked a...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
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: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
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:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
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,...

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.