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

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 Reply to “Microsoft Query – ODBC data source – Error 2571 – User ‘xxxx’ does not have permission to run DBCC TRACEON”

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

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

Leave a Reply Cancel reply