EM

[wireless200]

Can I give EM to a customer for his use to interface with a remotely
located sql server if both are legal? If no, does he need to purchase
sql server to have use of a legal copy of EM?

[Chandra]

Hi
For licensing issues, please refer this

http://chanduas.blogspot.com/2005/05...nsing-faq.html
best Regards,
Chandra
http://groups.msn.com/SQLResource/
http://chanduas.blogspot.com/
---------------------------------------

*** Sent via Developersdex http://www.developersdex.com ***

[David Portas]

Unless you are using MSDE the customer has to be covered by a licence
(either CAL or processor licence) in order to use SQL Server whether he
has EM or not. If the customer is licensed he's entitled to install the
client tools, including EM.

If it's MSDE then you cannot use EM but there are EM replacement
utilities available for MSDE.

--
David Portas
SQL Server MVP
--

[wireless200]

David Portas wrote:

Unless you are using MSDE the customer has to be covered by a licence
(either CAL or processor licence) in order to use SQL Server whether he
has EM or not.
Sorry it wasn't clear, but in my case, sql server is on my remote
website. So, as an analogy, when you access Amazon.com to buy a book
or whatever, a customer doesn't need a database license to do that.
The customer doesn't see the database, all he sees is the web front
end.

However, I would like the customer to be able to load some large
amounts of data himself and I may not be able to set up a share
effectively on my website to let DTS load these
ftp'ed-to-my-website-files.
If the customer is licensed he's entitled to install the
client tools, including EM.

Basically what I'm hearing here is if the customer doesn't have a sql
server license then under no conditions can he legally install EM (to
set up DTS data trasfers).

[David Portas]

> Sorry it wasn't clear, but in my case, sql server is on my remote

website. So, as an analogy, when you access Amazon.com to buy a book
or whatever, a customer doesn't need a database license to do that.

If your site is publicly accessible over the internet that case you
must have a *Processor* licence. A processor licence is required for
any public web-site that utilizes SQL Server. If you have a Processor
licence then in theory remote users ARE licensed to install the client
tools. However, you won't be able to do this over public networks
because the ports used by SQL will be blocked by your firewall and/or
your ISP or your customer's ISP. To do this you'll need a VPN in place
between you and the customer. In that case though, a better option is
probably remote access via Terminal Server or similar because EM
doesn't behave well over a low-bandwidth network.

--
David Portas
SQL Server MVP
--

[David Portas]

Just for clarification. If your site is not a public one and you are
not using a processor licence, you can still install EM at the
customer. In that case you would have to have some mechanism to
restrict access to the site (such as VPN). You would also need to
purchase a CAL for the customer, but that applies whether or not they
are using EM because any access to the database server must be covered
by a licence.

That's my understanding but refer to the licensing docs or to Microsoft
for the definitive answers.

--
David Portas
SQL Server MVP
--