Skip to main content
Share Your Experience: Take the 2024 Developer Survey
4 votes

MS SQL Server: How to alias a linked server

Here is how we've handled a very similar situation. On both Torch SQL instances, create a linked server pointing to the matching DataMine server. But don't include the Test/Prod designation in the ...
Doug Deden's user avatar
  • 1,782
4 votes

Using Kerberos Constrained Delegation with an ADSI Linked Server

I figured this out moments after I posted this - due to our Active Directory being locked down, one of the accounts I was using for testing had the Account is sensitive and cannot be delegated ...
DamonDCD's user avatar
3 votes
Accepted

SQL Server linked server query to Postgres not filtering rows

Have you set "Use Declare/Fetch" to true in the odbc driver options? From the documentation "If true, the driver automatically uses declare cursor/fetch to handle SELECT statements and ...
Spörri's user avatar
  • 4,724
3 votes
Accepted

Can a server outside the Windows domain connect to a 2nd SQL instance via a linked server?

This is a classic double-hop problem, but in this case, you are using NTLM rather than Kerberos (as it's outside the domain). So it's impossible to do double-hop, as NTLM doesn't support it. Options ...
Charlieface's user avatar
  • 13.2k
2 votes
Accepted

Linked Servers on SQL Server AGs

When setting up Linked Servers in an Availability Group, do I need to set up the Linked Servers on the AG Listener as well as the AG Nodes? The listener always points to the primary replica, if you ...
Sean Gallardy's user avatar
2 votes

Communicating from a SQL Server 2022 to a SQL Server 2008 over linked server

I happen to have access to similar stack due to... reasons, and there doesn't seem to be any problem of accessing the 2008 (nor 2005) server: EXEC sys.sp_addlinkedserver @server = 'sigge,42008' go ...
siggemannen's user avatar
1 vote

MSSQL Linked server login timeout

After checking every single aspect of it, I finally found the issue: For some reason our network guy set up a level 3 firewall rule in a Meraki filter for this specific IP causing only "1 way&...
Daniel's user avatar
  • 11
1 vote
Accepted

Can SQL Server contained database users use linked servers with login mappings?

However, I cannot find any explicit Microsoft documentation of this limitation. This is not straightforward, you need to put two things together. 1. In the contained database user model, the login ...
sepupic's user avatar
  • 11k
1 vote

MS SQL Server: How to alias a linked server

I decided to just create a synonym, which I didn't want to do since the test db server gets refreshed with the prod db about twice a year. create SYNONYM myTable FOR DataMineTest.mydatabase.dbo....
user288021's user avatar
1 vote

What factors influence choice between executing remote query using linkedserver via sp_executesql vs using 3 piece identifier

One of my observations is that - Options 2, 3, 4 seem to guarantee that the entire query will be executed on the target server (the linked server). Whereas option 1 could result in each table getting ...
KumarHarsh's user avatar
  • 1,648
1 vote

Linked Servers and Application Intent

had the same issue on a server, what I did was instead of making views over a remote data, I made an staging table that is updated from a view from that remote server every 5 minutes, and I directed ...
Sina Hassanpour's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible