Very Computer

by **JWebe** » Thu, 23 Sep 1999 04:00:00

I am trying to do a transfer with DTS from DB2 to SQL Server from a client
workstation and am getting an error which is "CANNOT GENERATE SSPI CONTEXT.
This will not happen when I am at the server. It only happens when trying
this from the client workstation.
Does anyone have any ideas or has anyone run into this before?
I am running SQL 7 and NT 4 w/sp5. I am using DB2 Connect v5.

Thanks Jim

by **Neil Pik** » Sat, 25 Sep 1999 04:00:00

Jim - what is the client running? Win9x? This is an issue with the client not
being able to check the NT credentials for the link

Quote:> I am trying to do a transfer with DTS from DB2 to SQL Server from a client
> workstation and am getting an error which is "CANNOT GENERATE SSPI CONTEXT.
> This will not happen when I am at the server. It only happens when trying
> this from the client workstation.
> Does anyone have any ideas or has anyone run into this before?
> I am running SQL 7 and NT 4 w/sp5. I am using DB2 Connect v5.

Neil Pike MVP/MCSE. Protech Computing Ltd
(Please reply only to newsgroups)
For SQL FAQ entries see

or www.ntfaq.com/sql.html (+ ntfaq download)
or http://www.swynk.com/faq/sql/sqlserverfaq.asp
or http://www.sql-server.co.uk

by **JWebe** » Sat, 25 Sep 1999 04:00:00

Windows 95

>Jim - what is the client running? Win9x? This is an issue with the client
not
>being able to check the NT credentials for the link

>> I am trying to do a transfer with DTS from DB2 to SQL Server from a
client
>> workstation and am getting an error which is "CANNOT GENERATE SSPI
CONTEXT.
>> This will not happen when I am at the server. It only happens when
trying
>> this from the client workstation.
>> Does anyone have any ideas or has anyone run into this before?
>> I am running SQL 7 and NT 4 w/sp5. I am using DB2 Connect v5.

> Neil Pike MVP/MCSE. Protech Computing Ltd
> (Please reply only to newsgroups)
> For SQL FAQ entries see

> or www.ntfaq.com/sql.html (+ ntfaq download)
> or http://www.swynk.com/faq/sql/sqlserverfaq.asp
> or http://www.sql-server.co.uk

by **Neil Pik** » Sun, 26 Sep 1999 04:00:00

Make sure that MS Client Networking is installed.

Neil Pike MVP/MCSE. Protech Computing Ltd
(Please reply only to newsgroups)
For SQL FAQ entries see

or www.ntfaq.com/sql.html (+ ntfaq download)
or http://www.swynk.com/faq/sql/sqlserverfaq.asp
or http://www.sql-server.co.uk

Very Computer

SSPI Error w/DTS transfer

SSPI Error w/DTS transfer

SSPI Error w/DTS transfer

SSPI Error w/DTS transfer

SSPI Error w/DTS transfer