Linked server setup between SQL Server Express and SQL Server

Can you please explain how to setup a linked server between a SQL Server (A) and a SQL Server Express (B) scenario.

Server A is SQL Server 2000, whereas Server B is SQL Server 2005 Express.

I have set these up in the past, but none where connected to a SQL Server Express version.

Thanks, Billy

Copyright Notice：Content Author:「Billy Logan」，Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article：https://stackoverflow.com/questions/1603463/linked-server-setup-between-sql-server-express-and-sql-server

Answers

Irwin M. Fletcher 2009-10-21T20:47:32

You can use this sp to do it.\n\nEXEC sp_addlinkedsrvlogin @rmtsrvname = 'MylinkedServer',\n @useself = 'FALSE',\n @locallogin = NULL,\n @rmtuser = 'me',\n @rmtpassword = 'myrmtpassword'\n",

Products recommended by Amazon

More >>>

SanDisk 128GB microSDXC-Card, Licensed for Nintendo-Switch - SDSQXAO-128G-GNCZN

HUANUO Dual Monitor Stand - Adjustable Spring Monitor Desk Mount Swivel Vesa Bracket with C Clamp, Grommet Mounting Base for 13 to 27 Inch Computer Screens - Each Arm Holds 4.4 to 14.3lbs

AMD Ryzen 5 5600X 6-core, 12-Thread Unlocked Desktop Processor with Wraith Stealth Cooler

Timberland Men's 6-Inch Premium Waterproof Boot

More about “Linked server setup between SQL Server Express and SQL Server” related questions

Linked server setup between SQL Server Express and SQL Server

Can you please explain how to setup a linked server between a SQL Server (A) and a SQL Server Express (B) scenario. Server A is SQL Server 2000, whereas Server B is SQL Server 2005 Express. I h...

Show Detail

SQL Linked server configuration between VM and Host

I am trying to set up a link between two SQL servers, one on my laptop and the second running on a VM on that same laptop. However I am experiencing some frustrating behavior. The setup is: Host...

Show Detail

Linked Server SQL Server 2014 to SQL Server Version 8

I have recently installed SQL Server 2014 Express and need to create a linked server. I have tried this in SQL Server Management Studio (from the object explorer - server objects - linked servers -...

Show Detail

SQL Server 2008 linked server connection string setup

I'm trying to setup a linked server to another instance of SQL Server installed on the same Windows Server. In the SQL Server Management Console I have both instances added and I'm trying to do a i...

Show Detail

Linked Server on Express and Upgrading to SQL Server 2014 Standard

We have a server running SQL Server 2014 Express, and we want to upgrade to Standard edition. We have a linked server running on Express edition. Can we upgrade to Standard edition and the linked s...

Show Detail

How to setup Linked Server from SQL Server Express 2019 to Sage Line 50

We have a Sage Line 50 Reports application located on one of our servers. This has been setup on our server as ODBC System DSN (Screenshots attached) Now Im trying to set up a linked server from this

Show Detail

Linked Server In SQL Server Express

I am developing an app where i have a local database in SQL Server Express. During work in local database, we need to execute a query on another SQL Server / live server and its return a value and...

Show Detail

Compare data in tables between SQL Server and linked server

Currently we are doing database archiving project. As part of this, around 1200 tables in SQL Server database which contains records from as low as 100 to as high as 8million are being archived. Fr...

Show Detail

How to setup linked server in Sql server to contained database on other Sql Server

If it is possible I would like to set up a linked server from my Sql server 2014 SP2 to a contained database on another Sql Server I have a secure tunnel server:port that is all setup Is this

Show Detail

Unable to link SQL Server Express to SQL Server

I have a SQL Server version 12.0 instance installed on a Windows Server 2012R2 (SERVER/SQL), and a SQL Server Express version 11.0 instance installed on a windows 10 workstation (WIN10/SQLEXPRESS)....

Show Detail