Re: Linked Server Connection Error: 18459

Hi Ulysses,
Thank you for your response.

I noticed that you said that you also encountered the same error message in
SSMS if you executed query using linked server from A to B. Could you
please confirm with me if you can execute the query in sqlcmd command
prompt?
If there is still login error in command prompt, we need to check the
following situations:
1. Ping your server B to see if server A can access Server B;

2. Run telnet command from server A to B to see if the request can reach to
the Tcp port listened by your SQL Server B.
C:\> telnet <server B> 1433
You can check what the Tcp port is listened by your SQL Server B in SQL
Server Configuration Manager. Select SQL Server 2005 Network
Configuration->Protocols for <SQLSERVERB>, double click TCP/IP, switch to
the IP Addresses tab and check IPAll section to see what the TCP port is.

3. Run SQL Profiler on your Server B to check if the login request is
delivered to your SQL Server B when you tried to query from server A. You
can take the following steps: click New Trace, click Connect, switch to the
Event Selection tab, check Show all events, expand Security Audit, check
Audit Login Failed and click Run.

If you have any other questions or concerns, please feel free to let me
know. It is my pleasure to be of assistance.

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

  • Re: Discussing 3 different strategies for deleting from multiple tables
    ... I will be using SQL Server but I am riding on top of a third party ... FYI, Account contains around 20K ... >>> This results in one parameterized query followed by two more trips to ...
    (microsoft.public.data.ado)
  • Re: Efficient coordinated queries??
    ... :-) We are distributing processing over a large server farm -- bringing it back onto the SQL server would probably kill our performance. ... Hitchhiker's Guide to Visual Studio and SQL Server ... A large chunk of it can be brought in with a single query and each row represents an item to process. ... For a hypothetical example consider a customer order database where we need to process through all customers and can bring in a row of customer data as our main query but there are 0..n1 rows of customer order data, 0..n2 rows of customer feedback information, 0..n3 rows of customer discounts available, etc. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Calculated field in pass through query
    ... Using the same hardware, with a single user, Jet will be faster than MS SQL ... Server simply because Jet does not use log. ... Even within MS SQL Server, ... same query on the same data but on another MSSQL db, ...
    (microsoft.public.access.queries)
  • Re: MailMerge hangs and crashes with Access on Server
    ... Since I am fairly new to working in this environment, I am not sure what you mean by an "Access group" with help to restructuring the query? ... "Peter Jamieson" wrote: ... All I know is that the performance of queries depends to a large extent on whether, for example, a join is performed on the client side, or on the server side, incurring no network traffic and potentially benefitting from caching on the server. ... There are no dialog boxes, and actually, I have now split the database, and have kept the Word templates and the Access frontend locally on my machine, and moved the backend to the server. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Website Connectivity?
    ... does the website just query our server? ... How do I give it a login to query the SQL Server running on the server? ... It would be a serious security breach to allow a remote website to ...
    (microsoft.public.windows.server.sbs)