Permission to run dbcc traceon in sql2005

Posted on 2006-05-11
Last Modified: 2007-12-19
Hi experts.
We have switched one of our servers to mssql 2005.
When people try and connect to get adata from the database with excel they are getting the error below.

      Connection failed:
      Sql state ‘3700’
      Sql server error: 2571
      [Microsoft][odbc sql driver][sql server] user ‘reporting’ does not have the permission to run dbcc treaceon

I have googled with no result, so I am turning to the pros.
Any help would be appreciated.
Question by:shayne23d
    LVL 20

    Expert Comment

    To run DBCC Traceon you requires membership in the sysadmin fixed
    server role.
    LVL 20

    Accepted Solution


    Author Comment

    I was hoping there was another fix to the problem.
    Thanks for the quick answer

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Viewers will learn how the fundamental information of how to create a table.

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now