Error for xp_blowfish dll on SQL 2005 (64bit)

  • I used the xp_blowfish dll on SQL 2005 (64bit)? We just moved to a new server and we're getting error message to the effect.

    Could not load the DLL C:\Program Files\Microsoft SQL Server\90\Tools\binn\Encryption DLL\xp_blowfishdecrypt.dll, or one of the DLLs it references. Reason: 193(C:\Program Files\Microsoft SQL Server\90\Tools\binn\Encryption DLL\xp_blowfishdecrypt.dll is not a valid Win32 application.).

  • double check the path to the xp is correct.

    Check its path on the "old" server or maybe even restore an old mastedb (to an alternate dbname !) to find out where it was pointing to.

    If you still have the old server, just copy the folder

    C:\Program Files\Microsoft SQL Server\90\Tools\binn\Encryption DLL from the old server.

    Is this a 64 bit dll ?

    If not, you should put it in the program files (86) folder structure !

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • Thanks for your info.

    The SQL 2005 is running on a 64-bit. It seems the DLL was only compiled for 32 bit.

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

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