Showing posts with label failed. Show all posts
Showing posts with label failed. Show all posts

Wednesday, March 28, 2012

Problem with job that run ssis pckg

Hi,

i have a job that run ssis pckgs and it failed when the server is log off with this error msg:

Executed as user: xxxxx\dwhadmin. ...0.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 9:15:00 AM Error: 2007-07-11 09:15:01.71 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTSStick out tongueassword" with error 0x80070002 "The system cannot find the file specified.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2007-07-11 09:15:26.77 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "PackagePassword" with error 0x80070002 "The system cannot find the file specified.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2007-07-11 09:15:26.77 Code: 0xC0016016 Source: Description: Faile... The package execution fa... The step failed.

what can be the problem?

thanks.

Hi Steam5,

There are already answers aviled in this forums. I got it resolved in my case. There are several ways.

One way to deploy an SSIS package into a new machine where you actually created this package is to Use "Save copy of <Your SSIS Pkg> as" on the File menu in BIDS. Use EncryptAllSensitivewithPassword option with a password. Now this package can be executed on another Box using dtexec with /De option to decrypt the password.

Thanks

Subhash Subramanyam

|||

Hi Subhash,

thanks for the reply but it's not working.

:-( .

any other idea?

|||

Hi

We get slightly different errors here with SSIS, but the step succeeds.

Description: Failed to decrypt protected XML node "DTSStick out tongueassword" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error DTExec: The package execution returned DTSER_SUCCESS (0). Started: 09:55:33 Finished: 09:55:34 Elapsed: 1.15 seconds. The package executed successfully. The step succeeded.

Have you tried hardcoding the password into the connection string in the job step? Sometimes depending on the type of connection (oracle OLDBD) the password is not deployed with the package and you need to override the connection string with the one in the job, including the password.

Hope it helps, bit of a long shot.

Cheers

Matt

Monday, March 26, 2012

Problem with installing SQL Server 2000

Help me

I am installing SQL Server 2000 on Windows 2000 and It ends up with the error showing :
"Setup failed to Configure Server. Please refer to C:\Winnt\Sqlstp.log for detail"
I checked sqlstp.log and found that
driver={sql server};server=MyServer;UID=sa;PWD=;database=....,
[Microsoft][ODBC SQL Server Driver] Connection broken

Thanks in advance.

Is that Windows 2000 server or workstation? And what edition of SQL Server are you installing?

Also - at what point in the installation is it failing?

|||

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q317328

HTH

Tuesday, March 20, 2012

Problem with Full-text searching

I am getting this error message from SQL Server when attempting any full-text
catalog operation:
Error 7619: Execution of a full-text operation failed. The parameter is
incorrect.
The service appears to be installed and running on Windows 2003 Server and
the error appears to be coming from stored procedures like
sp_fulltext_database. What do I need to check next to resolve this problem?
can you create your catalog or fulltext indexes through the wizard?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Andrew" <wanhelp@.elca.org> wrote in message
news:F9513F7D-D058-4AEB-BC18-321BB05896A7@.microsoft.com...
>I am getting this error message from SQL Server when attempting any
>full-text
> catalog operation:
> Error 7619: Execution of a full-text operation failed. The parameter is
> incorrect.
> The service appears to be installed and running on Windows 2003 Server and
> the error appears to be coming from stored procedures like
> sp_fulltext_database. What do I need to check next to resolve this
> problem?
>
|||"Hilary Cotter" wrote:

> can you create your catalog or fulltext indexes through the wizard?
No. The wizard terminates after this error message appears.
|||This appears to be windows 2000. Can do any operations through tsql, such as
creating a table.
Can you try this for me
create database fulltextest
GO
use fulltextest
GO
sp_fulltext_database 'enable'
GO
create table fulltext
(pk int not null identity constraint pk primary key,
charcol char (20))
GO
sp_fulltext_catalog 'test','create'
GO
sp_fulltext_table 'fulltext', 'create', 'test','pk'
GO
sp_fulltext_column 'fulltext','charcol','add'
GO
sp_fulltext_table 'fulltext','start_full'
GO
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Andrew" <wanhelp@.elca.org> wrote in message
news:281B3353-53E0-48CF-85B4-559B3688217F@.microsoft.com...
> "Hilary Cotter" wrote:
>
> No. The wizard terminates after this error message appears.
>
|||"Hilary Cotter" wrote:

> This appears to be windows 2000. Can do any operations through tsql, such as
> creating a table.
> Can you try this for me
> create database fulltextest
The first step that broke was the one with sp_fulltext_database 'enable'. I
worked it out with a Microsoft support engineer, though.