Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 double hop issue openrowset

Author  Topic 

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2010-06-25 : 13:09:53
Greetings

We have three servers/

1. web server IIS
2. SQL Box 2008 1
3. SQL Box 2008 2

Web front has it's database backend on 2. SQL Box 2008 1. When trying to get some data from SQL Box 2008 2 via openrowset with a stored procedure on SQL Box 2008 1, it says ANONYMOUS\LOGON error. Any article you can point me to to resolve this security double hop issue?

Thanks

<><><><><><><><><><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion

Sachin.Nand

2937 Posts

Posted - 2010-06-25 : 13:32:39
I found this one.

http://blogs.technet.com/b/taraj/archive/2009/01/29/checklist-for-double-hop-issues-iis-and-sql-server.aspx


Limitations live only in our minds. But if we use our imaginations, our possibilities become limitless.

PBUH
Go to Top of Page

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2010-06-25 : 14:12:49
awesome stuff thank you vey much Idera

<><><><><><><><><><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion
Go to Top of Page

Sachin.Nand

2937 Posts

Posted - 2010-06-26 : 07:34:58
quote:
Originally posted by yosiasz

awesome stuff thank you vey much Idera

<><><><><><><><><><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion



Welcome


Limitations live only in our minds. But if we use our imaginations, our possibilities become limitless.

PBUH
Go to Top of Page
   

- Advertisement -