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

Published Fri, Jul 6 2007 17:39 by Martin Poon
Filed under: , ,

Comments

# Enders said on 07 August, 2007 08:21 AM

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