Very Computer

by **Maryam Teimouria** » Thu, 22 May 2003 18:50:18

Hi
I have a user in Windows that is member of administrator.
My user in SQL Server is not System Administrator and
should work Windows authenticate .This user can't do
anything that needs Administrator permission.It's very
strange.
What else should I do in Windows that my user can run
statements with administrator permission without being
System Administrator in SQL Server?
Thank you

by **Dan Guzma** » Thu, 22 May 2003 21:13:22

Quote:> What else should I do in Windows that my user can run
> statements with administrator permission without being
> System Administrator in SQL Server?

I'm not sure I understand what you are trying to do here. Some SQL
statements can only be run by a sysadmin role members. Perhaps you can
provide details on exactly what you want to accomplish.

You can add a login to the sysadmin fixed server role in SQL Server so
that the user has full permissions in SQL Server regardless of Windows
account permissions.

--
Hope this helps.

Dan Guzman
SQL Server MVP

-----------------------
SQL FAQ links (courtesy Neil Pike):

http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------

Quote:> Hi
> I have a user in Windows that is member of administrator.
> My user in SQL Server is not System Administrator and
> should work Windows authenticate .This user can't do
> anything that needs Administrator permission.It's very
> strange.
> What else should I do in Windows that my user can run
> statements with administrator permission without being
> System Administrator in SQL Server?
> Thank you

Very Computer

windows authentication

windows authentication

windows authentication