Questions tagged [linked-server]

Linked server allows operation to multiple server as one query.

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

Linked server only works if I am on the machine itself. I can't use it from my local computer. what is missing?

I have a few queries that I use to monitor log shipping. Sometimes I want to run those queries on a different server. I usually do that through a linked server. I have a server called SQLDEV4-TS that ...
0
votes
0answers
28 views

Linked Server Issues SQL Server to Oracle

I am trying to set up a linked server from SQL Server Production to one of our Oracle instances but experiencing this error : The test connection in ODBC succeeds, but it fails on SQL Server side. I ...
2
votes
1answer
49 views

Adding AD Security group to a SQL linked server

I have a question about adding permissions for a user group on a linked server in SQL Server. I am not a security specialist, so I appeal to everyone. Here is the topo: I have private software that I'...
1
vote
1answer
44 views

How to get an actual execution plan from the linked server?

There is a "main" SQL Server to which I have full access and I can connect to it via SSMS. Its version is: Microsoft SQL Server 2016 (SP1-CU15-GDR) (KB4505221) - 13.0.4604.0 (X64) Jun ...
0
votes
1answer
25 views

Providers in SQL Server linked server configuration

How 'allow in process' works for providers in SQL server linked server configuration ? It looks like it's unchecked by default. What is the requirement for keeping this option checked and What are the ...
0
votes
0answers
39 views

Using OPENROWSET to query LDAP via SQL requires the DisallowAdhocAccess registry option is explicitly set to 0 for the specified provider

We have clients that are using SQL Server 2008 R2, 2012, 2014, 2017 and 2019, and I'm facing a situation where we're going to need to ask them to manually create registry entries on their database ...
1
vote
1answer
122 views

SQL Server 2019 using Linked server to Oracle 19c (19.9) using Oracle 19c client on Windows - DBCOLUMNFLAGS_ISNULLABLE error

Having issues selected data for some Oracle tables over the linked server from SQL Server: select type, count(*) from RMTDB..JOB1308.HOST_INTERFACE group by type order by 1 desc; Msg 7356, Level 16, ...
1
vote
1answer
111 views

Some users fail to query linked server with “Login failed for user NT AUTHORITY\ANONYMOUS LOGON”

When I try to run a simple query involving a linked server it fails: SELECT * FROM [server2].[DWH].[dbo].[SomeTable] Msg 18456, Level 14, State 1, Line 1 Login failed for user 'NT AUTHORITY\ANONYMOUS ...
9
votes
5answers
429 views

Linked Server connection started failing with “Cannot generate SSPI context … SQL Server Network Interfaces: The logon attempt failed” error?

The Issue I have two SQL Server 2016 Standard Edition servers on the same domain. ServerA has two linked server connections setup to ServerB. The first linked server connection is using a dedicated ...
0
votes
1answer
95 views

Linked Server to Oracle error ORA-01804

Migrating SQL Server to a new machine. Migration involves setting up a number of linked servers, some SQL Server, Oracle and Teradata. No issues with SQL Server or Teradata servers, but every Oracle ...
0
votes
0answers
50 views

Linked server - cannot create an instance of OLE DB provider “SQLNCLI11”

I have created a linked server and I am receiving the following error: The test connection to the linked server failed. Additional information: An exception occurred while executing a Transact-SQL ...
0
votes
0answers
58 views

Sql Server ODBC Linked Server

I'm trying to create a linked server in SQL server 2017, linked system is odbc (criteria criOdbc) Test 1 Form SQL Server SSMS select * from OPENROWSET('MSDASQL','DSN=criteria64;uid=xxxx;pwd=yyyy;','...
1
vote
1answer
79 views

Can SQL Server OpenQuery/OpenRowSet to an LDAP Linked Server be used for Authentication?

I can fetch data back from LDAPS (port 636/3269) by first creating a Linked Server using sp_addlinkedserver and sp_addlinkedsrvlogin. However, what I really need to do is to authenticate a Username/...
0
votes
1answer
561 views

Cannot fetch a row from OLE DB provider “SQLNCLI11” for linked server

I have two SQL Servers on two different machines somewhere in the cloud (maybe Azure). One is Microsoft SQL Server 2012 (SP3-CU10) (KB4025925) - 11.0.6607.3 (X64) Jul 8 2017 16:43:40 Copyright (c) ...
0
votes
1answer
113 views

Can an AD service account host SPNs for multiple SQL Instances?

Trying to set up Kerberos Authentication between two linked server to get past the double-hop issue. Server A is in a domain with several other SQL Servers. All SQL instances on all servers in this ...
0
votes
0answers
46 views

Linked server anonymous login error

I am trying to access a database in my UAT server through a windows login credential. When I try to access the database, I get the error Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' This ...
0
votes
1answer
57 views

Create LINKED SERVER to MYSQL using SSH

Is there any way to create a MS SQL Server Linked Server to connect to MySQL through SSH? I managed to connect to MySQL through SSH using other database management tools like HeidiSQL or DBeaver, ...
0
votes
0answers
25 views

Linked Server Using a DNS Alias Returning Bad Data

Somehow on the same DEV server we have two Linked Servers to the same PROD server. While that, in and of itself, is not an issue; we have noted something we can't explain and we wonder of anyone else ...
4
votes
2answers
186 views

Remote Scan when updating using functions

Why does using ISNULL() when updating through a linked server use Remote Scan to retrieve all rows and filter locally instead of filtering through Remote Query? UPDATE LINKEDSERVER1.database1.dbo....
1
vote
0answers
62 views

SQL Server linked server losing Windows authentication credentials

We are seeing a sporadic authentication issue between two SQL Server instances with linked servers where the Windows authentication credentials are sometimes lost on the remote server. When this ...
1
vote
1answer
323 views

Query to Linked Server Ignores Configured Timeout Connection

I need to know where to set the timeout for a login or a query to a linked server. If the server is down I don't want to waste too much time waiting for a timeout. (Our servers are on the same network ...
0
votes
1answer
90 views

DELETE and INSERT using OPENQUERY to Oracle require long delay between them

I'm doing a DELETE followed by an INSERT on an OPENQUERY to Oracle. I have tried a straight DELETE with a WHERE as well as filtering with a JOIN. INSERT is just an INSERT OPENQUERY/SELECT. I have also ...
1
vote
1answer
97 views

Graceful Test for Linked Server Availability Inside a TVF or View

I’ve got a mission critical table valued function that needs to return results from several linked servers simultaneously. If any of those servers are down, it still needs to return results from the ...
0
votes
2answers
37 views

Update fails on linked server, Select works

I am trying to understand why my update statement on my local server is failing on my remote server. I am receiving the following error: OLE DB provider "SQLNCLI11" for linked server "...
0
votes
1answer
54 views

How to setup Linked Server connect with different Domain Account with Windows Authentication

we have two SQL Server 2017 "ServerA" and "ServerB" on Windows Server 2016 in the same domain. Both SQL Server have a Login defined "mydomain\dbaccount". On ServerA we ...
10
votes
2answers
2k views

OLE DB provider “MSOLEDBSQL” with SQL Server not supported?

I have been using linked server with the old provider (SQLNCLI) without any issue, as recommended by Microsoft, I'm planning to switch to new provider (MSOLEDBSQL). I'm able to add linked server using ...
0
votes
1answer
49 views

Oracle linked server invalid table name

i have created a linked server from sql server and i am now trying to access the table in oracle using the following trigger to insert data into oracle. i cannot refer the table name in oracle. ...
0
votes
1answer
132 views

insert trigger in sql server to linked oracle

i have created a linked server to oracle in sql server and i want to write one trigger on table in sql server to insert the data into oracle table. For example the table a is in sql server and table b ...
0
votes
1answer
32 views

SQL Authenticated Account is unable to select a View in MS SQL Server

I am trying to select a view using a SQL authenticated account. This view is actually reading a spreadsheet from a local drive (through a LinkedServer). I am getting below error: Msg 7416, Level 16, ...
1
vote
1answer
32 views

I need a way to give a sql authenticated user read access to a windows directory

A SQL-authenticated user SBA_USER is selecting from a View which uses Linked Server which points to an Excel spreadsheet in the I:\Folder directory on a windows server. Problem I have is that the ...
0
votes
1answer
45 views

Mapping logins to linked servers for migration

My team is migrating a SQL 2012 server with an extensive list of linked servers to SQL 2016. My task is to script the creation of linked servers on the new server. It looks like I have all the ...
0
votes
1answer
84 views

Creating Linked Server Object to same instance

I'm trying to create a Linked Server Object back to the same SQL Express 2014 server instance (see below for the context), but I'm hitting the following error... Cannot initialize the data source ...
0
votes
1answer
42 views

Unable to use undeclared variable

DECLARE @LINKEDSERVER VARCHAR(20)= 'LS_CMT'; DECLARE @ODS_DBNAME VARCHAR(20)= ''; SET @ODS_DBNAME = DB_NAME(); DECLARE @OCS_DBNAME VARCHAR(20)= ''; SET @OCS_DBNAME = '...
0
votes
0answers
13 views

