How to config a Linked server?

up vote 0 down vote favorite

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

asked Apr 12 '11 at 8:25

Raymond Morphy

You can start here, and I dont think this belongs to SO. flagging for migration. – Sanjeevakumar Hiremath Apr 12 '11 at 8:42

feedback

migrated from stackoverflow.com Apr 12 '11 at 10:32

This question came from our site for professional and enthusiast programmers.

1 Answer

active oldest votes

up vote 2 down vote

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 8:41

Raymond Morphy

feedback