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
1
vote
0answers
28 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 ...
-1
votes
1answer
57 views

check linked servers database status

I want to find out if all SQL databases registered in the database DBConfig on the LSNR_ADMINDB are available on the respective linked server and there online or offline. I have the below Code, ...
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
37 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
23 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
54 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 ...
1
vote
1answer
67 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? ...
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]"...
-1
votes
1answer
45 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
0answers
64 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 ...
0
votes
2answers
64 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 ...
0
votes
1answer
36 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
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
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!
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 ...
0
votes
0answers
21 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 ...
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
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
546 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
70 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
42 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
84 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 ...
2
votes
2answers
810 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
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
188 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
0answers
21 views

Linked Server Provider

Attempting to set up a linked server to a Oracle 11g database via MSSQL 2016. Unfortunately I don't seem to have any data providers to choose from in SSMS. Initially thought it was an issue with ...
5
votes
1answer
519 views

Creating Stored Procedure in local db that references tables in linked server

I currently have a local server linked to a remote server. Is it possible to create a stored procedure within the local server, but querying data from tables within the linked server. I am aware ...
1
vote
2answers
262 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, ...
2
votes
1answer
598 views

Linked server returned message “Query timeout expired.”

We have two separate SQL Servers. On one server we have a data warehouse (DWH), on the other we have sales information database. Now on the DWH server there is an ETL job that collects the ...
1
vote
0answers
176 views

Database not showing in sys.databases over linked server

I have a query that I can run on my server (Server1) as follows: SELECT * FROM master.sys.databases WHERE name = 'MyDB' This returns a row. I have a linked server setup on Server2 which points to ...
0
votes
0answers
21 views

SSIS DB issues when trying to run Package from SSISDB to getch ADO directoty users list

I am working on task that involves using Dev server to fetch ADO directory user information. I am connecting through SQL script i Script task and passing my User authentication. This is working fine ...
0
votes
1answer
20 views

enable the data access for the current server - is this operation logged somewhere?

I have a similar question related to the same subject: security concerns over enabling data access for the current server BEGIN TRY PRINT @@SERVERNAME PRINT DB_NAME() PRINT 'enable the ...
2
votes
1answer
188 views

Microsoft Sql Server - How to replicate a table from Linked Server?

I have an Origin Database - #1 with very restrictive access due to security. I provisioned a new Windows desktop machine with Microsoft Sql Server Management where I created a local database with all ...
1
vote
0answers
173 views

SQL Linked Server Connection Success but simple query returns Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

I linked a SQL Server in Management Studio and when I test the connection, I do get "the test connection to the linked server succeeded." However, when I try to run a simple query, I get a message ...
0
votes
1answer
45 views

Using Linked Server to store data

I have a linked server setup on my source production server. I also have a secondary server which is the linked server. What I was looking to do is to execute a stroed proc and log connections to the ...
1
vote
1answer
36 views

FILEPROPERTY not working over linked server to Azure SQL Database

FILEPROPERTY (Transact-SQL) is not working with a linked server pointing from a on-Premise SQL 2017 to a Azure SQL Database. I see the following comment in books online: Returns NULL for files that ...
0
votes
1answer
57 views

Missing data in SQL Server

I need to find the data that is present in Oracle, but missing from SQL Server. I have tried the below query, but am getting the following error: The multi-part identifier "PS.TXN_ID" could not be ...
1
vote
1answer
372 views

Oracle linked server shows all tables from all schemas in sql server management studio

I have created a linked server to an oracle database ( 12c ) in sql server management studio. I am mapping the local user to a special remote user in the oracle db. Connection is working fine. The ...
1
vote
1answer
45 views

Linked Server Configuration using remote user logins

I'm trying to configure a Linked Server using remote logins reducing who has access to the linked server by taking advantage of the not be made option. For test purposes alone, I have used SA, ...
0
votes
1answer
36 views

SQL Server Linked Server sa [closed]

Should a linked server be created using the sa account as the security context? Why / why not?
0
votes
1answer
27 views

Linked Server - Map Windows Group to remote login

I have a MySQL server that I need to set up as a linked server in SQL Server 2014. I need a login from the SQL Server (which is a Windows group) to impersonate a username at the MySQL end. I can see ...
1
vote
0answers
488 views

Grant permissions over linked server

I need to grant select permissions to a sensitive table over the linked server. This table should only grant access to members of an AD group. I currently have other linked servers set up with remote ...
2
votes
3answers
252 views

Setting a variable from a statement that starts with EXEC

I am trying to get the Server Name from a LinkedServer and assign it to a variable. From this question (Get @@SERVERNAME from linked server), I found that either of these return the Server Name. ...
0
votes
1answer
291 views

SQL Server - Query Over Linked Server to IBM DB2 throws an error

We have a partner that uses a IBM DB2 iAccess database, which we connect to using a linked server on our SQL Server. It's been working great for a long time, but over the weekend they upgraded their ...
1
vote
1answer
26 views

Exist on table from linked Server giving Error 4104

I am comparing two tables on different Servers and the query I am running looks like this: Select top 100 * From [ServerA].[MyDB].[dbo].[Table1] Where Exists( Select * from [ServerB].[TheirDB].[...
1
vote
2answers
145 views

sp_blitzfirst results to table on a linked server

I have been all over looking for the solution to logging sp_blitzfirst results to table on a linked server. I see github posts where a contributor was adding this to sp_blitz, but that's been closed ...
0
votes
1answer
80 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
751 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
52 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 ...