Securing SQL server from .Net IDE?

[zeroradius]

Hey guys,

I have a SQL database that is bound to sevral C# forms. The database will be put on users computer when they install my software. It will be holding sensitive information and I need to take precautions to make sure that only my program can access the data. I can do a login to my program to secure it, so all i need to know is how to secure a service based database from within .Net . I looked on the web and did not find anything useful, I also looked in a few books but again came up short. If you could point me in the right direction I would appreciate it.

Thanks
~ Zero

[WingedPanther]

You may need to clarify what you mean. Ultimately, if the users know the credentials to access the database, they can potentially get a SQL client pointed at it and go to town. If the access credentials are hard-coded into the app, then they are limited to what the app will let them do.

[zeroradius]

I don't want an external source to be able to copy the database and open it with some program that reads DB's and get the users sensitive data. So I want to know if there is a way to secure the DB or maybe have it Hide the DB file so that you don't see it unless you have show hidden selected for the folder?

[WingedPanther]

Are you using Windows authentication or username/password for the credentials? Is it behind a firewall? Is it part of an intranet or on the internet? etc. etc. etc.