SQL Server Login Disable windows authentication

Question

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

That's the wrong reason to disable windows authentication. Windows authentication is safer that sql server authentication. You can't fake the windows account, while the password will appear in the connection string. Besides, how will the DBA manage the database? — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Nov 14, 2013 at 9:36
thanks for your insights @ panagiotis .. the main reason why I wanted to disable that authentication is because I will install the app on another pc along with an sql server installer as well, it is like a standalone application. I don't know how to do this yet because this is my first time deploying an application to other computers.. — Codemunkeee
– Codemunkeee, Commented Nov 14, 2013 at 9:41

user30410 · Accepted Answer · 2013-11-14 12:09:02Z

10

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

edited Nov 14, 2013 at 12:09

answered Nov 14, 2013 at 9:34

user30410

1312 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user30410 Over a year ago

You can delete the particular WindowsUser login by right click and delete

Rahal · Accepted Answer · 2014-12-11 15:04:24Z

-1

At the moment you may can't do this. Backup all DBs(not into default location) and re-install SQL Server using create fresh windows user account which have admin privileges. Then you can keep your windows authentication mode loin safer by protecting the windows user account.

answered Dec 11, 2014 at 15:04

Rahal

1

Collectives™ on Stack Overflow

SQL Server Login Disable windows authentication

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related