Display SQL Server Login Mode

ttx9n · 发表于 2007-6-21 00:00:00

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

溪谷小兵 · 发表于 2022-8-13 14:25:52

来看看怎么样

额呵呵 · 发表于 2022-12-3 22:26:46

天天源码社区www.tiantianym.com

6q8s6p21 · 发表于 2022-12-21 15:39:12

天天源码社区。。。。

rveqwdpw5 · 发表于 2023-2-2 17:29:52

hi哦回复iOS就看见

lba36h7g · 发表于 2023-3-7 14:32:41

我要金豆金豆金豆

bp5jgbcnt · 发表于 2023-6-2 05:29:38

好东西可以可以可以可以

额呵呵 · 发表于 2023-6-25 23:08:25

老大你好你好好你好

gc4hg · 发表于 2023-11-4 06:46:20

问问问企鹅哇哇哇哇哇

e8hwl6prw · 发表于 2024-3-13 03:43:30

还不错啊

账号		自动登录	找回密码
密码			立即注册

[JavaScript] Display SQL Server Login Mode

相关帖子