Linked server setup between SQL Server Express and SQL Server

sql-server linked-server sql-server-2005-express
Billy Logan picture Billy Logan · Oct 21, 2009 · Viewed 19k times · Source

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

Answer

Irwin M. Fletcher picture Irwin M. Fletcher · Oct 21, 2009

You can use this sp to do it.

EXEC sp_addlinkedsrvlogin @rmtsrvname = 'MylinkedServer',
    @useself = 'FALSE',
    @locallogin = NULL,
    @rmtuser = 'me',
    @rmtpassword =  'myrmtpassword'

Related questions

SQL Server Linked Server Example Query

While in Management Studio, I am trying to run a query/do a join between two linked servers. Is this a correct syntax using linked db servers: select foo.id from databaseserver1.db1.table1 foo, databaseserver2.db1.table1 bar where …

Read More
How to select data of a table from another database in SQL Server?

Suppose that I have a database which name is testdb in test server. I also have a database named proddb in prod server. Now I want to select data of a table of testdb database from proddb database. How can …

Read More
How to find a text inside SQL Server procedures / triggers?

I have a linkedserver that will change. Some procedures call the linked server like this: [10.10.100.50].dbo.SPROCEDURE_EXAMPLE. We have triggers also doing this kind of work. We need to find all places that uses [10.10.100.50] to change it. In SQL …

Read More