|
Home > Archive > MS SQL Server ODBC > January 2006 > Excel DBCC Error
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Garth Keesler 2006-01-02, 7:23 am |
| Forgive me for cross-posting but this involves ODBC as well.
I'm getting "User 'Test1' does not have permission to run DBCC TRACEON."
when trying to connect Excel to SQL Server 2005 using an ODBC System
DSN. I've discovered that this is due to Excel or, more appropriately
MSQuery, attempting to set traceflag 208 having to do with quoted names.
What I haven't found out is how to correct this without granting
SysAdmin privs to users needing to run those queries.
Is there a way to do this without those privs?
Thanx,
Garth
| |
|
| I have the exact same problem. Did you find how to correct this without
granting sysadmin privs?
--
Thanks in advance.
Ade
"Garth Keesler" wrote:
> Forgive me for cross-posting but this involves ODBC as well.
>
> I'm getting "User 'Test1' does not have permission to run DBCC TRACEON."
> when trying to connect Excel to SQL Server 2005 using an ODBC System
> DSN. I've discovered that this is due to Excel or, more appropriately
> MSQuery, attempting to set traceflag 208 having to do with quoted names.
> What I haven't found out is how to correct this without granting
> SysAdmin privs to users needing to run those queries.
>
> Is there a way to do this without those privs?
>
> Thanx,
> Garth
>
>
>
>
|
|
|
|
|