467,915 Members | 1,230 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,915 developers. It's quick & easy.

SQL 2005 Express Security

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
  • viewed: 1026
1 Reply
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.

Similar topics

1 post views Thread by Darryl Kerkeslager | last post: by
4 posts views Thread by BravesCharm | last post: by
8 posts views Thread by Phil Lee | last post: by
6 posts views Thread by | last post: by
3 posts views Thread by Arpan | last post: by
10 posts views Thread by =?Utf-8?B?UHVuaXQgS2F1cg==?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.