SQL Server Performance Forum – Threads Archive

Error 18452: not Associated with trusted connectio

Hi all,
while i am connecting my sql server to another sql server using linked servers .
I am getting error 18452: login failes for user ‘manoj’. not associated with trusted connection. I am having 2 win2k3 servers both having MSSQLServer2000. i have enabled mix mode authentication. any help is appreciated.
please help me.

---

hi, have you map account / login for manoj using sp_addlinkedsrvlogin
Regards Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami

---

This is a security ion issue.more info. http://msdn.microsoft.com/library/e….asp?frame=true
—————————————-
Cast your vote
http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka

---

Hi, sp_addlinkedsrvlogin @rmtsrvname = ‘yourremoteserver’
, @useself = false
, @locallogin = ‘manoj’
, @rmtuser = ‘manoj’
, @rmtpassword = ‘password’ will resolve your issue
Regards Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami

---

]]>