Click here to Skip to main content
15,881,838 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi Friends...........

i want to know ,

1. Requirements needed by an application to run on my client's machine, developed on platform 4.0 in C# and database used is

Sql Server Management Studio 2008.

2. How can I protect my database. So that no one can miss use.

3. How can I add all these requirements in my application's setup


Application Type (Windows Application)

Please help......
Posted
Updated 19-Dec-12 8:26am
v4
Comments
Member 9581488 19-Dec-12 14:16pm    
If you want to run your application on diff machine. you will need IIS, that will convert your comp to work as server. From another machine you can access your application using ip address.
Google it and you will find multiple solutions.

You need .NET and SQL Server.

You can not stop people who have a database locally from accessing it. Nor should it, it's THEIR data. You can password protect it, but they have the data, they can get in.

You can create an installer that installs .NET but SQL Server is a seperate exe, and is licensed. If you use the free one, you still need to write a program that installs that, and then runs your MSI
 
Share this answer
 
If that is a stand alone application, you can have the database be housed in the application and secure that your rules when passing data into is stable then the only access is that application.

If that is public style application, then you can hard code the connection strings inside the application so only the application can communicate to the database.

Outside of that, would need to know if there are specific risks that need to be address to provide the needed security is in place.

Things to watch for when your communicating to the database is to insure your scripts are managed by the code and sql so injection won't occur.

Some of the best ways are through stored procedures and anytime you have a text field passing in data, make sure you are treating as data and not a function so users can pass through a statement to process by SQL (if that makes sense).

Hope that helps.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900