Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQL Server Login Disable windows authentication

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

like image 872
Codemunkeee Avatar asked Nov 14 '13 09:11

Codemunkeee


1 Answers

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
like image 174
user30410 Avatar answered Oct 16 '22 15:10

user30410