Re: Getting Msg 18456 in referencing a database from a linked server

From: Immy (imtiaz_ullah_at_hotmail.com)
Date: 06/11/04 

Date: Fri, 11 Jun 2004 15:03:51 +0100

  What security type are you using?
  Standard or Windows?

  Your sp_addlinkedserver will default to use "current security credentials"
to authenticate to serverb.

  You should try adding your linked server passing an SQL
authentication/Valid Windows account depending on your security type.

  e.g. sp_addlinkedsrvlogin ServerB ,false ,null , SQLUSER, USERPASSWORD"

  Immy
  "TJTODD" <Thxomasx.Toddy@Siemensx.com> wrote in message
news:ed748v7TEHA.3420@TK2MSFTNGP09.phx.gbl...
> Trying to use linked server for the first time and having some problems.
>
> I have 2 servers "ServerA" and "ServerB". From ServerA I want to be
able to
> access data from ServerB. I ran the following on ServerA
> USE master
> GO
> EXEC sp_addlinkedserver 'ServerB', N'SQL Server'
> GO
>
> Then I ran the following SQL on ServerA
> SELECT * FROM SERVERB.DBNAME.dbo.TABLENAME
>
> And I get the following message:
> Server: Msg 18456, Level 14, State 1, Line 1
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
>
> Can someone tell me how I can get past this problem?
>
> Thanks in advance!
>
>
>

Relevant Pages

  • RE: SQL Mail
    ... For SQL Mail to work, you need to have the service running under a domain ... Unless it is a domain account, ... > need to be able to send email via SQL from ServerB to ServerA. ...
    (microsoft.public.sqlserver.server)
  • Re: sql agent permission
    ... In terms of linked server configuration, all I said is that the sql ... account used to connect the remote standby server is the same account ... >>and I want to set up serverB as a standby server. ...
    (microsoft.public.sqlserver.security)
  • SQL Mail
    ... ServerB ... need to be able to send email via SQL from ServerB to ServerA. ... Userid on local serverB: tommy - password: tommy ...
    (microsoft.public.sqlserver.server)
  • how to synchronize nt accounts after database restore on a different server?
    ... I had to move/restore one of our dbs from ServerA (sql 2k on nt5 box) to ... Windows authentication is used to authenticate users to the server. ... The SQL ServerB does not have an account for Domain\Staff (under ...
    (microsoft.public.sqlserver.programming)
  • Re: sql agent permission
    ... saying in terms of your linked server configuration. ... >and I want to set up serverB as a standby server. ... call a stored procedure on serverB to restore the database on ... >serverB as ABC. ...
    (microsoft.public.sqlserver.security)