Linked Server error in Windows2003Server

Dear all,
I've got this error message on creating the linked server to the SQL Server
2000 (in Windows 2003 Server),
"Error 18452: Login failed for user 'sa'. Reason: Not associated with a
trusted SQL Server connection."
The client side is MSDE 2000 (in WinXP Pro).
But I can successfully create this linked server relationship when the
server side is SQL Server 2000 (in Windows 2000 Server or WinXP Pro). If the
OS in server side is changed to Windows 2003 Server, the above error
occurred. Why?
Thanks a lot.
Curtis
Curtis,
I very much doubt that the OS version has anything to do with your
problem. The error message clearly shows that the Server you are trying
to connect to expects a trusted Windows login. The sa account is a SQL
Server login and that's why the login attempt fails. Change the
authentification mode on the SQL server to mixed (SQL and Windows
authentification) and it should work.
Markus
|||Thanks for you reply.
But for the Windows2003Server, the authentification mode is already mixed
mode.
One more thing, this error message has not been shown if both are the SQL
Server 2000 (in Windows2003Server). It's only appeared with either one is
the WinXP Pro. So, I've suspected that anything goes wrong in the client.
P.S.: Also, I've just walked through different forums, and the solution is
same as yours, i.e. set to the mixed mode, but it seems doesn't work on my
problem.
Curtis
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1141135359.765464.289340@.t39g2000cwt.googlegr oups.com...
> Curtis,
> I very much doubt that the OS version has anything to do with your
> problem. The error message clearly shows that the Server you are trying
> to connect to expects a trusted Windows login. The sa account is a SQL
> Server login and that's why the login attempt fails. Change the
> authentification mode on the SQL server to mixed (SQL and Windows
> authentification) and it should work.
> Markus
>
|||Lun wrote:
> Thanks for you reply.
> But for the Windows2003Server, the authentification mode is already mixed
> mode.
> One more thing, this error message has not been shown if both are the SQL
> Server 2000 (in Windows2003Server). It's only appeared with either one is
> the WinXP Pro. So, I've suspected that anything goes wrong in the client.
> P.S.: Also, I've just walked through different forums, and the solution is
> same as yours, i.e. set to the mixed mode, but it seems doesn't work on my
> problem.
> Curtis
> "MarkusB" <m.bohse@.quest-consultants.com> wrote in message
> news:1141135359.765464.289340@.t39g2000cwt.googlegr oups.com...
>
Have you created a linkedserver login? It sounds like you're trying to
connect with a SQL user but that you haven't linked this user to a login
on the linked server.
Try to look up sp_addlinkedserver and/or sp_addlinkedsrvlogin in Books
On Line.
Regards
Steen