• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 195
  • Last Modified:

.Net Database files, can they be locked?

I have just started learning on my own, about ASP .NET and VB .NET databases.

I am wondering if the database itself could be somehow locked on the server?

For example if a remote user tried to access the database files itself, is there a password or something that can be setup.

Can this password be bypassed if they are accessing directly?

What is the password to the database is lost, is all the data lost?
0
polkadot
Asked:
polkadot
  • 3
  • 3
1 Solution
 
polkadotAuthor Commented:
Also, what are good resources online or text book, that I can read to learn more about the questions I'm asking.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Are you using an Access database? There are no ".NET databases", but instead your .NET program would connect to an external database.

If you're using an Access db, then you can set a Database Password. Using Access, open the database and click Tools - Security - Database Password.
0
 
polkadotAuthor Commented:
I'm not really sure what kind of database, but I guess I'm thinking of whatever is standard to be used in a C# .NET application on a  SQL Server
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
First order of business would be to determine exactly what type of database you're dealing with.

SQL Server is a database engine, and that's typically the default db used with .NET apps ... if that's the case, then unless your user has a username/password to the DB server they can't get to it.

0
 
polkadotAuthor Commented:
So the server is password protected, but not the database itself?

Is there a way to password protect just the database, not the server?
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Again - it would depend entirely on what database engine you're using ... you can password protect a Jet database (which is the default engine used by Access), but AFAIK you cannot password protect a single SQL Server database.

With SQL Server, users must be able to login to the server in order to view the information ... and there really is no "design view" on a Server unless your users are running Enterpriser Manager, or some 3rd part software that would allow them to view the design and such.

Note that SQL Server can be set to allow Windows Authentication, which would basically allow any Windows user account to log into the the server. You could, however, further protect your individual database in that scenario by adding User/Pass authentication ....

I'd urge you to first determine exactly what database you're dealing with, then read up on the basics of that environment.

0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now