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
>

server, DTC, SQLOLEDB, Access, linked tables = HEADACHE!

OK, welcome to my nightmare... I got 2 SQL Servers and an Access DB Front end

SQL Server1: SQL Server 7.0 (on our network)
SQL Server2: SQL Server 2000 (remote)
AccessDB: on our network

There is a Form in the Access DB that is used by Sales & Marketing to update data in both SQL Servers and there are subqueries involved. I tried just linking the tables in Access, but the connection to the remote SQL Server keeps getting dropped within seconds of opening it regardless of whatever timeouts I set anywhere. The linked tables to the local SQL Server stay connected just fine (both DSNs on the Access machine are using TCP/IP).

So, I tried adding SQL Server2 as a Linked Server to SQL Server1, then write a distributed view object (SELECT * FROM [linkedserver].[catalog].[dbo].[table]) the table I need. Then I create a linked table in Access to the new view. Well I can SEE the data fine (SELECT), but in order to update the data, it evidently requires DTC, but since it's SQLOLEDB (all together now) "does not support distributed transactions." Yup DTC is running just fone on both SQL Servers, nope we can't upgrade the SQL Server 7.0

If anyone has ANY insight into this mess, I'm all ears.Can you call an SP to do the update?
set transact abort on gets round some transaction incorporation problems but I doubt if it would solve this.|||no, I can't do an SP in this situation. It's just MS Access updating a linked table (view). I did try to find a way to do this with an SP to employ the trasact abort thing, but it didn't apply.|||I think I'm going to X-Post this in the usenet forums. Seems to be a lot of traffic in there. I'll be a nice x-poster though, if I get an answer in one forum, i'll post it in the other.

server to Visual Foxpro .dbc database on network from sql server

Hi all,
I have Visual Foxpro 6.0 tables on network server inside a foxpro
database container .dbc. I have SQL server 7.0 on another server on the
network. I want to import the dbf files of foxpro into SQL server.
Can anybody suggest a way to do it. I created a linked server by giving the
path but I get the ODBC driver error as it cannot open the .dbc file.
Any suggestions?
Message posted via http://www.sqlmonster.com
Try DTS - you should be able to import the data that way assuming you have
the proper data driver for Foxpro
I have a visual foxpro driver in my list, but I'm not sure what version it
is.
"rameshwar elka via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:a37fe497729140acbd10a8e569c94622@.SQLMonster.c om...
> Hi all,
> I have Visual Foxpro 6.0 tables on network server inside a foxpro
> database container .dbc. I have SQL server 7.0 on another server on the
> network. I want to import the dbf files of foxpro into SQL server.
> Can anybody suggest a way to do it. I created a linked server by giving
the
> path but I get the ODBC driver error as it cannot open the .dbc file.
> Any suggestions?
> --
> Message posted via http://www.sqlmonster.com

server to Visual Foxpro .dbc database on network from sql server

Hi all,
I have Visual Foxpro 6.0 tables on network server inside a foxpro
database container .dbc. I have SQL server 7.0 on another server on the
network. I want to import the dbf files of foxpro into SQL server.
Can anybody suggest a way to do it. I created a linked server by giving the
path but I get the ODBC driver error as it cannot open the .dbc file.
Any suggestions?
--
Message posted via http://www.sqlmonster.comTry DTS - you should be able to import the data that way assuming you have
the proper data driver for Foxpro
I have a visual foxpro driver in my list, but I'm not sure what version it
is.
"rameshwar elka via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:a37fe497729140acbd10a8e569c94622@.SQLMonster.com...
> Hi all,
> I have Visual Foxpro 6.0 tables on network server inside a foxpro
> database container .dbc. I have SQL server 7.0 on another server on the
> network. I want to import the dbf files of foxpro into SQL server.
> Can anybody suggest a way to do it. I created a linked server by giving
the
> path but I get the ODBC driver error as it cannot open the .dbc file.
> Any suggestions?
> --
> Message posted via http://www.sqlmonster.com

server to Visual Foxpro .dbc database on network from sql server

Hi all,
I have Visual Foxpro 6.0 tables on network server inside a foxpro
database container .dbc. I have SQL server 7.0 on another server on the
network. I want to import the dbf files of foxpro into SQL server.
Can anybody suggest a way to do it. I created a linked server by giving the
path but I get the ODBC driver error as it cannot open the .dbc file.
Any suggestions?
Message posted via http://www.droptable.comTry DTS - you should be able to import the data that way assuming you have
the proper data driver for Foxpro
I have a visual foxpro driver in my list, but I'm not sure what version it
is.
"rameshwar elka via droptable.com" <forum@.droptable.com> wrote in message
news:a37fe497729140acbd10a8e569c94622@.SQ
droptable.com...
> Hi all,
> I have Visual Foxpro 6.0 tables on network server inside a foxpro
> database container .dbc. I have SQL server 7.0 on another server on the
> network. I want to import the dbf files of foxpro into SQL server.
> Can anybody suggest a way to do it. I created a linked server by giving
the
> path but I get the ODBC driver error as it cannot open the .dbc file.
> Any suggestions?
> --
> Message posted via http://www.droptable.com