Is it possible to password protect your SQL Server database?

Jes Sie

During my visit to a prospective client who wants me to upgrade a windows application (Rice Mill Operation) done by a certain developer whom they cannot reach anymore. When I log in to their SQL Server using the administrator account, I was amazed that he (previous developer) was able to password protect his database. I've done several googling about passwording a SQL Server database and all of them says it can't be done.

My question is, how did he do it? How to password protect a database from a SQL Server?

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jes Sie8y ago
I still get the same error Nanddeep. My MSSQL is 2014. Maybe this is not compatible. Thank you so much for extending your help. I really appreciate it.
Nanddeep Nachan8y ago
Try by specifying entire query on one line
CREATE DATABASE "\test1.SDF" DATABASEPASSWORD ''
TechNet documentation is here:
https://technet.microsoft.com/en-us/library/ms174454(v=sql.110).aspx
Jes Sie8y ago
1. Create database "RiceMill.sdf"
2. DATABASEPASSWORD ''
Nanddeep, I got an error in the password area. It says... Expecting '='

Nanddeep Nachan8y ago

Database can be password protected during creation itself.

CREATE DATABASE "secure.sdf"
DATABASEPASSWORD ''