All Questions
Tagged with sql-server-2017 linked-server
15 questions
0
votes
1
answer
84
views
SQL Server 2017 not recognizing Oracle driver for Linked server
I would like to connect from my SQL Server 2017 to an Oracle database via Linked server. I installed the Oracle driver from Oracle-Client-for-Microsoft-Tools-64-bit.exe, but the driver does not appear ...
- 23
1
vote
1
answer
65
views
Can a server outside the Windows domain connect to a 2nd SQL instance via a linked server?
I have the infrastructure shown in the diagram below.
Web Server 1 is outside the Windows Domain. Web Server 2 is inside the Windows Domain.
SQL Server 1 and 2 are both inside the domain.
There is a ...
- 25
1
vote
1
answer
1k
views
Cannot connect to linked server using name in hosts file
I am trying to set up a linked server in SQL Server 2017 using the local Windows hosts file on the server where the linked server is being set up. The reason for this is to allow me to hard-code the ...
- 25
0
votes
1
answer
74
views
How to test whether current sql engine service account can decrypt the SMK?
Is it true that when the sql service account is changed via the config manager then the new account can decrypt the SMK.
However if the change was made via the services.msc, then the new account doesn'...
- 3,499
-1
votes
2
answers
1k
views
Linked server - When is it recommended to use SQL Server or the 4 Other data sources for SQL Server?
To configure linked server pointing to a SQL server, there are 4 possible options.
Server Type: SQL Server
Server Type: Other data source; Microsoft OLE DB Provider for SQL Server
Server Type: ...
- 3,499
0
votes
0
answers
164
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 ...
- 135
1
vote
1
answer
5k
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 ...
- 61
1
vote
2
answers
4k
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:
...
- 1,217
0
votes
0
answers
900
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 ...
- 23
0
votes
0
answers
78
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 ...
1
vote
0
answers
979
views
Does SQL Server 2017 Express support Linked Server connections to Oracle DB
Is there any restrictions with "Linked Servers" with SQL Server 2017 Express? Vs using SQL Server 2017 Standard. Only in regards to "Linked Servers".
- 111
0
votes
0
answers
320
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]"...
- 5,512
1
vote
1
answer
2k
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, ...
- 373
1
vote
2
answers
745
views
Running remote stored procedure with DDL locally
Sorry if my question is redundant, I searched Stack Exchange and the internet for hours but do not have a definitive answer to my question.
Database: SQL Server 2017 + Azure
The goal is to build a ...
- 13
0
votes
1
answer
368
views
Can a contained database SQL User be mapped to a remote user in a linked server?
Using SQL Server 2017 Standard CU8 on Windows Server 2016. I've create a contained database user (user defined only within a database with Containment type: partial) with type SQL user with password (...
- 203