By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,419 Members | 1,584 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,419 IT Pros & Developers. It's quick & easy.

SQL 2005 Express Security

P: 77
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.


Aug 31 '08 #1
Share this Question
Share on Google+
1 Reply

P: 374
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.

Expand|Select|Wrap|Line Numbers
  1. Server=(local);Data Source=.\SQLEXPRESS;Initial Catalog=[dbName];Integrated Security=True;Pooling=False")

i hope that helps
Oct 9 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.