Accessing Remote Win 2003 Index Server from XP/SQL Server

From: Brandon (Brandon_at_discussions.microsoft.com)
Date: 07/22/04 

Date: Thu, 22 Jul 2004 12:50:04 -0700

I have IIS running on a Windows 2003 Server (comp1) and SQL Server Running on an XP machine (comp2).

I'm trying to access the index server on comp1 from comp2, using the well known servername.indexname..Scope() technique within my SQL statement. I do have the running index set up on comp1 and the "dummy" linked server set up on comp2. I actually had this all working for a bit... Then it stopped working, and I'm not sure what I changed.

I now get the oh-so-helpful error message: [Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned message: Unspecified error]

I *suspect* it has something to do with security. Here is what I've done in the name of security.
1. On comp1 (2003/IIS), I set up a trust to/from comp2 (XP/SQL Server). I don't know how to set up a reciprocal trust on comp2 -- Is that possible on XP?
2. Made comp2 a member of the comp1 domain.
3. Tried to set the log on account for SQL Server to an account on comp1 (the domain controller), but kept getting a user/password not found error. It wouldn't let me browse the comp1 users, by the way.

Anybody have any thoughts? I've been beating my head on this for days. This is a tough one! I thank you VERY MUCH in advance...

Brandon

Relevant Pages

  • Re: 3 NIC computer
    ... >seems to keep droping my connection every now and then. ... Comp1 needs routing enabled ... Comp2 may need routing enabled if you wish to forward from one ethernet ... connected interface to subnet 2 is the preferred interface. ...
    (comp.os.linux.networking)
  • Re: Calling cocreateinstance from an impersonated thread
    ... I have two inproc com components say Comp1, Comp2 ... My client is an executable running in SYSTEM context ...
    (microsoft.public.vc.atl)
  • System Error 5 ... Access Denied
    ... both running Windows XP Pro w/ Firewall on. ... Comp1 and Comp2 seem to be set up the same. ... All "Local Security Settings" ...
    (microsoft.public.windowsxp.network_web)
  • Re: syntax of ssh wrapper for X Windows command
    ... command line user and the connection is encrypted. ... allows logging into a comp2 Xwindows from comp1. ... You are saying it isn't possible to ssh wrap the command ...
    (comp.security.ssh)