shayne23d
asked on
Permission to run dbcc traceon in sql2005
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I was hoping there was another fix to the problem.
Thanks for the quick answer
Thanks for the quick answer
server role.