Browse Blog Posts by Tags

All Tags » excel » ODBC (RSS)

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

SQL Server

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

Posted to Martin Poon - Microsoft MVP blog [SQL Server] by Martin Poon on Fri, Jul 6 2007
Filed under: Filed under: SQL Server, Excel, ODBC

Page 1 of 1 (1 items)

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.

Recent Posts

Tags

Browse Blog Posts by Tags

Microsoft Query - ODBC data source - Error 2571 - User 'xxxx' does not have permission to run DBCC TRACEON