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:

ServerName:saleh
user:sa
password:....
Computer IP address:192.168.100.146
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=192.168.100.147;UID=sa;PWD=123456;'
share|improve this answer
add comment

Your Answer

 
discard

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