ansaurus

Question

Linked server setup between SQL Server Express and SQL Server

Answer 1

A:

You can use this sp to do it.

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

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

i have tried this. I get the following error:OLE DB provider "SQLNCLI" for linked server "MyServerName" returned message "Communication link failure".Msg 10054, Level 16, State 1, Line 0TCP Provider: An existing connection was forcibly closed by the remote host.Msg 18456, Level 14, State 1, Line 0Login failed for user 'Me'.

Billy Logan 2009-10-21 20:58:21

This approached worked for me after i changed to the proper user. Thank you very much.

Billy Logan 2009-10-21 21:05:19

Answer 2

A:

You could try using the sp_addlinkedserver stored procedure:

http://blogs.techrepublic.com.com/datacenter/?p=133

Sql server Express supports linked servers

Shiraz Bhaiji 2009-10-21 20:51:01

ansaurus

tags:

views:

answers:

Linked server setup between SQL Server Express and SQL Server

related questions