SQL Server 7.0 on NT Server to SQL Server 7.0 on win2k Pro 
Author Message
 SQL Server 7.0 on NT Server to SQL Server 7.0 on win2k Pro
I'm trying to import a SQL Server database from a NT Server to a SQL Server
on a win2k Pro.

I'm using DTS Wizard to do this, but i always get this message:

"The license for the installation of MS SQL Server on you source and
destination connections does not permit the use DTS to transform data. Refer
to your license agreement for more information"

I also tried to import or export other databases beetween SQL Server on win
NT workstation and win Nt Server and I get the same error.

Please help!!

Lus Pinho



Sat, 29 Mar 2003 03:00:00 GMT
 SQL Server 7.0 on NT Server to SQL Server 7.0 on win2k Pro

Luis,

Q.  I'm getting the following error with SQL 7 DTS - "The license for the
installation of Microsoft SQL Server on your source and destinations
connections does not permit the use of DTS to transform data.  Refer to your
license for more information."

A.  In the small print on the license agreement it says you can't do
distributed operations (distributed query, replication, DTS) between SQL Server
Desktop and Standard/Enterprise version if the Standard/Enterprise version is
installed in "per server" mode.

Switch the SQL Server to "per seat" mode via the licensing applet in control
panel, and ensure that you have a Client Access License for each computer on
which you have installed the Desktop Edition.

===

v1.01 2000.04.22
Applies to SQL Server versions  : 7.0
FAQ Categories                  : DTS, Troubleshooting
Related FAQ articles            : n/a
Related Microsoft Kb articles   : Q207809 "INF: DTS/Replication Licensing for
Desktop SQL Server 7.0"
Other related information       : "SQL Server 7.0 Databases on the Desktop" in
Books Online 7
Authors                         : Neil Pike

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 Reply here - no email
 SQL FAQ (484 entries) see
 http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
 (faqxxx.zip in lib 7)
 or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
 or www.sqlserverfaq.com
 or www.mssqlserver.com/faq



Sun, 30 Mar 2003 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. SQL Server 7.0 on NT Server to SQL Server 7.0 on win2k Pro

2. SQL Server 7.0 on NT Server to SQL Server 7.0 on win2k Pro

3. SQL Server 7.0 on NT Server to SQL Server 7.0 on win2k Pro

4. I can not connect SQL server 7.0 using SQL server 7.0 client

5. SQL Server 7.0 and SQL Server Agent 7.0 cluster ressources don′t showup

6. SQL Server 7.0 and SQL Server Agent 7.0 cluster ressources don′t showup

7. SQL Server 7.0 and Win2k Pro

8. SQL Server 7.0 and Win2k Pro

9. SQL Server 7.0 and Win2k Pro

10. SQL Server 7.0 and Win2k Pro

11. Backup/restore from SQL 7.0 Server to SQL 7.0 SP1 Server

12. SQL Server 7.0 and Win2k Pro


 
Powered by phpBB® Forum Software