Error message While Exporting Data and Replication

By Chris Miller on 23 August 2000 | Tags: Replication

gaurav is having an interesting issue with replication, DTS, and (unbeknownst to him) Microsoft licensing restrictions. I've run into it before, so I thought I'd answer it because I'm sure other folks are tripping on this one too.

gaurav writes "we are building a SQl Server Centric web application, and requires replication as we do lots of offline data entry which is to be replicated to the web server. thus to emulate the same environment in the testing phase, i have changed the sa login password from security options and created a new user and databse with SETUPADMIN( as required for replication) and DBCREATOR Fixed Server Roles and DB_OWNER fixed database role. Now after creating a blank database when i connect from some other machine from network and after successful connection tries to IMPORT OR EXPORT pre fed data into the database through DTS Wizard- it gives error message saying "Licence for the installation of MS Sql Server On your source and destination does not permit the use of DTS to transform DATA.", we are using the BACKOFFICE 4.5, with SQL Server Standard Edition.

Where as if we do the same among two other machines with the desktop edition, the database Importing and exporting works fine along with replication. Does It has to do Something with "Sql Server Enterprise Edition on NT Server" Please Help us and kindly advice what all consideration and steps should we take to ensure that our site gets uploaded and replication happens, what all configuration and roles are required for the same. Thanx in advance"

This is a problem with the type of licensing you chose when you installed SQL Server. Please see this MS knowledge base article.

OK, a miniature rant here. I really really really hate it when the entire reason something isn't working is because the Microsoft licensing services are in the way. It's never managed to get in the way when I'm actually doing something that violates the license agreement (As complicated as the licenses are, everyone violates them occasionally, and you figure it out and fix it) but it always manages to get in the way when I'm doing something unrelated like trying to use DTS or install replication.


Related Articles

Replicating SQL Server 2000 across Heterogeneous Databases (24 August 2003)

Horizontal and Vertical Partitioning in Replication (30 January 2003)

Database Journal - SQL Server section (18 December 2002)

Transactional Replication Issues (14 September 2000)

Replicating Triggers (14 August 2000)

Choosing a replication type (26 July 2000)

Other Recent Forum Posts

Simple lookup and offset in sql (4h)

Calculate Moving Avg using SQL (12h)

Witness server (sqlserver2008r2 standard) on Windows 7 required to upgrade 2017 standard (12h)

Performance problem with query, (17h)

Sql server 2012 data column used for 7 different languages (23h)

How to extract only the data between the first calendar date and the date in which i make the refresh (1d)

Subtract time from 2nd row with the first (1d)

How to find a record between two dates and times (1d)

- Advertisement -