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

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

  1. 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

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>