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 has
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...
> > 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.
> >
> >
> >
>
>sql