Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

Questions tagged [linked-server]

Linked server allows operation to multiple server as one query.

Filter by
Sorted by
Tagged with
0
votes
1answer
93 views

check linked servers database status

I want to find out if all SQL databases registered in the database XXX on the YYY instance are available on the respective linked server and if they are online or offline. I have the below Code, ...
1
vote
0answers
23 views

Check linked server database status registered in the DBConfig Database

I am working with the Code below to check all the entries in the DBConfig Database of all the databases linked to the instance Server- LSNR_ADMINDB DB _ DBConfig However when i run the Code, it ...
-1
votes
2answers
381 views

INSERT INTO SQL Server : Linked Server without specifying database in semi-fully qualified name

I have a server called DEV, a database called Nus12345, a linked server called SnapshotDev, a schema called Snapshot, and a table called SnapshotPersonEmployee. On the DEV server, there are many ...
1
vote
0answers
32 views

Linked server in Sql Server 2014 invalid path

I am trying to create a linked server to foxpro tables using vfpoledb, but it gives me the error of "Invalid path or file name" when trying to put as source \\xxx.xxx.x.x\same_names\abc (xxx.xxx.x.x ...
0
votes
0answers
26 views

Linked Server using Impersonation fails SSMS GUI Connection test but sp_testlinkedserver succeeds

I have a linked server (Server B) set up on Server A with permissions set as follows: This means that there are five Windows Logins (of which my windows account is one) who can access the linked ...
2
votes
0answers
43 views

Linked server from Azure managed instance

I have my Managed Instance (MI) setup and can connect from SSMS on-premises. There is limited functionality this way (you only see databases and security) - so I have a VM in the v-net where I can ...
0
votes
0answers
25 views

Error if iseries table name is not qualified within openquery

I have a linked server to an AS/400 using the IMBDASQL OLEDB provider. I am avoiding hard-coding library names so the linked server's connection string includes: Default Collection=;Naming Convention=...
0
votes
1answer
55 views

Executing a stored procedure inside another stored procedure from a linked server

I'm having a problem and I don't know how to solve it, I have searched the web and found good advice but I can't work it out. This is the problem: I have a SQL Server instance running on my PC, and I ...
4
votes
1answer
321 views

Stuck with self-referencing linked server - will replacing the primary server name be better?

A vendor app uses 4-part names to reference objects. I am pushing back on that, but the current version is what it is. We installed the app using a SQL Alias for all the good reasons you do that, ...
1
vote
1answer
485 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) ...
0
votes
1answer
233 views

MySQL out of Memory, but Only Through MSSQL Linked Server

I am getting an error "MySQL client ran out of memory" when trying to do some simple MySQL selects or inserts from Microsoft SQL through a linked server. It was working fine for a week or so, and for ...
1
vote
1answer
279 views

Best way to transfer a few tables from reserve server to production

We have two MS SQL Servers (2012 Standard Edition on Windows 2012 Server) which are located in the same subnet. One is production server. Another is reserve server. Currently there is a ...
1
vote
1answer
78 views

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

We are planing to migrate an on-premises SQL Server db to AWS RDS SQL Server. My only concern is how can I create a linked server from AWS RDS SQL Server to on-premises SQL Server db? Is it possible? ...
1
vote
1answer
344 views

Using linked server from Windows 10 PC [closed]

I have been using SQL Server linked servers for years, and they have been working fine. But now when I try to run a query (on a machine with Windows 10) using linked server I get this error: Login ...
3
votes
1answer
298 views

OLAP linked server fails connection test

I am trying to create a new linked server to an Analysis Services database and I would like to use this linked server to import data into a SQL Server table. example: SELECT * into raw.example ...
2
votes
2answers
901 views

configure new linked server from SQL Server 2016 to Oracle 12c

I'm having difficulty creating a Linked Server in SQL Server 2016 to talk to a remote Oracle database. I have installed Oracle Database Client 12c. First I installed InstantClient and then later ...
0
votes
1answer
445 views

