I don't want use odbc and I want to manage with T-SQL. It seems strange:
before some time my example was workable. Since then I configure my servers
for remote access with commands
exec sp_configure 'remote access', 1
May it changes break data access tuning ?
Thank you, German, for you help ;-))
> For openrowset you must use odbc connection. Are you sure you do it
> In even of using Linked server you must point there destination in 5
> elements: Server_name.Database_Name.Owner_Name.Table_Name.
> > Server is already added to linked servers group. Using openrowset lead
> > same error.
> > > Try through remote server or add it in linked servers group.
> > > Or use openrowset. There inherit new high level odbc connection but
> > > small.
> > > In last edvise use somesing like this:
> > > select * from openrowset('MSDASQL', 'DSN=NAME', 'select * from Table')
> > > > Hi, all!
> > > > Here is my question: I need get data from remote sql server. For
> > example,
> > > > there are sql servers SQL1 an SQL2 with databases db1 and db2
> > accordingly.
> > > I
> > > > want get data from sql.db1 during connection to sql2.db2
> > > > Actions from SQL server book:
> > > > on sql1 execute: exec sp_serveroption 'sql1', 'data access', 'true'
> > > > Then on sql2 I may write: select * from sql1.db1.dbo.table1 or
> > > from
> > > > openquery(sql1, 'select * from sql1.db1.dbo.table1')
> > > > But I get error: Server 'sql1' is not configured for DATA ACCESS.
> > > > What else I need to do ?
> > > > Thanks.
> > > > Nata.