Display SQL Server Login Mode-技术开发JavaScript技术-Ubuntu系统_Ubuntu服务器

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技术：Display SQL Server Login Mode，转载需保留来源！

郑重声明：本文版权归原作者所有，转载文章仅为传播更多信息之目的，如作者信息标记有误，请第一时间联系我们修改或删除，多谢。

相关文章阅读