Login failed for user '(null)'

Question

Login failed for user '(null)'

jsqldba

SSChampion

Points: 11257
More actions
July 30, 2002 at 1:38 am

#104996

We have a job failing with the below error message. The job runs a series of DTS packages which process our cubes. The error only occurs on jobs which process cubes. Our ETL job (using DTS) and others run without error.
We somewhat recently (2 months ago) upgraded to SQL 2000 (SP2). We are running SQL and Analysis Services on the same machine. We are using Windows NT Authentication. The error also manifests itself SOMETIMES when connecting thru Enterprise Manager. It can happen for me on the server itself, and not for my collegue connecting remotely (at the same time). As usual with MS products, the problem does not occur on test or development! There are some KB articles regarding ASP or IIS and this error, but neither is the case here. It's all pure SQL, DTS, and Analysis Services.
Thanks in advance............................
Error Message:
Executed as user: SvcSQLDW. ...004005); Provider Error: 18452 (4814) Error string: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSCreateProcessTask_1 DTSRun OnError: DTSStep_DTSCreateProcessTask_1, Error = -2147220330 (80040496) Error string: CreateProcessTask 'DTSTask_DTSCreateProcessTask_1': Process returned code 1, which does not match the specified SuccessReturnCode of 0. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4900 Error Detail Records: Error: -2147220330 (80040496); Provider Error: 0 (0) Error string: CreateProcessTask 'DTSTask_... Process Exit Code 1. The step failed.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

jsqldba SSChampion Points: 11257 More actions · Answer 1

Additional info:

I did some testing today, and find that the ETL job is doing something to cuase this error. We have a 3 step jobs which does and ETL (extraction, testing, loading) for our datawarehouse, then a cube reprocessing step, followed by some housekeeping tasks.

If I stop/start the SQL and AS services, and run my cube reprocessing step. All works fine. But if I launch the ETL step, let it run to (successful) completion, and THEN launch the cube reprocessing step, it fails. So it appears as if the ETL task is doing something to cause the problem.

The ETL step does nothing with Analysis Services. Basically, it load some text files to SQL tables, reformats them, tests them for valid values and then loads them to our data warehouse. The process sends out numerous success or failure mails for each text file processed. The process complete successfully each time.

The cube reprocessing step is a series of DTS packages which call OLAP processing tasks. The first OLAP tasks always fails.

As a workaround, I can manually run the ETL,

then stop/start SQL and AS serices, then run the cube reprocessing.

mhweiss SSCarpal Tunnel Points: 4284 More actions · Answer 2

Do you have your analysis services tasks set to run on the main thread? They are written in vb and vb is not multi-threaded. Right click on the OLAP task and select workflow properties, find the "Run on main thread" checkbox and make sure it is checked. Hope this helps...

Michael

quote:
We have a job failing with the below error message. The job runs a series of DTS packages which process our cubes. The error only occurs on jobs which process cubes. Our ETL job (using DTS) and others run without error.
We somewhat recently (2 months ago) upgraded to SQL 2000 (SP2). We are running SQL and Analysis Services on the same machine. We are using Windows NT Authentication. The error also manifests itself SOMETIMES when connecting thru Enterprise Manager. It can happen for me on the server itself, and not for my collegue connecting remotely (at the same time). As usual with MS products, the problem does not occur on test or development! There are some KB articles regarding ASP or IIS and this error, but neither is the case here. It's all pure SQL, DTS, and Analysis Services.
Thanks in advance............................
Error Message:
Executed as user: SvcSQLDW. ...004005); Provider Error: 18452 (4814) Error string: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSCreateProcessTask_1 DTSRun OnError: DTSStep_DTSCreateProcessTask_1, Error = -2147220330 (80040496) Error string: CreateProcessTask 'DTSTask_DTSCreateProcessTask_1': Process returned code 1, which does not match the specified SuccessReturnCode of 0. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4900 Error Detail Records: Error: -2147220330 (80040496); Provider Error: 0 (0) Error string: CreateProcessTask 'DTSTask_... Process Exit Code 1. The step failed.

Michael Weiss

jsqldba SSChampion Points: 11257 More actions · Answer 3

I spot checked our olap tasks and it appears that they are all selected to "run on main thread". But this wouldn't have anything to do with Enterprise Manager also having a problem to connect. It's as if the security information settings is getting corrupted at some point, refusing any subsequent jobs from running. Then, a stop/start of SQL Server clears this up and it works fine afterwards.

I'm stumped!