DTS and "Per User Mode" Problem

  • I'm using DTS to copy a table from a SQL 7 server to the SQL 2K Personal Editon on my machine. When I try I get "The Data Transformaiton Services cannot copy or tranform data from a Desktop or MSDE Server to a Standard, Enterprise, or Small Business Server version of SQl Server unless your destination server is using per user licensing mode." (? - huh?)

    What can I do about this? It's not obvious how to change the licensing mode of the PE edition running on my desktop.

  • Not sure you can do this. I think this is a limitation of the PE.

    Steve Jones


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

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