Upon querying SQL Server 2005 using an ODBC data source in Microsoft Excel 2000…
You may encounter the following error.
Microsoft SQL Server Login
Connection failed:
SQLState: ‘37000’
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’!
Only microsoft can invent this. If the application name = msquery we put dbcc traceon.
They changed the name in 2007, copied the old name into it but didn’t got an error