Protect Data and Schema SQL SERVER 2005 EXPRESS

We have a commercial VB.NET winforms client/server application that utilizes SQL Server 2005 express edition. The schema and data that the application utilizes is proprietary and could be very damaging if it got into a competitors hands.

Is there any way to protect the data and schema of a sql server 2005 express edition database?

Will this functionality ever be added?

Thanks

As long as youhand over the database to someone, he will have full control over the database, attaching it to its own server and reading the schema from the database. What you can do is to encrypt data as well as stored procedures with certificates. But the schema won′t be hideable as the database will be given to the other party.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.desql

Prompt for user credentials for database

Hello friends,

In my web application I have saved my connection string into web.config file. Now I have to send this web application to the client in the form of web set up. The issue is that on the client side, user credentials for the database will be different. So can we do some setings that the web application whenever will run should ask for the server name, username & Password. If this can be done then the application can be run anywhere considering all compatibilities.

Please let me know how this can be done.

Thanks & Regards
Girish Nehte

Hi,

We also encounter same issue...we have done following things...

we have stored IP,Database Name,userid and password ( separated by "," ) in notepad file and saved it at some common location.

and in applications we are referring this information to access database...

and we are telling client to put these details in file...so user can not make any other changes in web.config by mistake.

|||

Hi there,

Maybe I didn't understand well what's your problem, but it seems quite simple to me.

You only have one connection string (or user of the database). Then you have, for example, a table with many usernames/passwords you like.

When your client uses the applicaction, you ask for credentials right? Then you use your connection string, to check if its credentials match with any stored on the passwords table! If so you allow him to continue. If not, you don't allow the client to continue.

Hope it helped out :) And its safer than having it written on a text file!

gonzzas

programaticaly create subscriptions

i have one report which is common to many clients say [a..n] and many more could be added. the report for each client needs to be saved to a unc path. how do i programatically create a subscription for each client to run the same report and save to its unique unc path i.e one path for each client.

You can create subscriptions programatically using the Report Server SOAP API. You can find more information here: http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.createsubscription.aspx

Concerning delivery, you can create a data-driven subscription to deliver reports customized to each user. These can be sent via email, or you could use a fileshare delivery and expose them via a virtual directory.

Thanks, Jon

programaticaly create subscriptions

i have one report which is common to many clients say [a..n] and many more could be added. the report for each client needs to be saved to a unc path. how do i programatically create a subscription for each client to run the same report and save to its unique unc path i.e one path for each client.

Have you looked into Data Driven Subscriptions?|||http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rswork/htm/rms_subscribing_v1_11sy.asp

Programatically setting the sub-report to load

My system uses a variety of invoice templates for each client, so 'Bank A' would have one invoice type sent to it, and 'Bank B' would have another etc. Each invoice template is a report, and they can vary quite substantially.

Each month the accounts team need to print out all the invoices for a month. I would like to create a report which has the invoices as a sub-report, so they can all be exported together and printed together.

However each sub-report could obviously be a different invoice-template. I notice that the sub-report selector field is one of the only fields that doesn't take an expression. Is there a way to programatically set which sub-report is used? The parameter sent to each report type is always the same (the primary key of the invoice to report on).

Any ideas? Or any other methods which would achieve the same goals?

Thanks,

Paul

One way is to add all subreport-types you could ever need to your report and hide all but the one you need dynamically via the hidden-expression..|||

Yes I could see that working, but it is pretty messy. As I would like the facility to just add extra invoice-template reports at any time. But with your method I'd have to also modify the main list report.

Thanks for your help anyway :)