<div>
Sorry for abandoning this. &nbsp;(It was actually asked by my daughter.) &nbsp;Please split points as you proposed and close.<br />
<br />
Thanks, all.
</div>


Sorry for abandoning this.  (It was actually asked by my daughter.)  Please split points as you proposed and close.

Thanks, all.

<div>
<div class="content wysiwyg-content">
I've checked all the ODBC connections to this server and they all tested fine.. and this error only happens randomly.. and its really aggravating.
</div>
</div>


I've checked all the ODBC connections to this server and they all tested fine.. and this error only happens randomly.. and its really aggravating.

Microsoft SQL Server Login- Connedction failed- SQL State: &quot;s1000&quot;- [Microsoft][ODBC SQL Server Driver] Cannot generate SSPI context

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

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.

Microsoft SQL Server Login- Connedction failed- SQL State: &quot;s1000&quot;- [Microsoft][ODBC SQL Server Driver] Cannot generate SSPI context

Microsoft SQL Server Login- Connedction failed- SQL State: "s1000"- [Microsoft][ODBC SQL Server Driver] Cannot generate SSPI context