servers problem

Hi !!!
I have two computers with Windows XP, and each these is a SQL SERVER.
I execute sp_addlinkedserver for link both servers, but when I execute a
statement SELECT using my linked server, the following error is raised:
Msg 18452, Level 14, State 1, Line 1
Login failed for user '(sa)'. Reason: Not associated with a trusted SQL
Server connection.
In both servers the authentication mode is Mixed.
can anybody help me? thanks.My guess is that you mapped the login to a SQL Server login on the other machine, and that the other
machine doesn't allow SQL Server logins (it runs in "Windows Only" mode).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"German" <German@.discussions.microsoft.com> wrote in message
news:926B63EF-95E6-4680-BFD4-53AE09DB77D6@.microsoft.com...
> Hi !!!
> I have two computers with Windows XP, and each these is a SQL SERVER.
> I execute sp_addlinkedserver for link both servers, but when I execute a
> statement SELECT using my linked server, the following error is raised:
> Msg 18452, Level 14, State 1, Line 1
> Login failed for user '(sa)'. Reason: Not associated with a trusted SQL
> Server connection.
>
> In both servers the authentication mode is Mixed.
> can anybody help me? thanks.|||Thanks for you answer.
Both Servers are Mixed authentication.
At moment to create linked servers i did it with login map and without but
the result is the same.
"Tibor Karaszi" wrote:
> My guess is that you mapped the login to a SQL Server login on the other machine, and that the other
> machine doesn't allow SQL Server logins (it runs in "Windows Only" mode).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "German" <German@.discussions.microsoft.com> wrote in message
> news:926B63EF-95E6-4680-BFD4-53AE09DB77D6@.microsoft.com...
> > Hi !!!
> >
> > I have two computers with Windows XP, and each these is a SQL SERVER.
> > I execute sp_addlinkedserver for link both servers, but when I execute a
> > statement SELECT using my linked server, the following error is raised:
> >
> > Msg 18452, Level 14, State 1, Line 1
> > Login failed for user '(sa)'. Reason: Not associated with a trusted SQL
> > Server connection.
> >
> >
> > In both servers the authentication mode is Mixed.
> >
> > can anybody help me? thanks.
>
>