Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
thusi
Starting Member
25 Posts |
 Posted - 2009-04-18 : 20:38:41
|
| Hi GuysThis is my requirement. I have some 'proprietary' (well, not really, but can't make them available to everyone at the moment) SQL queries which I access through C#. I want to make the C# code available as a DLL so that others can use it to build an application. I also want to make the sql server DB files available with a password cos for the C# code to work, it's going to need the DB. My intention is to make the DB available with a password, so that someone can download the DB, and set the directory/path to it via a setter in the DLL.Question is, can you do this? As far as I understand it, you need the DB attached to the instance of SQL Server instance that's running on the machine, but if I have a password on the DB, someone else can't attach it without the password. Here http://www.worldofasp.net/tut/AttachDatabase/Attach_Database_in_SQL_Server_programatically_using_Csharp_321.aspx I see some code to programatically attach a DB, but is this my only option?Thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-04-18 : 21:46:41
|
| Why not just use encrypted stored procedures? It will keep your code safe and you don't need any special security. |
 |
|
|
|
|
|
Accessing SQL Server with a password using C#