Linked Server problem ?

Hi All,
Can anyone help me with the folllowing problem that I'm having, when I'm
using my linked server connection from a PC. Here's the overview:
I have setup a linked server to another sql Server successful and created a
view to a database on that remote server. everything works fine from the
server locally. However when I access the view remotely on my PC i get the
error message: "Login failed 'test'. Reason not associated with a trusted
server connection". I have tried many security configuration, but still no
joy. The only strange thing when I login into my machine as the
Administrator account on the nettwork, it works fine, even my own account ha
s
full administration privileges on the network.
Any help would be great!.
thanks,
Liam.Do you have with your account access on the SQL Server and on the DB Link/
DB
what kind of security use the link
"Liam Mac" <LiamMac@.discussions.microsoft.com> schrieb im Newsbeitrag
news:B27A43FB-108A-48EB-8132-9388C210CB7F@.microsoft.com...
> Hi All,
> Can anyone help me with the folllowing problem that I'm having, when I'm
> using my linked server connection from a PC. Here's the overview:
> I have setup a linked server to another sql Server successful and created
> a
> view to a database on that remote server. everything works fine from the
> server locally. However when I access the view remotely on my PC i get the
> error message: "Login failed 'test'. Reason not associated with a trusted
> server connection". I have tried many security configuration, but still
> no
> joy. The only strange thing when I login into my machine as the
> Administrator account on the nettwork, it works fine, even my own account
> has
> full administration privileges on the network.
> Any help would be great!.
> thanks,
> Liam.
>
>|||Lian
Probably your remote server is configured with Windows Authentication .
Change it to Windows/SQL Server Authentication.
"Liam Mac" <LiamMac@.discussions.microsoft.com> wrote in message
news:B27A43FB-108A-48EB-8132-9388C210CB7F@.microsoft.com...
> Hi All,
> Can anyone help me with the folllowing problem that I'm having, when I'm
> using my linked server connection from a PC. Here's the overview:
> I have setup a linked server to another sql Server successful and created
a
> view to a database on that remote server. everything works fine from the
> server locally. However when I access the view remotely on my PC i get the
> error message: "Login failed 'test'. Reason not associated with a trusted
> server connection". I have tried many security configuration, but still
no
> joy. The only strange thing when I login into my machine as the
> Administrator account on the nettwork, it works fine, even my own account
has
> full administration privileges on the network.
> Any help would be great!.
> thanks,
> Liam.
>
>|||thanks guys, i got to the bottom of my problem. one of my boxes did not have
sql service pack 3a installed. once installed all ok.
liam
"Uri Dimant" wrote:

> Lian
> Probably your remote server is configured with Windows Authentication .
> Change it to Windows/SQL Server Authentication.
>
>
> "Liam Mac" <LiamMac@.discussions.microsoft.com> wrote in message
> news:B27A43FB-108A-48EB-8132-9388C210CB7F@.microsoft.com...
> a
> no
> has
>
>