DTS Wizard will not import/export between SQL Server Databases 
Author Message
 DTS Wizard will not import/export between SQL Server Databases

I am trying to import/export data from one SQL Server 7 database to another.  One
server is Windows 2000 Advanced Server, the other is Windows 2000 Professional.  
I can successfully use the Wizard between Pro databases, but not between Pro and
Advanced Server.

Each time I use the DTS Wizard, I receive this error:
"The license agreement for the installation of Microsoft SQL Server on your
source and destination connections does not permit the use DTS to transform
data.  Refer to your license agreement for more information."

What can explain this problem?
Chris



Sun, 27 Apr 2003 03:00:00 GMT
 DTS Wizard will not import/export between SQL Server Databases

Chris,

You have to be running the Adv server machine in Per Seat licensing mode. This is a
licensing limitation that MS put in.

--
Tibor Karaszi, SQL Server MVP
Please reply to the newsgroup only, not by email.
FAQ at: http://www.sqlserverfaq.com


I am trying to import/export data from one SQL Server 7 database to another.  One
server is Windows 2000 Advanced Server, the other is Windows 2000 Professional.
I can successfully use the Wizard between Pro databases, but not between Pro and
Advanced Server.

Each time I use the DTS Wizard, I receive this error:
"The license agreement for the installation of Microsoft SQL Server on your
source and destination connections does not permit the use DTS to transform
data.  Refer to your license agreement for more information."

What can explain this problem?
Chris



Mon, 28 Apr 2003 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Importing text files into SQL Server 2000 Database using DTS Import/Export Wizard

2. Access 2000 to SQL Server 2000 using Import/Export Wizard or DTS

3. DTS Import/Export Wizard Error:GetSourcesRowset post SQL worm infection and SP2 SQL srvr upgrade

4. Importing SAS dataset via DTS Import/Export Wizard

5. DTS Export/Import Wizards: Server 7.0 to Desktop 7.0

6. dts error while importing or exporting a database between 2 SQL 7.0 Server

7. how can I import and export DTS package and SQL Server Agent between SQL Server Groups

8. SQL Server Upgrade Wizard Fails During Import/Export

9. DTS Import/Export Wizard Error

10. An import/export DTS wizard Problem

11. DTS Import/export wizard error

12. DTS Import/Export Wizard


 
Powered by phpBB® Forum Software