SQL server 2008r2 Mixed Mode Authontication

Hello:
I installed MS SQL server 2008r2 ( Full version - 180 days evaluation) with NT Authontication mode.
Now I need to have it with Mixed mode.
Is there a way to fix that post installation , how?
Do I need to reinstall?

Thank you.
noamco36Asked:
Who is Participating?
 
Jagdish DevakuConnect With a Mentor Sr DB ArchitectCommented:
Hi,

In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.

On the Security page, under Server authentication, select SQL Server and Windows authentication mode, and then click OK.

In the SQL Server Management Studio dialog box, click OK to acknowledge the requirement to restart SQL Server.

In Object Explorer, right-click your server, and then click Restart. If SQL Server Agent is running, it must also be restarted.

For more info:

http://msdn.microsoft.com/en-us/library/ms188670.aspx
0
 
noamco36Author Commented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.