Link Server Error - From SQL2008r2 to SQL2014

I'm getting the following error when I try to query a table using a link server. The link server is created on SQL2008r2 instance to connect to an SQL2014 instance. The OLE DB provider "SQLNCLI10" ...
5
votes
1answer
76 views

how to stop using sql server login credentials in a linked server?

I have a linked server based in Italy server_italia that connects to a server based in Oregon USA ORDB1 we are on different but trusted domains. The connection from server_italia to ORDB1 is made ...
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 ...
0
votes
0answers
14 views

Linked server query fails when using an Alias after a schema change

Recently we added a new column [NewColumn] in a table [OurTable]. After that, a query from linked server referencing this table failed with error: The multi-part identifier "[OurTable].[NewColumn]"...
2
votes
1answer
347 views

SQL Server: efficient query with (double) linked servers

I am DBA of server A (SQL Server 2008R2), linked to server B (SQL Server 2012SP1), linked to server C (not sure which version). I have no control on server C, and I cannot contact its DBA. On server B,...
2
votes
1answer
200 views

Catch OLE DB provider “SQLNCLI10” for linked server “[Some Server]” returned message “Query timeout expired”

Without changing the settings on servers, etc to the linked server connections, etc, is there a way to catch the dreaded? "OLE DB provider "SQLNCLI10" for linked server "[Some Server here]" ...
0
votes
1answer
100 views

Installing MS SQL Server on Centos

Has anyone been able to install SQL Server on Centos 6? I am running Centos 6.8, and I can only find information on Centos 7. I know that SQL Server on Linux is still in its early stages. I’m curious ...
0
votes
1answer
443 views

Crystal Reports - Linked Server Connection

We have SQL server 2012 and we connect another server which is on different domain using a Linked Server name-> 192.xx.xx.xx. I can query and view the 192.xx.xx.xx data using SQL Server. Now ...
5
votes
2answers
8k views

MySQL - run SELECT statement on another server without defining the table structure

In MySQL I can query information on another server using federated tables, as long as I've defined the same table structure locally. In MS SQL Server, however, I can run any SQL statement against a ...
2
votes
1answer
1k views

Security risk of Enabling MS DTC Distributed transaction?

I'm doing data exchange and Insert update operations over the linked server between two database servers. To allow distributed transaction, I've changed settings in Windows to enable MS DTC services. ...
-1
votes
1answer
46 views

Query Plan for a linked-server query getting cleared from plan cache after every execution

I have linked server query which runs of a view created in the remote server. Whenever i run the query i can see that a Prepared plan gets created in the plancache. But that gets removed from the plan ...
2
votes
1answer
1k views

Unable to get output variable of Oracle procedure using Sql linked server

I have created a Heterogeneous connection between SQL Server and Oracle and tried to call a oracle procedure from SQL Server.I got below error when i tried to execute the procedure. OLE DB provider ...
8
votes
4answers
13k views

Get @@SERVERNAME from linked server

This seems like a basic question but I can't find any answers out there - I need to be able to get the server name/instance etc. from a linked server. I've tried a couple of things: select <linked ...
0
votes
2answers
65 views

Performance of a linked server between two instances of SQL Server on the same virtual machine

I would like to set up log shipping between SQL Server 2014 (main) and SQL Server 2016 (secondary). The thing is I want to set the secondary DB in STANDBY. Unfortunalely this setup is not supported by ...
2
votes
0answers
65 views

BulkAdmin Role Doesn't Work

There is a query that our BI team use. They can not execute the query because of the error below. Ad hoc access to ole db provider 'MSDASQL' has been denied. You must access this provider ...
4
votes
2answers
7k views

How do I specify a linked server to a remote database over tcp/ip?

I have a remote database running on an IAAS provider and I need to be able to execute joined queries from my local workstation. I am having trouble because when I attempt to create the link it is ...
0
votes
1answer
38 views

