We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [linked-server]

Linked server allows operation to multiple server as one query.

Filter by
Sorted by
Tagged with
0
votes
0answers
189 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 ...
1
vote
0answers
31 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
283 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
132 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
1answer
55 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
277 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
1answer
303 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
237 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
31 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
947 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
601 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
4k 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
554 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
329 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
1k 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 ...
1
vote
1answer
32 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 ...
3
votes
0answers
1k 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
546 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
80 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
128 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
113 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
94 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
120 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
600 views

When setting up security for linked servers, what does the Impersonate checkbox do?

Question: what does this checkbox do?
-1
votes
1answer
748 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 ...
2
votes
1answer
315 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
2k 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 ...
2
votes
0answers
265 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
164 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
530 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 ...
2
votes
1answer
107 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
1answer
827 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
296 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
2answers
2k 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
57 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 ...
0
votes
1answer
408 views

SQLCMD to connect to Linked server

I'm getting a login error with the below sqlcmd to connect to a linked server: SQLCMD -E -dlinkedserver -ig:\temp\script.sql -o g:\temp\test.txt My linked server which is an oracle connects through ...
1
vote
1answer
484 views

Cannot run a job to update table on a linked server

I am running SQL Server 2012 on a server (server 1) and have set up a job to run a stored procedure which will summarize data from a series of tables and update a table on a linked server (server 2) ...
1
vote
1answer
3k views

“SQLNCLI11” for linked server “linkedserver” returned message “The transaction manager has disabled its support for remote/network transactions.”

I have a database in a SQL Server 2014 AG group (AG1).- two nodes. On both nodes, a linked server is set up. I am selecting data from a table from AG group (AG1) database and inserting into a ...
0
votes
1answer
855 views

Linking SQL servers error

When i try to connect a linked server, i´ll get this error message : TITLE: Microsoft SQL Server Management Studio The linked server has been created but failed a connection test. Do you want to ...
4
votes
2answers
462 views

Error while copying data over linked server

I am trying to copy the contents of 1 table from one database to another over a linked server. I am using the following query to do so insert into [Schema].[Table] select * from [Server].[Database]...
0
votes
1answer
650 views

Linked Server - Double Hop - Kerberos - TCP

I am having trouble with a Linked Server. I would typically not use a linked server, but legacy issues are forcing my hand. I am attempting to set up a linked server between two new production SQL ...
0
votes
1answer
3k views

Linked server from MSSQL to Oracle Issue

Last week we began having an issue with a Linked Server to an Oracle database on one of our MSSQL Servers. If I use the linked server on the MSSQL server it works fine. However, if i try to use it ...
0
votes
1answer
1k views

SQL Server link to MySQL reports “using password: no”

I would like to access a MySQL database from within SQL Server. I created a system DSN, and it tests OK. I created a linked server in SQL Server: Provider = Microsoft OLE DB Provider for ODBC ...
1
vote
0answers
25 views

sp_start_job only running 20 times concurrently - can I adjust?

I have a procedure that has a loop that calls sp_start_job to run a query against multiple linked servers. Each run of the loop calls a job that queries a specific linked server. (An openquery that ...
1
vote
1answer
741 views

Linked SQL Server Issue

I have 3 servers all running Windows Server 2016 Datacenter: Server1 is a domain controller and has ssms installed for accessing SQL Server Instances on Server2 and Server3 Server2 & Server3 are ...
0
votes
1answer
609 views

Linked Server Insert Permission

Msg 229, Level 14, State 5, Line 1 The INSERT permission was denied on the object 'object_name', database 'database_2', schema 'dbo'. Above is the error. I have a linked server set up (set up in prod ...
1
vote
1answer
457 views

Direct vs Linked Server Connection in Query Execution Time

After investigating our ETL Process for months i fell into something strange. We have one machine (A) which we are using in order to pull data from other machines (B). When i make a SELECT Statement ...
0
votes
0answers
258 views

Same Domain Linked Server Login Failing

I have several SQL Server instances. All of them are setup in the same domain, and have been working for years. One of these instances serves as an aggregator for the data of the others, and a sync ...
1
vote
3answers
1k views

Delete and Insert performance SQL Server

I have the below stored procedure that is taking close to an hour to complete. The result set is about 200K machines. All I am doing is extracting a set of ids from a linked server, deleting those ...
1
vote
1answer
377 views

Source code of View of Linked server sp_HelpText

How to use sp_helptext for view on the linked server ?