Re: Accessing remote Index Server from XP
From: Hilary Cotter (hilaryk_at_att.net)
Date: 07/22/04
- Next message: Brandon: "Accessing Remote Win 2003 Index Server from XP/SQL Server"
- Previous message: Brandon: "Accessing remote Index Server from XP"
- In reply to: Brandon: "Accessing remote Index Server from XP"
- Next in thread: Brandon: "Re: Accessing remote Index Server from XP"
- Reply: Brandon: "Re: Accessing remote Index Server from XP"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 22 Jul 2004 15:30:10 -0400
what happens when you change the scope to \
ie
select From from openquery(web,'select path from
remoteservername.remotecatalogname..scope(''\'')')
-- Hilary Cotter Looking for a book on SQL Server replication? http://www.nwsu.com/0974973602.html "Brandon" <Brandon@discussions.microsoft.com> wrote in message news:F78FD457-1968-4082-AF87-01D26B302FC7@microsoft.com... > I have SQL Server 2000 running on Windows XP, and want to access the index server on a Windows 2003 server. > > I use the well known servername.indexname..Scope() to access the remote IS. This actually worked for me for a bit. I'm not sure what happened, but it stopped working and I can't get it to work again. (I receive the oh-so-helpful error: [Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned message: Unspecified error]) > > I *suspect* it has something to do with security. This is what I've done in the name of security: > 1. On Win 2003 Server Machine: Set up trust for XP/SQL Server machine. > 2. Made the XP/SQL Server machine a member of the 2003 Server's domain. > 3. *Tried* to change the SQL Server log on account to an account belonging to the 2003 Server machine, but XP keeps telling me that it doesn't recognize the login username/password. Can I not do this in XP? > > I've been banging my head on this problem for days now. It's a tough one. I hope somoene out there can help. > > Thanks to all! > > Brandon
- Next message: Brandon: "Accessing Remote Win 2003 Index Server from XP/SQL Server"
- Previous message: Brandon: "Accessing remote Index Server from XP"
- In reply to: Brandon: "Accessing remote Index Server from XP"
- Next in thread: Brandon: "Re: Accessing remote Index Server from XP"
- Reply: Brandon: "Re: Accessing remote Index Server from XP"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
