Hardening sql server - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

Hardening sql server

Author

Topic

lorellana
Starting Member

25 Posts

Posted - 2011-09-22 : 16:15:06

Can you tell me, how disable access to the following extended stored procedures in SQL Server 2008?:

xp_availablemedia
xp_dirtree
xp_dsninfo
xp_enumdsn
xp_enumerrorlogs
xp_enumgroups
xp_eventlog
xp_fixeddrives
xp_getfiledetails
xp_getnetname
xp_logevent
xp_loginconfig
xp_msver
xp_readerrorlog
xp_servicecontrol
xp_sprintf
xp_sscanf
xp_subdirs
xp_regaddmultistring
xp_regdeletekey
xp_regdeletevalue
xp_regenumvalues
xp_regremovemultistring
xp_regwrite

Thanks you for your help.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-09-22 : 16:42:10

You mean besides not giving out sysadmin?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

lorellana
Starting Member

25 Posts

Posted - 2011-09-22 : 17:18:32

I want to know how disable extended stored procedures for all roles, whether public or sysadmin in SQL Server 2008.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources