Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C#4.0
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 19-Dec-12 7:53am
Edited 19-Dec-12 8:26am
v4
Comments
Member 9581488 at 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.
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

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
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

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.
  Permalink  

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

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Sergey Alexandrovich Kryukov 457
1 sanket saxena 345
2 thatraja 240
3 CPallini 215
4 OriginalGriff 195
0 Sergey Alexandrovich Kryukov 8,809
1 OriginalGriff 5,025
2 Peter Leow 3,839
3 Maciej Los 3,535
4 Abhinav S 3,118


Advertise | Privacy | Mobile
Web01 | 2.8.140415.2 | Last Updated 19 Dec 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Use
Layout: fixed | fluid