Display SQL Server Login Mode

时间:2007-06-21    点击:226   
Display SQL Server Login Mode.

Supported Platforms

SQL Server 2000
 Yes


Script Code

SQLDMOSecurity_Integrated  = 1 
SQLDMOSecurity_Mixed         = 2 
SQLDMOSecurity_Normal       = 0
SQLDMOSecurity_Unknown   = 9 

strDBServerName = "."

Set objSQLServer = CreateObject("SQLDMO.SQLServer")

Select Case objSQLServer.ServerLoginMode(strDBServerName)
   Case SQLDMOSecurity_Integrated
      WScript.Echo "Login Mode: Allow Windows Authentication only."
   Case SQLDMOSecurity_Mixed
      WScript.Echo "Login Mode: Allow Windows Authentication or SQL Server Authentication."
   Case SQLDMOSecurity_Normal
      WScript.Echo "Login Mode: Allow SQL Server Authentication only."
   Case SQLDMOSecurity_Unknown
      WScript.Echo "Login Mode: Security type unknown."
End Select

Javascript注入技巧
Stop SQL Server
用jscript启动sqlserver
List all the Databases on a SQL Server
Display SQL Server Version Information
> 返回     
地址:上海市普陀区胶州路941号长久商务中心 电话: QQ:
© Copyright 2012 上海网络 Product All Rights Reserved