Linked server created but failed connection test

When creating the linked server I am choosing the "Be made using this security context" on the security tab and I am trying with a domain account which is failing. I could of sworn in the ...
1
vote
2answers
324 views

Query is failing

I am running a query from SQL Server 2019(64bit) SSMS to PostgreSQL on AWS through Linked Server. Other queries are working fine but this particular query is failing due to message column. My query is ...
0
votes
1answer
118 views

SQL Server Linked Server to Azure SQL using Azure AD

I am trying to set up a linked server from an on-prem SQL Server to an Azure SQL instance. The Azure SQL instance uses Azure AD for authentication. When we attempt the connection we get this error ...
0
votes
0answers
1k views

“New request is not allowed to start because it should come with valid transaction descriptor” using linked server

I have a simple query in a stored procedure that LEFT JOINs a local temp table with several tables across a linked server (the same linked server). This query is resulting in the following error: ...
0
votes
0answers
75 views

SQL Login can access Linked Server w/ impersonation, but Windows Login cannot

In SQL Server 2017 I have a Linked Server defined to use a fixed remote SQL Login for all local users. EXEC master.dbo.sp_addlinkedserver @server = 'RemoteServer', @srvproduct='SQL Server'; EXEC ...
0
votes
2answers
149 views

How to remove linked servers provider?

I installed an Oracle OraOLEDB.Oracle provider. Now I want to remove that provider from the list. How can I do that?
0
votes
0answers
87 views

OPENQUERY giving wrong result on linked server

I have setup linked servers on my SQL Server and choose Oracle as a linked server. SOMETIMES, When I run the query below under the SA username, I get different result. However when I run under my own ...
1
vote
1answer
85 views

SQL Server Linked Servers not connecting

I have configured linked servers with "connections will be made using the login's current security context", but can only make use of them when logged on to the server, not from another machine... ...
0
votes
0answers
91 views

ODBC convert postgres citext column in SQL Server linked server

I am trying to connect a PostgreSQL to SQL Server server as a linked server. On the SQL Server, I have installed the ODBC driver for PostgreSQL (psqlodbc_09_02_0100-x64). I created a system DSN to a ...
0
votes
1answer
33 views

views restored from backup in a different server referring to linked servers

I have 3 SQL servers X, Y, Z and 2 databases X.A and Y.B. There are (many) view in X.A that uses 4-level naming in their definition: SELECT ... FROM Y.B.SCHEMA.TABLE From this I infer that X ...
0
votes
0answers
21 views

How can we correlate linked server queries running to their source instance?

We have multiple versions of SQL Server from 2008R2 (I know) to 2016. There are many linked server queries. I'm trying to build a tool that will tell me the queries executing on a target server that ...
0
votes
2answers
223 views

Linked Server from On-Premise to Azure SQL Database

I am using: SSMS-18.4 SQL Server-SQL 2019 CU3 Windows 10 I was able to create a linked server successfully from on-premise SQL 2017 to the Azure SQL database without exposing my password. --Read ...
0
votes
0answers
256 views

MSSQL Express: linked server from Access database on network path

I run Microsoft SQL Server Express 64-bit version 14.0.2027.2 (X64) on Windows 10 Pro 10. I have trouble to set the appropriate network UNC path and other settings for the linked server. My ...
1
vote
1answer
148 views

Database diagram for linked server tables

I run Microsoft SQL Server Express 64-bit version 14.0.2027.2 (X64) on Windows 10 Pro 10. I created a linked server connecting tables from a Microsoft Access (mdb) database to Server Objects/Linked ...
0
votes
0answers
31 views

How to force SQL Server to write partial query set to table during select

I'm trying to run a select query to extract a data set from a linked server, to be stored on SQL server. It seems that SQL server is storing the rows of the partial data set in memory and writing it ...
0
votes
1answer
797 views

How to insert into temp table on Server A results from dynamic SQL open query stored proc call to remote server B via Remote Query showplan operator?

I have to call a stored procedure on server B from server A using open query via dynamic SQL, and insert the results into a temp table created on server A. I noticed in the execution plan, it's using ...
0
votes
1answer
43 views

How to have a fail-over resilient SQL Server view over linked mirrored database table

Say I have a set of servers with mirrored application databases and a set of statistics servers where a couple of the tables are exposed from the application database as views (with some tenant ...

1
2 3 4 5
12