Upon querying SQL Server 2005 using an ODBC data source in Microsoft Excel 2000…
You may encounter the following error.
Microsoft SQL Server Login
SQL Server Error: 2571
[Microsoft][ODBC SQL Server Driver][SQL Server]User ‘xxxx’ does not have permission to run DBCC TRACEON.
===== Solution =====
To resolve this problem, you will need to change the *application name* for the ODBC connection, such that it is not ‘Microsoft(R) Query’!