Re: Linked Server Connection Error: 18459

Hi Ulysses,
Thank you for your response.

According to your description, I think that now we can conclude that:
1. You can directly connect to B from server A via SSMS with the windows
login account;
2. You cannot connect to B from A via linked server with the windows login
account.

In this case, I would first check with you how you created the linked
server. Did you ever provide a password in the linked server? If so, it is
possible that the password is not correct. I recommend that you try
deleting/recreating the linked server with the same account or with a
different Windows/SQL login account to see if it helps.

In addition, I recommend that you check if OPENDATASOURCE works for you,
for example:
SELECT *
FROM OPENDATASOURCE('SQLNCLI',
'Data Source=serverB;Integrated Security=SSPI')
.AdventureWorks.HumanResources.Employee

If you have any other questions or concerns, please feel free to let me
know. Have a nice day!


Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================

.

Relevant Pages

  • SecurityFocus Microsoft Newsletter #154
    ... MICROSOFT VULNERABILITY SUMMARY ... ISS RealSecure Server Sensor SSL Denial Of Service Vulnerabi... ... Roger Wilco Remote Server Side Buffer Overrun Vulnerability ... available for Microsoft Windows operating systems. ...
    (Focus-Microsoft)
  • SecurityFocus Microsoft Newsletter #49
    ... Subject: SecurityFocus Microsoft Newsletter #49 ... Microsoft Windows NNTP Denial of Service Vulnerability ... Microsoft IIS SSI Buffer Overrun Privelege Elevation Vulnerability ... Microsoft ISA Server H.323 Memory Leak Denial of Service... ...
    (Focus-Microsoft)
  • ~~~~~~~~~~~~~~~ CANNOT FIND ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    ... cannot find server or dns error ... windows cannot find null ... windows cannot find the network path ... cannot find internet explorer on computer ...
    (comp.protocols.snmp)
  • Questions Relating to Administering Windows 2000 Server
    ... installed the network client on the target computer. ... Sarah has been attempting to install Windows 2000 ... Server for two days. ... Sarah has checked the cables and hard drives. ...
    (microsoft.public.cert.exam.mcse)
  • pqv소박한 꿈@mBGRx
    ... O-009바▣ MS Windows 2000 Datacenter Server -2만원 ... Main Application (Borland C++ Builder 6 Enterprise Edition) ... Y-166▣ Sex Starved Sluts 1 (Divx) ...
    (FreeBSD-Security)
Loading