Drop Table

Support Forum for database administrators and web based access to important newsgroups related to databases
Register on Database Support Forum Edit your profileCalendarFind other Database Support forum membersFrequently Asked QuestionsSearch this forum -> 
For Database admins: Free Database-related Magazines Now Free shipping to Texas


Post New Thread










Thread
Author

2005 Cluster linked server issue
We have a two node cluster with two SQL 2005 instances installed.  For the
most part things work.  This morning we had Instance1 on Node1 & Instance2 o
n
Node2.  When I created a linked server on Instance1 pointed at Instance2
(under the aforementioned node conditions) & set the security context to use
the current login's security context, it didn't do that.  Instead when linke
d
server commands were issued, it tried to connect to Instance2 using NT
AUTHORITY\ANONYMOUS LOGON.

When we put both Instance1 & Instance2 on Node1, everything works.  When we
put both Instance1 & Instance2 on Node2, everything works.  But when the
instances are on different nodes, the linked server stuff gets screwy.

Report this thread to moderator Post Follow-up to this message
Old Post
CB
03-29-06 04:23 PM


Re: 2005 Cluster linked server issue
Anyone have any ideas?  Another thing I'll throw in is that I only get
the error when connecting to Instance1 from another machine (my
workstation, app server, etc.) & running a linked server query.  When I
connect to Instance1 locally on that box, the linked server query
performs fine.  It's almost as if when my windows credentials travel
from my workstation to Node1 and then to Node2, things get messed
up....


CB  wrote:
> We have a two node cluster with two SQL 2005 instances installed.  For the
> most part things work.  This morning we had Instance1 on Node1 & Instance2
 on
> Node2.  When I created a linked server on Instance1 pointed at Instance2
> (under the aforementioned node conditions) & set the security context to u
se
> the current login's security context, it didn't do that.  Instead when lin
ked
> server commands were issued, it tried to connect to Instance2 using NT
> AUTHORITY\ANONYMOUS LOGON.
>
> When we put both Instance1 & Instance2 on Node1, everything works.  When w
e
> put both Instance1 & Instance2 on Node2, everything works.  But when the
> instances are on different nodes, the linked server stuff gets screwy.


Report this thread to moderator Post Follow-up to this message
Old Post
CoreyB
03-31-06 02:23 PM


Sponsored Links





Last Thread Next Thread
Post New Thread

MS SQL Server archive

Show a Printable Version Email This Page to Someone! Receive updates to this thread
Microsoft SQL Server
Access database support
PostgreSQL Replication
SQL Server ODBC
FoxPro Support
PostgreSQL pgAdmin
SQL Server Clustering
MySQL ODBC
Web Applications with dBASE
SQL Server CE
MySQL++
Sybase Database Support
MS SQL Full Text Search
PostgreSQL Administration
SQL Anywhere support
DB2 UDB Database
Paradox Database Support
Filemaker Database
Berkley DB
SQL 2000/2000i database
ASE Database
Forum Jump:
All times are GMT. The time now is 08:22 PM.

 
Mobile devices forum | Database support forum archive




Copyrights DropTable.com Database Support Forum 2004 - 2006