We help IT Professionals succeed at work.
Get Started

Multiple Users In MS SQL Server CE 3.5

Last Modified: 2013-11-26
I've been Googling this for a couple of days now and still can't find the answer to my question, so I figured, who better to ask than the Experts?  ;-)

Anyway, I'm developing a couple of projects (under VB.NET) where I'm strongly considering using MS SQL Server Compact Edition 3.5 as the database backend.  So far, it's seemed perfect for my needs - lightweight, tiny footprint, fast, database creation on the fly - but there's one thing I can't seem to figure out for some reason.  Perhaps I'm just dense and this is a totally moronic question, but here goes anyway:

All of the documentation I've read so far indicates that this version of SQL Server CE is capable of multi-user support, however there's no mention of any form of actual login credentials associated with the DB itself.  Sure, it talks about security and permissions taken from the current Windows user login, but I was really kinda wanting to setup multiple user "accounts" for accessing the database.  Not that revolutionary a concept in most any DBMS out there, including a lot of the smaller ones, but nothing I've found so far seems to give me any hope that this little bad boy is going to do that.

From what I can tell from the documentation, this "multi-user" support is more of a "multiple simultaneous connections" support, enabling more than one user to connect to the database at the same time.  The problem?  I'd like to be able to assign each user their own unique password to the database, but with this structure, that doesn't seem to be possible unless I either a) leave the database itself unencrypted, or b) hard-code the database password into the application, then have the actual user's login credentials stored in a table I create myself.

Maybe I've overlooked something, and perhaps I'll have to simply create multiple, separate and individual database files for each user - which I don't suppose would be too awful - but I'd at least like to know I tried all I could think of to get my "desired" goals.

Thank you, Experts!  I look forward to what you all have to say.
Watch Question
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE