Questions tagged [linked-server]

Linked server allows operation to multiple server as one query.

Filter by
Sorted by
Tagged with
0
votes
1answer
26 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
17 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!
3
votes
0answers
37 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
18 views

Linked Server to mirrored database trying to connect to secondary

I have a Linked Server which is set up on Server A using a Microsoft OLE DB Provider for SQL Server provider to another server (Server B) I create a local server to remote server login mapping and ...
0
votes
0answers
19 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
36 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
25 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
111 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
34 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
26 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
51 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
1answer
173 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
36 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
68 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
17 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
330 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
111 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
298 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
121 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
19 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
103 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
162 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
41 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
28 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
46 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
138 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
39 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
33 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
23 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
374 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
167 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
225 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
24 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
103 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
67 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
599 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
48 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
149 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
36 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
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
194 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
95 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
49 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
241 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
239 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
192 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
30 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
622 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 ...