Microsoft SQL server 2005 Express Security

Question

0.00/5 (No votes)

See more:

My Company supplies the MS SQL Server 2005 Express database .mdf files with their solution. Which we attach at client's computers SQL server (Doesn't have the Management studio) on first run of the application software. Now my boss wants me to lock the database so that no one can even see the database even if they install management studio on their own without the username-'sa' and password for it.
What he wants is- The database can only been seen or accessed or used by using logins for sa with exact password. Even the administrator account of client's computer or client computer's SQL server administrator cant even see the database.

Is it even possible, I have searched for it but nothing came up as promising and clear.....
Thanks in advance

How to set permission or security roles or users or logins or instance something like that for my database, so that No one have access to my database whatever authentication they passed. That means if user at client use windows authentication mydatabase shouldn't be available to him. only login using server authentication and with a selected username and password let user to access mydatabase.

Posted 26-Apr-13 4:42am

Sukanta Ghosh

Updated 26-Apr-13 20:46pm

v2

Add a Solution

Comments

Maciej Los 26-Apr-13 11:08am

What you mean: lock the database so that no one can even see the database even if they install management studio?

Sukanta Ghosh 27-Apr-13 2:28am

If an administrator (other than specified account) from Clients computer log in and suppose Client installed Management studio by their own, in server explorer they will not my database either

RedDk 26-Apr-13 13:54pm

The .mdf can't be read by a user with administrative privilege. Tough encryption. On it. The .mdf file.

Sukanta Ghosh 27-Apr-13 2:29am

how to implement it, what are the consideration regarding the implementation

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2013-04-26T05:13:00

Solution 1

All you need is to set Authentication mode[^] to: SQL Server and Windows Authentication mode.

How to change authentication mode? See this: How to: Change Server Authentication Mode[^].

Please, read about: Security Considerations for a SQL Server Installation[^] too. Follow the related links (see menu on the left side of window).

Posted 26-Apr-13 5:13am

Maciej Los

Updated 26-Apr-13 5:14am

v2

Comments

Sukanta Ghosh 27-Apr-13 2:57am

Authentication mode is for server installation. I want something that only for my database. I am not concerned about the rest of servers objects and also not at liberty to change or modify the server properties. I am seeing stars............ as of I know little about sql server specifically the admin part.