Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [linked-server]

Linked server allows operation to multiple server as one query.

0
votes
0answers
11 views

Apache Ignite as linked Server in SQLServer?

I tried to set up a linked server via ODBC connection in SQLServer. It seem to connect but showed all the caches as empty names in SSMS. Also I couldnt get a select query to work. Has anybody had any ...
5
votes
1answer
82 views

TLS 1.2 breaks SQL Server linked servers

As part of a recent security blitz we set up TLS 1.2 on all of our servers. Last night I flipped the "Force Encryption" flag on all of our SQL Servers and since then I've had a weird issue with linked ...
0
votes
1answer
35 views

Is it possible to limit the scope of a SYNONYM in SQL Server?

I have a series of scheduled stored procedures that need to be run against different databases that have identical schemas (think multiple instances of an application). So for instance, every database ...
0
votes
0answers
17 views

Can an Amazon RDS SQL Server link to an RDS MySQL server?

Amazon RDS for SQL Server supports linked servers, but the doc page only describes linking to other SQL Servers. I would like to link to an RDS MySQL instance, but this normally involves installing ...
0
votes
0answers
12 views

Unable to select the table result in linked Server

As I have successfully created the Linked Server in SQL Server 2012 SP4 with MYSQL Server. Some of the small tables record able to fetch from the MySQL Server. And some of the big tables records when ...
1
vote
0answers
13 views

Multiple queries to linked server (Access db) block Sql server

On a SQL server 2012 I've created a linked server pointing to Access database: It all works fine, unless we have more than one query to this server - queries that are not even related to the same ...
0
votes
0answers
26 views

Linked Server Provider Options - Do I need to restart the SQL service (or server) after modifying any of these options?

Under Server Options -> Linked Server there are the Providers that each of my linked servers use. If I right click on a specific Provider and modify the Provider Options, such as "Dynamic parameter" ...
0
votes
1answer
25 views

Linked Server along Oracle 32 and 64 bit Oracle Client

As we all know that to connect from SQL Server to Oracle we need to Install Oracle Client at SQL End. But since I am stuck in one issue which has made me wondered about how things work behind the ...
2
votes
0answers
28 views

Query involving TVF very slow on SQL Server 2008

I have a query that runs in under 1 second on SQL Server 2014. A similar query takes over 12 minutes when run against a table on a linked server running SQL Server 2008. I don't know if it's because ...
1
vote
1answer
103 views

Availability groups and Linked Servers

I have inherited an Availability Group and have found that a linked server was set up between the two nodes of the availability group. It is using sa for authentication unfortunately. Simultaneously, ...
0
votes
0answers
36 views

What permissions do I need to provide to a non-sysadmin account to access OLE DB Providers?

I have a linked server that I am creating. EXEC master.dbo.sp_addlinkedserver @server = N'LINKEDSERVER', @srvproduct=N'', @provider=N'IhOLEDB.iHistorian', @datasrc=N'linkedservername', @provstr=N'...
0
votes
1answer
52 views

How do I allow non sysadmin accounts the ability to create/query linked servers in SQL Sever 2014?

I want to allow a non-admin account the ability to query a linked server. If I create a linked server with the following under a sysadmin account like below. EXEC master.dbo.sp_addlinkedserver @...
1
vote
0answers
36 views

View with OPENQUERY won't build in SSDT project

