Category Archives: 4537

Microsoft Query – ODBC data source – Error 2571 – User ‘xxxx’ does not have permission to run DBCC TRACEON

Upon querying SQL Server 2005 using an ODBC data source in Microsoft Excel 2000…

ODBC Microsoft Query Error 37000

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’!