Not associated with a trusted

[slatet]

I've researched this throughout tek tips. SQL Server is in mixed mode. I have turned anonymous off in IIS for both the website and the app pool. I am using integrated security
"integrated security=SSPI;data source=(Local);initial catalog=log;trusted_connection=true"

I had originally tried using a user name and password. So even though I have updated the code several times, it still tells me that the last user name does not have permission.

This is a webpart for Sharepoint, not that it makes a difference.

ANy help is appreciated.

 

[mrdenny]

The problem that you are having is called the NTLM double hop issue.

Here is an MSKB that explains the problem you are having.

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

Here is some more info from Microsoft about the problem:

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

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[slatet]

Is it still considered a double hop if the webserver and the sql server are located on the same VM image?

 

[mrdenny]

Oh, my bad. I didn't notice that they were on the same machine. In that case, no it's not a double hop as they are the same machine.

Have you tried iisreset yet?

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com