Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

Computer IP address:
share|improve this question
You can start here, and I dont think this belongs to SO. flagging for migration. –  Sanjeevakumar Hiremath Apr 12 '11 at 8:42
add comment

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

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

1 Answer

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=;UID=sa;PWD=123456;'
share|improve this answer
add comment

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.