Re: Clickonce and license question question

Udo,

Thanks for your response.

I would like to keep our application as seemless as possible. Having them
configure their firewall for my application is too much of a hassle. My
application isn't really business critical. If they have to jump through too
many hoops to get it working, they will probably just not use / buy it. I
would prefer to change the way we license / register the application. We
think that the webservice might solve a lot of these problems, but I want to
be sure that there isn't a better way that we have overlooked.

Thanks,
John


"Udo Nesshoever" wrote:

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: IS IT SAFE TO HOST SQL SERVER AND IIS SERVER ON THE SAME MACHINE
    ... > safe to host a web application on a mchine outside of our firewall ... and the sql server would reside on this one machine. ... The vulnerabilities of Windows, IIS and SQL are well known, so you ...
    (microsoft.public.inetserver.iis.security)
  • Re: Connection error from VBScript
    ... The only firewall we use is Windows Firewall and that is disabled by default ... -2147467259 from MS OLE DB Provider, Specified SQL Server not found. ... you only need TCP/IP connectivity and TCP port 1433 to ...
    (microsoft.public.data.ado)
  • Re: Replication over a firewall
    ... inbound access is required to pull the updates from the server. ... Most projects I've done where the firewall admin won't open a port ... for replication use a VPN to get around it. ... make sure you're running sql server and sql server agent under an ...
    (microsoft.public.sqlserver.ce)
  • Re: Clickonce and license question question
    ... updates the SQL server at our ISP that the license key is now in use. ... They are unable to register the application and they get an SQL error. ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Re: SQL Server 2000 behind ZoneAlarm Pro 4
    ... >it is creating a log file which is not manageable. ... ZoneAlarm is not really the best thing to protect a server. ... should have a hardware firewall for better ... allow SQL Server to access Trusted, and act as server for Trusted ...
    (comp.security.firewalls)