[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Permission to run dbcc traceon in sql2005

Posted on 2006-05-11
3
Medium Priority
?
1,705 Views
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.
Thanks
0
Comment
Question by:shayne23d
  • 2
3 Comments
 
LVL 20

Expert Comment

by:Sirees
ID: 16662010
To run DBCC Traceon you requires membership in the sysadmin fixed
server role.
0
 
LVL 20

Accepted Solution

by:
Sirees earned 2000 total points
ID: 16662026
0
 

Author Comment

by:shayne23d
ID: 16662505
I was hoping there was another fix to the problem.
Thanks for the quick answer
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

834 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