|
Home > Archive > MS SQL Server > December 2006 > Login failed for user '(null)'...
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Login failed for user '(null)'...
|
|
| Vladimir Svrkota 2006-12-12, 7:12 pm |
| 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.
| |
| Uri Dimant 2006-12-13, 5:18 am |
| 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
| |
| Vladimir Svrkota 2006-12-13, 7:12 pm |
| "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.
|
|
|
|
|