How to config a Linked server?

Question

How do I config my linked server to connect to the other database with following properties:

ServerName:saleh
user:sa
password:....
Computer IP address:192.168.100.146

You can start [here](http://msdn.microsoft.com/en-us/library/aa213778(v=SQL.80).aspx), and I dont think this belongs to SO. flagging for migration. — Sanjeevakumar Hiremath, Apr 12 '11 at 08:42

score 2 · Answer 1 · answered Apr 12 '11 at 08:41

2

I found the solution my self. so I'll share it here

EXEC sp_addlinkedserver

    @server = 'saleh',
    @srvproduct = '',
    @provider = 'MSDASQL',
    @provstr = 'DRIVER={SQL Server};SERVER=192.168.100.147;UID=sa;PWD=123456;'

answered Apr 12 '11 at 08:41

Raymond Morphy

121
2

How to config a Linked server?

1 Answers1