1

I am using SqlServer 2008 R2 express edition. Is it possible to run SqlServer without windows authentication mode?

Improve this question
3
  • I think you can only choose between "Windows authentication only" and "Mixed mode". At least that's what the manual says: msdn.microsoft.com/en-us/library/ms144284%28v=sql.90%29.aspx Commented Jun 11, 2013 at 14:26
  • Why do you want to? Why do you need this? As gbn correctly states, you cannot run without Windows authentication, but there may be another way to acheive what you need. Commented Jun 11, 2013 at 14:26
  • I would not like to give windows users to access sqlserver database. Commented Jun 11, 2013 at 14:34

3 Answers 3

Reset to default
3

No, you always have Windows Authentication.
The only option is whether you want SQL Server mode as well or not

Guessing at the reason for this, see Securing SQL Server database from Domain Admin for some tips on locking down a SQL Server installation

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

Comments

0

Yes, connect to server under Windows authentication , click Properties -> Security -> choose SQL Server and Windows authentication mode

Improve this answer

3 Comments

OP is asking "without windows authentication mode"
Is it possible to run only SqlServer mode?
without windows authentication mode means Sql Server Mode, or I'm not right?
0

Without Windows mode you can directly access on server where your database is located using your id and password.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.