by Mano Nom » Thu, 21 Mar 2002 18:48:12
Server 'server1' is not configured for DATA ACCESS.
HELP.. please.
I have checked the linked servers but, seems to be
everything fine...
thanks
by Dinesh T » Thu, 21 Mar 2002 22:20:56
Try
sp_serveroption 'SERVER_NAME', 'Data Access','TRUE'
Dinesh.
--
---
SQL Server FAQ at
www.tkdinesh.com
Quote:> Hi I have 5 sql servers in one network. Runing the
> services on domain accounts. I whant to execute querys
> from a local box to any of the servers just specifiying
> the server name in the query.( select * from
> server1.work.dbo.shoppers) when i wxecute the server o
> recieve the error:
> Server 'server1' is not configured for DATA ACCESS.
> HELP.. please.
> I have checked the linked servers but, seems to be
> everything fine...
> thanks
by William Chen [M » Sat, 23 Mar 2002 15:16:18
For more information, please refer to the "Configuring Linked Servers"
topic in SQL Server Books Online.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Thanks,
William Chen
1. SQL Server 7 Linked Server Help
Hi All,
I am just getting in to SQL 7 and i need to now the following:
1. Is it possible to link to an Informix database on a Unix box through the
linked servers option?
2. Can i set the link up to only allow read only connections to the linked
database?
What i need to do is to live link a number of tables to an SQL database for
real time querying purposes rather than bcp'ing the data accross as we do at
present in 6.5
Can anyone give me detailed answers to these questions please.
Thanks in advance
Please respond via email:
3. SQL Server 7 Linked Servers Help Please
4. Java BigDecimal mapping on DB2 Decimal
5. Linked Servers Help I am going crazy
6. Security problem: password of probe login is null and should be null.
8. alter table in Excel linked server-help!!!
10. Linked Server - Help please
11. Linked servers -- HELP!!!!!!!!!