Oracle Linked Server Long Preemptive_COM_Cocreateinstance Waits

I have a Linked Server using the OraOLEDB.Oracle provider from the 11g Oracle Client and it was working fine for a while. However, an Oracle 12c Heterogeneous Connection was setup recently. This ...
0
votes
2answers
28 views

Azure Database Link to another Azure database

How to query between two databases with the same server in SQL Database? Currently we are aiming to link two azure databases that will update simultaneously. Thanks!
0
votes
1answer
35 views

adding 2nd catalog for linked server to DB2

I am unable to figure out how to add multiple catalogs for a DB2 linked server. I have an initial Linked server setup and working properly, but I am struggling to figure out how to add multiple ...
0
votes
1answer
651 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 ...
1
vote
2answers
274 views

How to fail over availability groups on multiple remote servers

We have many SQL Server installations with availability groups. During our maintenance window, we will need to fail over all the HA groups to secondaries, patch the primary servers, then fail back, ...
0
votes
1answer
38 views

SSMS works, Linked Server does not

Linked Server SS 2012(SP4) to SS 2016(SP1) just stopped working. It times out with the error "Server is not found or not accessible". However I can connect and query the target server successfully ...
0
votes
0answers
22 views

Insert Into Table From SQL Server To MySQL

I am on server1 which has a linked server to server2 and server3. This must be done on server1, but I can not get the syntax accurate. What I want to do is query server2 using OPENQUERY, and ...
21
votes
5answers
4k views

Why is this explicit cast causing problems only with a Linked Server?

I am querying data from a linked server through a view on the origin server. The view has to include a couple of standardized columns, such as Created, Modified and Deleted, but in this case the table ...
0
votes
1answer
90 views

Extracting data from people soft db to SQL Server

I have a requirement to create a new database on SQL Server from an existing Peoplesoft database, which is on oracle. I already have the script with me, and I want to know if the data can be extracted ...
0
votes
0answers
56 views

Linked Server Performance

I have three MS SQL Servers, 2016. 1 source and two destinations. There is a linked server setup from each destination server to the source. We execute a simple select query from each destination ...
0
votes
1answer
27 views

Retrieve LOGINPROPERTY information via linked server

When I run the below query on a linked server it returns nulls in the "DaysUntilExpiration" column as per resultset. SELECT '<link server>' as Instance, SL.name AS LoginName ,...
1
vote
2answers
604 views

How to use OPENQUERY to properly execute a Stored Procedure that updates a linked server table?

I'm having a hard time trying to figure this out. I'm using OPENQUERY to execute Stored Procedures on a linked server. I managed to find a way to do it, by using the following: SELECT * FROM ...
0
votes
0answers
72 views

How to connect Informix to SQL Server as a linked server?

We got to the point that we can see the tables, but we can't see the columns. For the record, all of the tables are called "root.". I don't know what that means in Informix speak. Based on the ...
1
vote
1answer
46 views

Failover Availability Group from linked Server

I am hoping you can all help me in what feels like a really simple problem, but one I am struggling to find a solution for. We are running SQL Server Standard 2016 and utilize availability groups ...
2
votes
2answers
87 views

Job Information - When querying [msdb].[dbo].SYSJOBS_VIEW through linked server

I am trying to build a report to query all my sql server jobs and thier status from the previous night's run. In an effort to have just one report instead of a separate report for each server, I am ...
0
votes
0answers
47 views

Everyone can't use the linked server

I'm having an issue with a linked server on MSSQL Sever 2016. I created a link to an Oracle server, TKCS. It uses the Oracle OLEDB drivers installed by the Oracle client (11g). On the security tab ...
2
votes
1answer
261 views

How can I reduce OLEDB wait type in a SSAS linked server connection?

I have recently created a linked server to one of my SSAS servers. when I go ahead and open the catalogs, to see which ssas databases I have there, I use the following procedure: create procedure ...
0
votes
1answer
968 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 ...