my database filename is crystal.mdf, I tried adding logins with the help from this link VB.net and SQL Server 2005 Setting up Database password for standalone app
I can login using sql server authentication using a password and username.
The problem is, I CAN open the database using windows authentication. This will allow the user (if the user is a techie guy and would like to dig things up) to change the values on the database, which might give errors to my application..
I don't want the users to open the database using windows authentication for security purposes, because I will deploy the application on a different place.
To summarize,
I want to disable windows authentication (is this even possible?) If not, how can I, atleast make the database secure that the user won't be able to open it via windows authentication?
EDIT
Answer from different forum
You can disable the Windows Authenticated User by : Security Tab --> logins --> Right click on that login -> Properties -> status ->Enable/Disable -> click Disable
OR
ALTER LOGIN [Domain\username] DISABLE
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With