Error:"Use Encryption for Data is not supported"

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.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Error:"Use Encryption for Data is not supported"

Author

Topic

mk_garg20
Constraint Violating Yak Guru

343 Posts

Posted - 2004-07-29 : 20:26:32

Hi All,
I have a DTS package which is transferring data from excel file to a table in database. I am getting error "Use Encryption for Data is not supported". Please help me how i can solve this problem. I guess it is something with configuration.

MS-Excel 97
SQL server 7.0

Thanks
Manoj

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2004-07-29 : 20:36:56

Are you using passwords on your Excel file?

mk_garg20
Constraint Violating Yak Guru

343 Posts

Posted - 2004-07-29 : 20:51:04

Nope!

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-07-29 : 21:02:21

Check your SQL Server Client Network Utility on the client and server and the SQL Server Network Utility and make sure they don't have the Force Protocol Encryption checked.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

mk_garg20
Constraint Violating Yak Guru

343 Posts

Posted - 2004-07-29 : 22:00:19

Thanks Derrickleggett!
I checked that. Force Protocol Encryption is not checked.

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-07-29 : 22:08:58

Set up a textfile on that box. See if you get the same error reading from that.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

mk_garg20
Constraint Violating Yak Guru

343 Posts

Posted - 2004-07-29 : 22:15:19

Derrick,
I can see "Force Protocol Encryption" in client network utility on production server. Look like it is hidden for me. Can we control these for users based on their roles.

I used test server, Registered Production server on this server and confirmed "Force Protocol Encryption" is unchecked. It is executing successfully.

Thanks for your response.
------------------
Another Question:-
On my system, i registered production sql server.
When i try to open that package i get an error "System could not find specified file". I can not understand why i can not open it.

Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources