Windows authentication issues with asp.net

Question

I have an asp.net application that needs to access data from two SQL servers. One of the SQL servers is present on the same computer as IIS (let's call it SQLSERVER1), while the other SQL server is present on the other computer (SQLSERVER2).

Connection strings are trusted for both SQL servers. In my web.config file, the value is true. I use Windows authentication in both IIS and web.config.

When I try to access data from SQLSERVER2, I get a login with an error for a user error (null). The user through whom I logged in through Windows exists as a SQL Server account in SQLSERVER2.

What could be the reason?

NOTE: This is a newbie question from IMHO .

NOTE. IIS is using 6.0 (Windows 2003). It is not configured for IIS 5.0 isolation mode.

EDIT: the user who received the issued is a domain user

Addition:

I also want to declare that I get this error message when I refer to it as a client of the server running IIS. In other words, let me say that I'm working on machine A, IIS and SQLSERVER1 are on machine B, and SQLSERVER2 is on machine C.

I do not get this error message when I work on machine B. It throws me more.

Answer 1

. , , Kereberos. NTLM . Kerberos vs. NTLM.

, - , , - ( ) . - . , -, " ", . , ...

Microsoft . , , ​​ this, , . , , , , , ( ), .

Answer 2

, , Kerberos (NTLM) (-). , , Kerberos.

: http://support.microsoft.com/kb/810572

Answer 3

- sql. - SQL Server, , .

Answer 4

, SQLSERVER1 . SQLSERVER2 , SQLSERVER1. , Kerberos . , .

BTW, , , , ?

Answer 5

Did you try to access the database on server2 using the SQL SErver administrator with Server1 and made a successful connection?

If not, this may be because SQL Server installs itself with tcp disabled by default by default.

You will need to make sure that this is enabled for server2 so that server 1 can connect. server1 has no connection problems due to the fact that it can use the connection with shared memory.