Search code examples
sql-serverlinked-serversql-server-2005-express

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

Solution

  • You can use this sp to do it.

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