Login failed for user '(null)'...

There are two computers, PC1 and PC2. On PC1 I started QueryAnalyzer and
selected a database on PC2 using Windows authentication and executed the
following query:

select * from PC1.Database1.dbo.Table1

I got this error:

Server: Msg 18452, Level 14, State 1, Line 2
Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection.

Both servers are set to mixed mode authentication and both are linked
using sp_addlinkedserver. Does anybody have a solution to this issue?

--
Best regards,
Vladimir.

Vova
When you created linked  server what is the login do you specify?


"Vladimir Svrkota" <see@reply.to> wrote in message
news:1o1fojctigtr3.dlg@vladimir.svrkota...
> There are two computers, PC1 and PC2. On PC1 I started QueryAnalyzer and
> selected a database on PC2 using Windows authentication and executed the
> following query:
>
> select * from PC1.Database1.dbo.Table1
>
> I got this error:
>
> Server: Msg 18452, Level 14, State 1, Line 2
> Login failed for user '(null)'. Reason: Not associated with a trusted
> SQL Server connection.
>
> Both servers are set to mixed mode authentication and both are linked
> using sp_addlinkedserver. Does anybody have a solution to this issue?
>
> --
> Best regards,
> Vladimir.

Vladimir Svrkota  wrote:
> There are two computers, PC1 and PC2. On PC1 I started QueryAnalyzer and
> selected a database on PC2 using Windows authentication and executed the
> following query:
>
> select * from PC1.Database1.dbo.Table1
>
> I got this error:
>
> Server: Msg 18452, Level 14, State 1, Line 2
> Login failed for user '(null)'. Reason: Not associated with a trusted
> SQL Server connection.
>
> Both servers are set to mixed mode authentication and both are linked
> using sp_addlinkedserver. Does anybody have a solution to this issue?
>

Hi

You most likely need to specify a login that can access the remote
server. If you don't specify anything, the server will try to connect
using your NT login which requires that the both servers is set to
delegation.
Try to look up  sp_addlinkedsrvlogin
 in BOL - that will give you more info.

--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator

"Steen Schlüter Persson (DK)" wrote:

> Try to look up  sp_addlinkedsrvlogin
 in BOL - that will give you more info.

Thanks. I'll take a look.

--
Best regards,
Vladimir.