I am running SQL 7.0 Desktop server on Win2k Prof. When I
use DTS to import data from another sql server, it says
License does not permit DTS function.

Can anyone say how to get it to work?

Thanks,
Murali

Murali -

I have had to deal with this in the past, myself, when I was
telecommuting to work from my home then, in Montana. I wrote VBScript
to utilize Database.Transfer objects from SQL-DMO. It is not too
tough, but takes a tiny bit more head scratching than the DTS EXPORT
WIZARD.

HTH - Best Regards, Lee Gillie - Spokane, WA

"Murali" <smurali (AT) att (DOT) net> wrote

I found this looking for an answer to one of my own problems just
now...

This is from SQL Server 7.0 END-USER LICENSE AGREEMENT:

Note Regarding Interaction between Microsoft SQL Server and
Microsoft Data Engine ("MSDE").
If you use MSDE to access or use the services of Microsoft
SQL Server (for example, replication, data transformation or
heterogeneous query services), you must use Microsoft SQL Server in
Per Seat Mode (that is, each unique Device accessing SQL Server must
have a Client Access License dedicated to it).

Note Regarding Use of SQL Server Desktop.
You may only install and use the SQL Server Desktop component of
Microsoft SQL Server on each Device to which a valid Client Access
License for the Server Software has been dedicated. If you use
SQL Server Desktop to access or use the services of any version
of Microsoft SQL Server (for example, replication, data
transformation or heterogeneous query services), you must use
such Microsoft SQL Server in Per Seat Mode.

Put simply your SQL Server is in Per Server licensing mode, which means you
are not entitled to install the Desktop edition. since DTS can detect this
it will not work since it isn't licensed. This is sometimes a bit
restrictive as you may have multiple servers, one in per seat, and one in
per server mode, so you can be covered by a per seat CAL, but you still get
the restriction on the other server. Thankfully this was removed in SQL
2000.


--
Darren Green
http://www.sqldts.com


"Murali" <smurali (AT) att (DOT) net> wrote