<div>
You must change it to Mixed Authentication and this requires a SQL Service restart:<br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/ms188670.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms188670.aspx</a>
</div>


You must change it to Mixed Authentication and this requires a SQL Service restart:

http://msdn.microsoft.com/en-us/library/ms188670.aspx [http://msdn.microsoft.com/en-us/library/ms188670.aspx]

<div>
right click on the server properties,<br />
go to-&gt; security tab-&gt; select windows and mixed suthentication mode
</div>


right click on the server properties,
go to-> security tab-> select windows and mixed suthentication mode

<div>
<div class="content wysiwyg-content">
We are receiving a message &quot;Login failed for user ''. &nbsp;Reason: An attempt to logon using SQL authentication failed. &nbsp;Server is configured for Windows authentication only. [Client: &lt;local machine.] &nbsp; <br />
<br />
But when I look at the SQL Server security properties the radio button is on SQL server and Windows authentication mode. &nbsp;Also, I can interactively logon to SQL using SQL authentication. &nbsp;<br />
<br />
I think the message is being generated by SAP Business One because I get an application hang message with a similar time stamp. &nbsp;<br />
<br />
Any thoughts?
</div>
</div>


We are receiving a message "Login failed for user ''.  Reason: An attempt to logon using SQL authentication failed.  Server is configured for Windows authentication only. [Client: <local machine.]   

But when I look at the SQL Server security properties the radio button is on SQL server and Windows authentication mode.  Also, I can interactively logon to SQL using SQL authentication.  

I think the message is being generated by SAP Business One because I get an application hang message with a similar time stamp.  

Any thoughts?

SQL Server Authentication Mode

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.