Error message While Exporting Data and Replication

By Chris Miller on 23 August 2000 | 0 Comments | 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.

rocketscientist.

Discuss this article: 0 Comments so far. Print this Article.

If you like this article you can sign up for our weekly newsletter. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

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

SQL Server Replication (0 Replies)

LOGIN PROBLEMS (3 Replies)

How to update a data record when defined as money. (3 Replies)

Transfer Encrypted data Between 2 servers (0 Replies)

Commit Frequency Vs DBCC SHRINKLOG FILE (11 Replies)

Testing for Archival process (1 Reply)

BCp Error (0 Replies)

SQL server features (6 Replies)

Subscribe to SQLTeam.com

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers.

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -