linkedServer fails from client when logged-in with NT-auth sql2k c

delegation on linked server fails in our network when we use nt-authenticate
d
logins. we have sql server 2000 nodes n1,n2 on win 2003 cluster. linked
server from n1 to n2 and n2 to n1 stop working when used in a query from
clinet xp pc.
we can query individually the servers(nodes/instances) from client and from
server nodes to server instances without any error.
the error we get is " msg xxx err xx Reason: login failed for user (NULL)
....."
Any thots,hints,links,pointers appreciated
Thanks,
GAGA,
If you are using the setting where the current login on server A is supposed
to pass through to server B and if one of the servers is not properly set up
for Kerberos delegation, you will have a problem.
RLF
"DallasBlue" <DallasBlue@.discussions.microsoft.com> wrote in message
news:7405A4DD-F0A5-478F-8569-6CC3F9BE120B@.microsoft.com...
> delegation on linked server fails in our network when we use
> nt-authenticated
> logins. we have sql server 2000 nodes n1,n2 on win 2003 cluster. linked
> server from n1 to n2 and n2 to n1 stop working when used in a query from
> clinet xp pc.
> we can query individually the servers(nodes/instances) from client and
> from
> server nodes to server instances without any error.
> the error we get is " msg xxx err xx Reason: login failed for user (NULL)
> ....."
> Any thots,hints,links,pointers appreciated
> Thanks,
> GA
>

servers

Hi,

Disclaimer: I am not a DBA so my attempts may not make sense. :)

I have a win 2003 server running sql server 2005. I am trying to create a 'linked server' with an oracle 8i database at a remote site. I have tried using the 'add linked server' option from sql server enterprise manager and I have also tried to create it using the sp_addlinkedserver command. i tried using a dsn as the datasource and I have also tried using a dsnless connection using a TNS entry as the provider string. The Oracle client is on the box as can be confirmed both by the dropdown in the 'add linked server' dialog in sql server enterprise manager and also by going into the oracle enterprise manager and actually sending oracle data. I don't really have a preference on how to create the 'Linked server', I just need to get it to work.

AAA = server
BBB = DSN
XXX = UID
YYY = pwd

DSNLess Attempt:
EXEC master.dbo.sp_addlinkedserver @.server = N'TEST1', @.srvproduct=N'OraOLEDB.Oracle', @.provider=N'OraOLEDB.Oracle', @.provstr=N'SERVER=(DESCRIPTION=(ADDRESS_LIST=(ADDR ESS=(PROTOCOL=TCP)(HOST=AAA)(PORT=1556))) (CONNECT_DATA=(SERVICE_NAME=LPPCPEDB)));uid=XXX;pw d=YYY;'

DSN Attempt:
EXEC master.dbo.sp_addlinkedserver @.server = N'TEST2', @.srvproduct=N'Oracle', @.provider=N'OraOLEDB.Oracle', @.datasrc=BBB'

Thanks in Advanceyou need to do

sp_addlinkedsrvlogin|||Thank you for your response. I did add that as well, but I forgot to put it in my post. I did not have any luck. Here is the statement I used:

sp_addlinkedsrvlogin
@.rmtsrvname = N'BBB'
, @.useself = false
, @.locallogin = NULL
, @.rmtuser = N'XXX'
, @.rmtpassword = N'YYY'|||sorry...for rmtservername i meant to indicate: TEST2 instead of BBB

server to Oracle -OLE/DB Provider 'MSDAORA' IDBInitialize

Hi All
We have a WIN NT 4.0 Server with SQL 7.0 (7.00.961) Connecting to Oracle 8 DB using linked server . With Trace flag 7300 on we get an error message as follows.We are using Oracle 9 i Clien
Thank you , Shaj
DBCC execution completed. If DBCC printed error messages, contact your system administrator
Server: Msg 7399, Level 16, State 1, Line
OLE DB provider 'MSDAORA' reported an error.
[OLE/DB provider returned message: An Oracle Error occured, but message could not be determined
OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ]provide product name as oracle.give tnsname for the db
which you are trying to connect as datasource..
in the security tab give remote user.password appropriate
for the db which you are trying to connect..this will
resolve your issue
>--Original Message--
>Hi All ,
>We have a WIN NT 4.0 Server with SQL 7.0 (7.00.961)
Connecting to Oracle 8 DB using linked server . With Trace
flag 7300 on we get an error message as follows.We are
using Oracle 9 i Client
>Thank you , Shaji
>DBCC execution completed. If DBCC printed error messages,
contact your system administrator.
>Server: Msg 7399, Level 16, State 1, Line 1
>OLE DB provider 'MSDAORA' reported an error.
>[OLE/DB provider returned message: An Oracle Error
occured, but message could not be determined]
>OLE DB error trace [OLE/DB Provider 'MSDAORA'
IDBInitialize::Initialize returned 0x80004005: ].
>.
>|||We use MS OLE DB Provider for Oracle with following parameter
Product name : Oracl
Data Source : DEVP
Provider string :MSDAORA
With relevant Remote user name and Password . The issue still remain the same. :
Thank you for the fast respons
Shaj|||With it being an initialization error, you may want to make
sure the provider is registered - try registering
msdora.dll. If you get any errors, try reinstalling mdac.
You may also want to refer to the following:
HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in
SQL Server
http://support.microsoft.com/?id=280106
-Sue
On Tue, 20 Apr 2004 00:41:02 -0700, "Shaji"
<anonymous@.discussions.microsoft.com> wrote:
>We use MS OLE DB Provider for Oracle with following parameters
>Product name : Oracle
>Data Source : DEVP
>Provider string :MSDAORA
>With relevant Remote user name and Password . The issue still remain the same. :(
>Thank you for the fast response
>Shaji
>

server to Oracle -OLE/DB Provider 'MSDAORA' IDBInitialize

Hi All ,
We have a WIN NT 4.0 Server with SQL 7.0 (7.00.961) Connecting to Oracle 8 DB using linked server . With Trace flag 7300 on we get an error message as follows.We are using Oracle 9 i Client
Thank you , Shaji
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' reported an error.
[OLE/DB provider returned message: An Oracle Error occured, but message could not be determined]
OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ].
We use MS OLE DB Provider for Oracle with following parameters
Product name : Oracle
Data Source : DEVP
Provider string :MSDAORA
With relevant Remote user name and Password . The issue still remain the same.
Thank you for the fast response
Shaji
|||With it being an initialization error, you may want to make
sure the provider is registered - try registering
msdora.dll. If you get any errors, try reinstalling mdac.
You may also want to refer to the following:
HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in
SQL Server
http://support.microsoft.com/?id=280106
-Sue
On Tue, 20 Apr 2004 00:41:02 -0700, "Shaji"
<anonymous@.discussions.microsoft.com> wrote:

>We use MS OLE DB Provider for Oracle with following parameters
>Product name : Oracle
>Data Source : DEVP
>Provider string :MSDAORA
>With relevant Remote user name and Password . The issue still remain the same.
>Thank you for the fast response
>Shaji
>