How to Change Windows authentication to Mixed mode in MSSQL

September 24, 2010 by 1 Comment

The easiest method is using SQL Server Management Studio Express.

The supported method is to use SQL Server Management Studio Express.
Download it from the web at

http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

1. Then connect to your server.
2. In Object Explorer, right-click the server, and then click Properties.
3. On the Security page, select SQL Server and Windows Authentication mode.
4. Restart the SQL Server service.

Please follow and like us:
RSS
Follow by Email
Facebook
fb-share-icon
Twitter
Tweet

Related posts:

Default ThumbnailHow to install Active Directory on Windows Server 2008 Default ThumbnailHow to Change the Reply-To Address in Microsoft Outlook 2007 Default ThumbnailEnableing passive mode in FTP server with CSF firewall Default ThumbnailConfiguring/Adding multiple ips in windows using netsh command
Filed Under: System Administration, Windows Tagged With: , , ,
About shk

shk is a DevOps engineer with more than 12 years of experience in different organizations. He enthusiastic about learning new technologies and shares his knowledge through his blogs.

Comments

  1. shiv says
    July 30, 2011 at 3:38 pm

    thanks a lot man

    have a Great day

    Reply

Comment Policy:

Your words are your own, so be nice and helpful if you can. Please, only use your real name, not your business name or keywords. Using business name or keywords instead of your real name will lead to the comment being deleted. Anonymous commenting is not allowed either. Limit the amount of links submitted in your comment. We accept clean XHTML in comments, but don't overdo it please.

Tell us what you're thinking...

All comments are moderated.

* Denotes required field.

*

CAPTCHA

*

Previous Post:
Next Post: