microsoft newsgroup web access
     dot net    |    ms sql    |    ms access    |    office    |    windows    |   
Microsoft ms sql group
sqlserver.ce
sqlserver.clients
sqlserver.clustering
sqlserver.connect
sqlserver.datawarehouse
sqlserver.dts
sqlserver.fulltext
sqlserver.msde
sqlserver.mseq
sqlserver.notificationsvcs
sqlserver.odbc
sqlserver.olap
sqlserver.programming
sqlserver.replication
sqlserver.reportingsvcs
sqlserver.security
sqlserver.server
sqlserver.setup
sqlserver.tools
sqlserver.xml
  
    

2 servers



in our lan we have 2 sql 2000 servers ( "A" & "B") I'm trying to retrieve
data from sql "A", while log in on a session of sql server "B" .

I use the "sp_addserver" to add the procedure and I got this message:
Server 'server_B' is not configured for DATA ACCESS.

any help would be most appreciate.
220 500647 <939A3AB5-6FC7-4613-8293-1379A246CB31@microsoft.com>
Thread-Topic: 2 servers
thread-index: AcT6b5VHF5gzncluQ+Kz+UN4/0nHFQ==
X-WBNR-Posting-Host: 201.140.139.161
From: "=?Utf-8?B?Y2VzYXJpdG9fbQ==?="
Fri, 14 Jan 2005 11:31:02 -0800 "=?Utf-8?B?Y2VzYXJpdG9fbQ==?="


COPYRIGHT © 2004, EUROFRONT WORLDWIDE LTD., ALL RIGHT RESERVE
http://www.meetholland.com

advertisement:   complete list of microsoft newsgroup    |    uk based newsgroup    |