Getting permission On Remote Server

After i add the server as remote, Set the Data access option to be True
I run the current sql:
SELECT *
FROM ServerName.DatabaseName.dbo.Client
It gave me an error: Server does not exist or access denined
Where can be the problem?
--
' 03-5611606
' 050-7709399
: roy@.atidsm.co.ilRoy
Make sure that the login had been granted to this database
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:eR8elxa9FHA.1420@.TK2MSFTNGP09.phx.gbl...
> After i add the server as remote, Set the Data access option to be True
> I run the current sql:
> SELECT *
> FROM ServerName.DatabaseName.dbo.Client
> It gave me an error: Server does not exist or access denined
> Where can be the problem?
> --
>
>
> ' 03-5611606
> ' 050-7709399
> : roy@.atidsm.co.il
>|||Hi,
here are some potential causes for reason /error :
http://support.microsoft.com/defaul...kb;en-us;328306
and ensure proper connection has been done using
sp_addlinkedserver
sp_addlinkedsrvlogin
:-)
Regards
--
Andy Davis
Activecrypt Team
---
SQL Server Encryption Software
http://www.activecrypt.com
"Roy Goldhammer" wrote:

> After i add the server as remote, Set the Data access option to be True
> I run the current sql:
> SELECT *
> FROM ServerName.DatabaseName.dbo.Client
> It gave me an error: Server does not exist or access denined
> Where can be the problem?
> --
> ??òé a?ì????
> òúé? ?e??ú ú??e?
> èì' 03-5611606
> ?ì_' 050-7709399
> _é?ééì: roy@.atidsm.co.il
>
>