Re: Can't created a linked server on a named instance to default insta
- From: "Uri Dimant" <urid@xxxxxxxxxxx>
- Date: Wed, 31 May 2006 14:32:30 +0300
Byron
Does the instance have Windows Authentication?
"Byron" <Byron@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CB90A676-83FF-41CC-9C04-221920F998FF@xxxxxxxxxxxxxxxx
I have been trying to create a linked server on a named instance to a
default
instance using intergrated security. It seems to work fine from a default
instance to any other SQL instance, including a named instance, but any
time
I create the linked server on the named instance a call to the linked
server
fails with the error:
Msg 18452, Level 14, State 1, Line 1
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
All servers are running SQL Server 2000 and the only difference in the
installation besides the fact one is named, is that the named instance is
SP4
and all others are SP3.
From a default instance the following works fine:
sp_addlinkedserver 'ORDEV01'
ORDEV01.Master.dbo.sp_helpdb
and the following to a named instance works as well:
sp_addlinkedserver 'LOU\Master'
[LOU\Master].Master.dbo.sp_helpdb
But if I try to created a linked server on the name dinstance LOU\Master I
get the error:
Msg 18452, Level 14, State 1, Line 1
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
Thanks in advance for any help.
.
- Prev by Date: Re: SQL 2005 Express-Database does not have a valid owner?
- Next by Date: Deny select to "everyone" except object owner
- Previous by thread: do not display system views - connection via Excel
- Next by thread: Deny select to "everyone" except object owner
- Index(es):
Relevant Pages
|
|
