Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ShorePatrol
Starting Member
4 Posts |
 Posted - 2012-12-17 : 14:46:31
|
| Folks, We had a pretty bad situation - everytime I would log onto the SQL 2008 server (I'm a domain admin) I'd be OK for a few minutes, and then it would blue screen. This started happening out of the blue (pun intended), with no Windows updates or changes...this also happens if I RDP to it with this profile. We quickly realized other profiles/users were fine...so I could log on with a domain service account I use for other things, and it would not crash. So the plan became to remove the old profile, recreate it, and hope for the best... HERE'S THE PROBLEM: I've copied the SSIS packages from the old profile location to the new profile. SSIS will open the project file, but when I try to open the package, I get errors "Failed to decrypt protected XML node DTS:Password Key not valid for use in specified state" Is there a way (if so how) I can open these packages while logged on as a different user than who created them??? At this point I still have the old profile, but afraid to use it since it crashes the server.Any advice REALLY appreciated! Thanks! |
|
|
nelsont
Starting Member
25 Posts |
Posted - 2012-12-28 : 11:15:44
|
| Before you open the project, Go to Tools --> Options --> Business Intelligence Designers --> Integration Service DesignersUncheck the "Check digital signature" box.Hope this fixes it. |
 |
|
|
ShorePatrol
Starting Member
4 Posts |
Posted - 2013-01-02 : 10:07:07
|
quote:
Originally posted by nelsont
Before you open the project, Go to Tools --> Options --> Business Intelligence Designers --> Integration Service DesignersUncheck the "Check digital signature" box.Hope this fixes it.
Thanks! I tried it, but this is the error I get:Error loading Package.dtsx: Failed to decrypt protected XML node "DTS:Password" 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.I'm assuming this is due to the passwords in the connection manager...?Not sure how to fix this since I can no longer use the login that was used to create the packages....Is it as simple as re-creating the connections for the package? I guess that's my next thing to try.... |
|
|
|
|
|
|
|
|
SSIS package not working with different profile