SQL 2005 Express Security

[rpicilli]

Dear friends.

This is my very first post here. I'm facing a little problem that already take from me 4 days and no success at all.

My problem: I need to deploy a application but I want nobody be able to "see" the database tables from my application and I want to installl a instance of sql flawlessly to the end user.

I though to deploy with my application an instance SQL 2005 Express installation. Here starts my first problem. I can configure in the setup generated by vs2005 the SQL 2005 as required. I use an instance called MYDOC. If the customer PC does not have a SQL 20005 installed, my setup will work properly otherwise not.

I have so many problems that I'm little confuse.

If samebody could help me I apriciate that.

These are my needs:


1 - Install a new instance of sql 2005 server
2 - grant right only to my application to see the tables.

Regards

Rogerio

[OuTCasT]

If you are talking about building a setup for your application so that you can load it on users machines with a copy of sql server 2005 then you should add a setup project to your current project. Do the neccesary changes to the setup project like application installation path and prerequisites, remember to include SQL server in your prerequesites for your setup project and that it should be installed from the location of your installation folder.

The application will be installed on the users machine and so will sql server. Only your application will be able to write/read to the database.

Your connectionstring will have to be pointing to the ./local instance.

Server=(local);Data Source=.\SQLEXPRESS;Initial Catalog=[dbName];Integrated Security=True;Pooling=False")

i hope that helps