Hey everyone, i'm trying for a while to link a web server created with plesk panel 9 to my local instant SQL server 2000, using the following request :
EXEC master..sp_addlinkedserver @server='server_name', @srvproduct='',
@provider='SQLOLEDB',
@datasrc='IP_adresse';
sp_addlinkedsrvlogin 'server_name','false', 'sa' , 'remote_user', 'remote_pwd'
remote_user and remote_pwd are the user and the pwd of the concerned data base;
but the following error message is always displayed :
That SQL Server does not exist or access denied
little help please, is very really urgent