I have an existing database that I'm trying to set up as a database project. I'm not able to get the following statement to build: CREATE view [dbo].[VW_SOMEVIEW] as SELECT * FROM OPENQUERY ([...
1
vote
1answer
18 views

Is a @CATALOG argument required in linked server to connect to READ-ONLY secondary?

I have 1 primary and two secondaries. Node 3 is READ-ONLY. I created a linked server as follows (as described in Microsoft Docs): EXEC sp_addlinkedserver @server=N'Node3', @srvproduct=N'', @...
0
votes
1answer
85 views

Data Source connects but linked server cannot initialize data source object in MS SQL Server

I'm trying to create a linked server to an instance of MySQL. I've created a System DSN to the instance and that passes the connection test, but when I try to create a linked server using that data ...
1
vote
0answers
92 views

Linked Server transaction stopped by MSDTC

We've recently installed the newest Microsoft OLE DB Driver for SQL Server (msoledbsql) as it now supports multi-subnet failover capabilities (detailed here: - https://blogs.msdn.microsoft.com/...
2
votes
1answer
158 views

Could not complete cursor operation because the table schema changed after the cursor was declared

I get this error message occasionally when I execute a stored procedure that pulls information from multiple linked servers and aggregates the data. It looks similar to what I have below. DECLARE Cur ...
1
vote
0answers
59 views

Linked server from SQL server on AWS RDS to On premises Oracle database

We are planning to migrate an on-premises Microsoft SQL server database to AWS RDS SQL server. Everything is good except one roadblock, i.e this SQL server database has a linked server to on premises ...
1
vote
2answers
47 views

Running remote stored procedure with DDL locally

Sorry if my question is redundant, I searched Stack Exchange and the internet for hours but do not have a definitive answer to my question. Database: SQL Server 2017 + Azure The goal is to build a ...
3
votes
1answer
225 views

SQL Server 2016 Linked Server OPENQUERY Hangs

I've been trying to figure out this linked server problem for about a week now with no luck. The set up I have is a linked server from an instance of SQL SERVER 2016 to an instance of SQL SERVER 2016 ...
0
votes
0answers
52 views

MSOLEDBSQL Provider Linked Server

I've added the MSOLEDBSQL provider to our SQL Server 2012 server to try and create a link server that can use MULITSUBNETFAILOVER=true. The problem is creating a query, even a simple select, fails ...
0
votes
0answers
106 views

Access to the remote server is denied because the current security context is not trusted

I'm encountering the error mentioned below: Access to the remote server is denied because the current security context is not trusted. I did notice previous posts but there is mentioned that this ...
0
votes
0answers
67 views

Way to link to Oracle DB from SQL Azure DB

We currently get data from our Oracle DB by creating it as a linked server from our on-premise SQL server database. We are considering moving to the Azure SQL and would still require data from on -...
1
vote
1answer
31 views

Total_worker_time over SQL 2008 linked server

I’ve come across a lengthy SP that is being recorded as generating a high amount of total_worker_time in sys.dm_exec_procedure_stats. (But I think it might be a red-herring) The SP contains cursors ...
0
votes
0answers
38 views

SQL Server Linked Server for ODBC

I have a linked server connected via ServiceNow ODBC connection. When I run a open query as shown below: select * from OPENQUERY(ServiceNow,'select * from incedents') I get the following error: In ...
2
votes
0answers
181 views

Very Sporadic Cannot initialize the data source object of OLE DB provider “SQLNCLI11” for linked server

OLE DB provider "SQLNCLI11" for linked server "001" returned message "Unable to complete login process due to delay in opening server connection". Msg 7303, Level 16, State 1, Line 19 Cannot ...
1
vote
2answers
159 views

Unable to update MySQL table from linked server on SQL Server 2014

I'm using SQL Server 2014, with a linked server to a MySQL database on AWS. I need to update rows on that linked server, using data that exists on another linked server. And if that wasn't complicated ...
0
votes
1answer
39 views

Creating logins mapping for a linked server without creating logins for AD users

We use windows auth, but we don't create logins for particular AD users. We create logins for AD groups and the users have access by being their members. I noticed that when I try to create a mapping ...
2
votes
0answers
120 views

why is update from a join containing zero records taking a minute and 20 seconds?

SQL Server 2008R2. I have a simple join that returns zero rows in less than a second. When I try to run an update on that join, it should also take less than a second but it is taking one minute and ...
0
votes
0answers
49 views

Make the linked server ask for password

Till today i am using the linked server with the user of sql having same username and password in both the servers. For now on i can not keep the 2 servers password same for some reason and i still ...
0
votes
1answer
27 views

Can a contained database SQL User be mapped to a remote user in a linked server?

Using SQL Server 2017 Standard CU8 on Windows Server 2016. I've create a contained database user (user defined only within a database with Containment type: partial) with type SQL user with password (...
1
vote
1answer
32 views

ORA 01861 error

I am reading a date from a linked serve and it returns the field in the datetime2 format. Here is my simplified query: select * from openquery(LinkedServer, 'select QCTL.INVC_HEADER.POST_DATE ...
2
votes
2answers
253 views
-1
votes
1answer
202 views

Oracle Linked Server in Azure SQL Database Managed Instance

I am migrating my On Premise SQL Server to Azure SQL Database Managed Instance. But I have linked server to Oracle database in my SQL Server. Can we create linked server to an On Premise Oracle ...
0
votes
0answers
119 views

Stored procedure runs fine manually but not as SQL agent job

I have a stored procedure that performs some data imports from a linked server. The linked server is on the same box as the main instance, it's just a different instance. The stored procedure runs ...
0
votes
0answers
129 views

LDAP linked server in SQL Server: what connectivity is required?

In an instance of SQL Server I have created a Linked Server for LDAP queries. EXEC master.dbo.sp_addlinkedserver @server = N'LDAP', @srvproduct=N'Active Directory Service Interfaces', @provider=N'...
2
votes
1answer
127 views

How do I encrypt data to be decrypted on a linked server? SQL

I have been searching for 2 days for the solution to this, but every solution does not apply to my situation. I have 2 SQL servers: DataServer and InterfaceServer set up as linked servers. DataServer ...
3
votes
1answer
530 views

Check if table exists on a linked server

I've had a search, but can't find a post relating to this instance specifically. We have a linked production database that I'm trying to reference from our 'sandbox' server. I want to check if a ...
1
vote
0answers
97 views

Secondary Replica Read-Only Routing via Linked Server working from one server, but not the other

I have been given the task of setting up a read-only linked server on ServerA to Availability Group listener ListnerX. ListnerX points to ServerY or ServerZ (ServerY is usually the primary). Read-only ...
0
votes
0answers
67 views

Linked server Informix driver mismatch error on driver and applciation

I tried to read all the questions here that has been asked before, but could not find any clue on my problem. I'm trying to setup a linked server to connect on INFORMIX server, I installed the driver,...
0
votes
0answers
145 views

SQL 2014 Linked Server Login Timeout

I'm having an issue where an application (MS Nav 2015) invoked query (Select) on occasion is receiving a login timeout. This issue happen sporadically, and the query itself is run at 15 minute ...
0
votes
0answers
23 views

linked server issue while synchronising logins between servers using T-SQL

I have been working on a solution to synchronise logins (using T-SQL) between 2 servers, or between AlwaysOn nodes, inspired by sqlsoldier. It requires a linked Server. this is a partial view of the ...
2
votes
1answer
98 views

Problem with data insertion in Oracle table from SQL Server table

We have SQL server and Oracle server, and have configured a linked server from SQL Server to Oracle. I'm trying to insert 10,000 rows from SQL Server into a table in Oracle. When I insert 100,000 ...
0
votes
0answers
141 views

Linked Server from SQL Server on Azure VM to On-premise Oracle Database

How to create a Linked Server from my SQL Server on Azure VM IaaS to an Oracle Database which is present on On-premise? Is it the same process as we create on on-premise SQL Server or what extra ...
0
votes
0answers
41 views

How to insert/update/delete data between a hosted database and a local database

How to Replicate data between a hosted database and a local database Following up to @Daniel Hutmacher response what would be the best answer using the T-SQL recommendation using the @lastUpdated ...
0
votes
1answer
369 views

Replication/Mirroring/etc from Azure SQL Database to On-premise SQL Server possible?

I have a table on Azure SQL Database that I would like to have replicated/mirrored to our on-premise SQL Server So the on-prem SQL Server would have a copy of table from Azure that is always up-to-...
1
vote
2answers
120 views

Azure SQL Db Linked Server - Secured Connection Methods?

The developers want a linked server from our on-prem server to our Azure SQL Db (DBaaS) in order to complete a nightly data pull into our data warehouse. I'd much rather go the route of SSIS but don'...
0
votes
0answers
115 views

Linked Server with Failover - One works then other doesnt both to the same server

So as the title states, I have 2 linked servers on server A both pointing to the same server/failover and after failing over one works and one doesn't. Server with the Linked Servers:A Linked ...
0
votes
2answers
632 views

Joining table from Linked Server is very slow

I have a production SQL server and a linked server (Azure SQL Database) I join two tables to do update Table A - small table A in TempDB that has only 100 rows on SQL Server Table B - on linked ...
1
vote
0answers
35 views

Decoding timestamp number in “change in schema version between compile time and run time”

I am trying to track down a "who/why" for the error <...> reported a change in schema version between compile time ("185302088475260") and run time ("185448117384521") for table <...> I ...