http://msmvps.com/blogs/martinpoon/archive/tags/ODBC/default.aspxTags: ODBCenCommunityServer 2008.5 SP2 (Build: 40407.4157)http://msmvps.com/blogs/martinpoon/archive/2007/07/06/microsoft-query-odbc.aspxFri, 06 Jul 2007 08:39:00 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1004796Martin Poon1http://msmvps.com/blogs/martinpoon/rsscomments.aspx?PostID=1004796http://msmvps.com/blogs/martinpoon/commentapi.aspx?PostID=1004796http://msmvps.com/blogs/martinpoon/archive/2007/07/06/microsoft-query-odbc.aspx#comments<p><font face="trebuchet ms,geneva" size="3">Upon querying SQL Server 2005 using an ODBC data source in Microsoft Excel 2000...</font></p> <p><font face="trebuchet ms,geneva" size="3"><img title="ODBC Microsoft Query Error 37000" style="WIDTH:360px;HEIGHT:335px;" height="335" alt="ODBC Microsoft Query Error 37000" src="http://msmvps.com/photos/martinpoon/images/1004794/original.aspx" width="360" /></font></p> <p><font face="trebuchet ms,geneva" size="3">You may encounter the following&nbsp;error.&nbsp;</font></p> <p><font face="trebuchet ms,geneva" size="3">Microsoft SQL Server Login<br />Connection failed:<br />SQLState: &#39;37000&#39;<br />SQL Server Error: 2571<br />[Microsoft][ODBC SQL Server Driver][SQL Server]User &#39;xxxx&#39; does not have permission to run DBCC TRACEON.&nbsp;</font></p> <p><font face="trebuchet ms,geneva" size="3">===== Solution =====</font></p> <p><font face="trebuchet ms,geneva" size="3">To resolve this problem, you will need to change the *application name* for the ODBC connection, such that it is not &#39;Microsoft(R) Query&#39;!</font></p><div style="clear:both;"></div><img src="http://msmvps.com/aggbug.aspx?PostID=1004796" width="1" height="1">SQL ServerExcelODBC