Re: Cannot Generate SSPI context, Running Jobs in SQL Server 2005



Hi

Thanks for the reply

SQL Server does reside on my Computer.

The Steps on the Job gives the following errors

DTSRun: Loading... Error: -2147467259 (80004005); Provider
Error: 0 (0) Error string: Cannot generate SSPI context
Error source: Microsoft OLE DB Provider for SQL Server Help
file: Help context: 0. Process Exit Code 1. The step
failed.


Regards
Que
.



Relevant Pages

  • Re: connection failed
    ... "Cannot generate SSPI context" error message when you try to connect ... to an instance of SQL Server 2000 SP3" ... >same tables from my laptop using Windows XP, ... >I've deleted and recreated the ODBC data source on this computer, ...
    (microsoft.public.data.odbc)
  • Cannot generate SSPI Context error
    ... I have a recurring problem with the "Cannot generate SSPI context" error. ... SQL Server is MSDE, client logging on with NT security, SQL Server is ... installed on the same physical server as the domain controller (only one ... Client is XP PRO, same problem with SP2 or without SP2 ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2000 Server odbc connection broken after 10-20 minutes
    ... common causes of the "Cannont Generate SSPI Context" error message: ... > or if the box is idle for awhile it cannot connect to the SQL server or it ... > Connection Failed ... > Cannont Generate SSPI Context ...
    (microsoft.public.sqlserver.connect)
  • Using Execute SQL Task to insert rows
    ... They're both on the same connection. ... "Error Source: Microsoft OLE DB Provider for SQL Server' ... Here's my SQL statement: ...
    (microsoft.public.sqlserver.dts)
  • Re: SSPI Context problem
    ... 269541 Missing Windows NT LM Security Support Provider registry key causes ... "Cannot Generate SSPI Context" error message when you connect to SQL Server ...
    (microsoft.public.sqlserver.programming)