Take the 2-minute tour ×
Server Fault is a question and answer site for 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:

ServerName:saleh
user:sa
password:....
Computer IP address:192.168.100.146
share|improve this question

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

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

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

1 Answer 1

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;'
share|improve this answer

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.