hi,
We have sql2k sp4 prod.
Need a sql login to run master.xp_cmdshell..
That user muct be sysadmin. could we have a non-sysadmin sql user to run
the
master.xp_cmdshell.
Is that Proxy acct must be a windows user? A sql user would be ok. if yes.
what kind of impact that I would have by using sql proxy acct instead
sysadmin for a sql user?
Re: Security Update for SQL Server 2000 Service Pack 4 (KB948110) fail ... The patch installation uses the SQL SA user, which has sysadmin... My SQL Server 2000 installation is the MSDE version bundled into ... see if your Windows user ID has SQL sysadmin privileges.... (microsoft.public.windowsupdate)
Re: Full-Text options disabled in management console ... Looking for a SQL Server replication book?... I am a sysadmin in all cases and I am an admin on the computers. ... right click on the database "New Full-Text Catalog is grayed out/disabled. ... (microsoft.public.sqlserver.fulltext)
Re: sa privileges and roles ... If you have access to the sp_OA* procedures, you can execute any code you ...SQL server's machine. ... That's why you have to be sysadmin to use them - because you physically ... > "Only members of the sysadmin fixed server role can execute ... (microsoft.public.sqlserver.programming)
Re: Jobs big problems...I cant run them! ... Is SQL SA (Server Agent) Running? ... right click on it and select Display Error Log see if the reason why your ... > 2) I have created a new SQL user that I made sysadmin,... (microsoft.public.sqlserver.security)
Re: SQL2005 Evaluation Edition ReInstall ... Are there any logins that are members of the sysadmin role?... What about the service accounts - are they running under ... appears that no one can log in as a SysAdmin to SQL I need to find a solution. ... Is there anyway to resolve this situation short of reinstalling SQL?... (microsoft.public.sqlserver.setup)
