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

Hi
What does the job do? Does the SQL Server reside on your computer?



"Que" <aq.mahomed@xxxxxxxxx> wrote in message
news:3dabde67-3b16-40ac-afd0-c5d175c34974@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi
I am Using SQL 2005 and running Jobs

I am getting the following error

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.

How can this be solved?

I am not connected to me network so this cannot be the problem as I am
using SQL Server Authentication and not Intergrated Security

Thanks in advance

Regards
Que


.

Relevant Pages

  • Programmatically create DSN usind SQL Server Authentication
    ... I am trying to programmatically create a DSN on a target system for SQL ... Server using SQL Server Authentication. ... is off-topic for my purpose because it only shows Windows authentication. ...
    (microsoft.public.sqlserver.odbc)
  • Re: Connexion to SSIS
    ... A way to verify it the account in question to the local admins and try ... If you do not want to, can use proxy accounts. ... only SQL Server authentication and use it to connect my remote client to the ... SQLServer Account by SQL Server Authentication? ...
    (microsoft.public.sqlserver.dts)
  • How to disable the Windows NT login authenticate at SQL-Server 2000 login Form ? @Thanks
    ... Use Ms SQL Server 2000, There are two way to login, The first is Windows NT ... Authentication, The second is SQL Server Authentication, If you choose ... I think the Database ...
    (microsoft.public.sqlserver.security)
  • Re: Programmatically create DSN usind SQL Server Authentication
    ... Not when you create the DSN programmatically. ... >Server using SQL Server Authentication. ... >is off-topic for my purpose because it only shows Windows authentication. ...
    (microsoft.public.sqlserver.odbc)
  • Re: Failed to login with sa
    ... > and forth between Windows Authentication and SQL Server Authentication, ... > I can't login with sa account. ... In order to login as 'sa', you need to use SQL Server Authentication. ...
    (microsoft.public.sqlserver.security)