Re: Clickonce and license question question

moedman said:
We have an application that we are using Clickonce to install on client
computers. Once the application is installed, the user runs the application
and is required to register the application with a license key that was
e-mailed to the user along with the ClickOnce link. The registration process
updates the SQL server at our ISP that the license key is now in use. We are
having problems with some of our corporate users who have strict firewalls.
They are unable to register the application and they get an SQL error. We
switched the registration so that it now uses a webservice instead of
directly linking to the SQL server but we are still having problems with some
corporate users / firewalls. I am wondering if there is a better way?

Basically, we want to limit each user to 1 installation per license key and
we want to document when the license key has been used. The application is
updated very often, so we also keep track of which version the users have
installed. The added problem is that everytime we have an update, the user
basically re-registers the application with the new version.

I would appreciate any suggestions that could make the process simpler for
both the users and our team.

What about just meaking the company open their firewall for the server?
Then the client cann report directly to the server where the CO-Setup
is located and the server can communicate with your SQL server. This
way the client computers are still limited by the company's firewall
and the server could use a special firwall rule opening just the SQL or
webservice port just for your server. That's basically how we try to
meet all the security rules of our clients' systems.

Cheers,
Udo
.

Relevant Pages

  • Re: Local instances being used for all linked (remote) instances
    ... Try registring the server using the IP and port number instead of the DNS ... Wayne Snyder, MCDBA, SQL Server MVP ... > In enterprise manager on SRV1 you can register remote default instances ... local SRV1 system or if the password is different, it can't register it. ...
    (microsoft.public.sqlserver.server)
  • Re: Clickonce and license question question
    ... would prefer to change the way we license / register the application. ... updates the SQL server at our ISP that the license key is now in use. ... What about just meaking the company open their firewall for the server? ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Re: transactional replication failed
    ... Because my TEST server is not for test only (sometimes it is in use to run ... Stop SQL server, ... Run script to register dll files ... SQL server agent - success ...
    (microsoft.public.sqlserver.replication)
  • Re: sp_OACreate simple question
    ... your .ocx is usable as a COM server. ... There's usually no harm in attempting to register an .ocx with regsvr32 even ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: computer browser service wont start
    ... I've noticed that dnsApi is sometimes one of the things that starts early before everything it needs is actually working, e.g. the TCP/IP and network stack. ... In the situations I've seen the Event Log entry from dnsApi that you report, the computer did successfully register itself later. ... This assumes that the targetted DNS server can accept Dynamic registrations and the computer doing the dynamic registration is permitted to do so. ...
    (microsoft.public.windows.server.general)