All Questions
Tagged with linked-server sql-server-2016
22
questions
2
votes
0answers
67 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
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 ...
1
vote
1answer
52 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
1k 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
50 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
242 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
22 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 ...
1
vote
0answers
208 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
1answer
21 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 ...
1
vote
0answers
177 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
...
1
vote
1answer
295 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, ...
1
vote
0answers
249 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 ([...
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 ...
2
votes
1answer
325 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 ...
2
votes
2answers
5k views
Creating Linked Server - Impersonation of Windows Authentication
I am trying to set up a linked server on Server A to Server B using windows authentication.
Using SSMS, I can connect to both Server A (from ServerB) and Server B (From Server A) using Windows ...
3
votes
1answer
2k views
Remote query (openquery) to linked server fails after upgrading to SQL Server 2016
Problem started after upgrading to SQL Server 2016 Enterprise edition.
Linked and local servers both were upgraded to ver.13.0.4435.0
I've tried the following:
Drop/create the linked server after ...
7
votes
1answer
6k views
SQL Server --> Informix DB Linked Server
After about 3 days of trying, I am unable to create a linked server from SQL Server 2016 to Informix 11.5. I haven't tried this with other versions (2008R2, etc) since I wanted to set up the ...
9
votes
1answer
923 views
What big limitations should I expect from Linked SQL Servers?
Our product is based on Microsoft SQL Server. Currently, we are using three databases, and have always deployed them on one SQL Server instance.
The three database are OLTP, OLAP, and audit. The OLAP ...
2
votes
1answer
947 views
SQL Server 2016 - Catastrophic linked server error
I have an issue with connecting to a linked server from SQL Server 2016 to an Ingres 10.1 database via an Ingres 64bit driver ODBC connection setup - ODBC connection succeeds and the linked server ...
1
vote
2answers
98 views
OLTP - Stretch database vs linked server
From my understanding, when you enable the StretchDB feature for a table, basically creates a Linked Server locally, which has a remote server as a target to move data to.
If this is correct, does ...
2
votes
1answer
520 views
Get-MSSQLLinkPasswords Powershell script doesn't seem to work under SQL Server 2016
I've been using the Get-MSSQLLinkPasswords Powershell script for a long time and it has been a huge help. The script decrypts the passwords for all linked servers on a particular Windows server and ...
2
votes
2answers
6k views
How do I guarantee using Microsoft ODBC Driver 13 for SQL Server in a linked server?
On SQL Server 2016, how do I guarantee using Microsoft ODBC Driver 13 for SQL Server in a linked server? I don't mind there being another layer in there, such as the MSDASQL provider, but I do want ...
