Re: Linked Server Connection Error: 18459

Hi Ulysses,
Thank you for your response.

Did either of your SQL Server instances run under a domain user account?
Apparently your SQL Server instances were not using Kerberos
authentication. I recommend that you first ensure that your SQL Server
Services are running under a domain user account. You can check this via
the following steps:
1. Run services.msc from command prompt;
2. Double click the SQL Server instance service;
3. Switch to the Log On tab and check if the startup account is a domain
user account.
If not, please change it to a domain user account and restart your SQL
Server instance to see if it helps.

If this issue persists, I recommend that you try deleting/re-registering
SPNs. You may also refer to this article:
How to use Kerberos authentication in SQL Server
http://support.microsoft.com/kb/319723/en-us

Hope this helps.

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: Discovering SQL Server instances in Server Explorer
    ... Discovering SQL Server instances in Server Explorer ... 'Debugger Users' and 'VS Developers'. ... I can remote desktop to the server hosting MSDE and use the OSQL utility without a problem. ...
    (microsoft.public.vsnet.enterprise.tools)
  • RE: Domain or Local User Account for Laptop SQL 2008 Services
    ... I think I'd like to use a Domain User Account for the SQL 2008 services, but if I do this, will SQL Server function properly when I'm not connected to my network? ... SQL Server will try to connect to your domain controller for establishing authentication at startup if you configured your SQL Server service to a domain user account. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.setup)
  • Re: Windows authentication/impersonation.. login failed for user null?
    ... You must make sure that domain user account or the domain security group ... ia mapped to a SQL server login/Sql Server ... database user. ... and then make specific SQL Server login as ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: SQLDMO.NameList returns Oracle??
    ... Just SQL Server instances. ... > Dim oServers As SQLDMO.NameList ...
    (microsoft.public.sqlserver.connect)
  • Re: Windows authentication/impersonation.. login failed for user null?
    ... You must make sure that domain user account or the domain security group ... ia mapped to a SQL server login/Sql Server ... database user. ... and then make specific SQL Server login as ...
    (microsoft.public.dotnet.framework.aspnet)