DTS and "Per User Mode" Problem

• Barkingdog

  SSCoach

  Points: 18670

  More actions

  February 15, 2002 at 11:00 am

  #104774

  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.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  February 15, 2002 at 2:24 pm

  #423965

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

  Steve Jones

  steve@dkranch.net