NW Business Intelligence

thoughts on technology, B.I., and more…

SQL Server mixed mode security

Posted by Brad Greene on June 26, 2011

Getting the “Microsoft SQL Server: Error 18456″ when trying to log into your SQL Server database after upgrading to 2008 R2 perhaps? Happened to me. I’d been using Windows Authentication since upgrading to 2008 R2 but then needed to utilize SQL Server Authentication after installing Cognos 10. I spent a little while scratching my head wondering why none of my SQL accounts worked and all I got  was the previously mentioned error.

I presume the default installation sets the Server to Windows Authentication only or I picked it during the upgrade and don’t remember. You have to set it to mixed mode by going into the Server properties. See screen shot below. These settings are under the Security page.

Sorry, the comment form is closed at this time.