We updated a server to 2005 this weekend got the problem with DBCC TRACEON(20 and excel 200? Do need to give sysadmin rights to user to run excel or are the any kb, or any other way to solve the problem for the users.

"User 'public' does not have permission to run DBCC TRACEON"

Check it is sql 2005 change issue...

Check the following may help you...
How do you connect sql 2005 using excel? via ODBC?

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=322312&SiteID=1


MohammedU.
Moderator
SQL-Server-Performance.com

All postings are provided “AS IS” with no warranties for accuracy.

The applications in the organisation were recorded macros, out of the it departments control . To solve the problem with made search and replace APP=#%92Microsoft® Query#%92 to APP=#%92#%92. Updated excel.

Thanks for sharing the solution...


MohammedU.
Moderator
SQL-Server-Performance.com

All postings are provided “AS IS” with no warranties for accuracy.