Configuring SQL Authentication can be tricky at times, and this is a great article that goes over the two types of authentication in SQL. I find some programs interface better with direct SQL authentication when Windows Authentication fails for any reason.
Note: This article is taken from http://kb.gfi.com/articles/SkyNet_Article/How-to-configure-SQL-Server-2005-2008-to-accept-SQL-Authentication and all credit goes to them for the writing. I’m posting it here simply as a reference in case there site changes the above link.
There are 2 methods of authentication by which GFI ReportCenter can authenticate to SQL Server 2005/2008. These are:
In order to use SQL Server authentication, you must first configure your server using the steps below.
Enable SQL Server login
Once you have walked through configuring SQL authentication, you can now change your instance to the type you need.
Leave any Questions and Comments below and I will get back to you. I regularly publish on YouTube, Steemit, and christitus.com so if you’d like to see more videos and articles click the subscribe button in the top right.