SQL linked servers

[oakpark5]

Having some problems linking two sql servers together, one is my local machine. I'm setting up the link to the main server to connect to mine, but it doesnt seem to want to work. This is what I've tried:

use master
go
sp_addlinkedserver @server = 'ITDAVID',
@srvproduct = ' ',
@provider = 'SQLOLEDB',
@datasrc = 'ITDAVID',
@catalog = 'TEST'

The error I get is: Error 17: SQL server does not exist or access denied.

Both computers are on the same network. Thanks

Software Engineer
Team Lead
damn bill gates, he has everything

 

[SonOfEmidec1100]

Use EM to add the linked server - Security/Linked Servers Right click add new linked server. This may give more of a clue as to the prob.

Also are you sure ITDAVID is the name of the sql server you are linking to. IF you run the query [blue]SELECT @@SERVER[/blue] on the main server does it return ITDAVID ?