what authentication mode SQL Server is running

[fixthebug2003]

hi
is there a way to find out what authentication mode SQL Server is running..? How/where do I look up and find?

Fixthebug2003

 

[DrJavaJoe]

Goto enterprise manager and right click on the Server, immediately below the Server Group and select properties. The SQL Server properties page should appear and you can then select the Security tab.

or look in the registry
at either
HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode
or
HKLM\Software\Microsoft\Microsoft SQL Server\%InstanceName%\MSSQLServer\LoginMode

2 for Mixed Mode authentication
1 for Windows Authentication

 

[fixthebug2003]

Hi DrJavaJoe,
The Problem I am having is:
I am using MS SQl Server 7.0 version. When I open the Enterprise Manager and click on my MachineName (Under the SQL Server Group) and then click on the properties I get this message saying :
"only members of the sysadmin role can access this feature"

Now, does that mean that the NT login id with which I logged into the machine does not have the sysadmin role or does SQL Server does not recognize the NT Login ID..!

That's why I wanted to first find out when security mode is SQL Server running on.

I couldn't find the registery key, you've mentioned above !!
is there any other way?

Thanks
Fixthebug2003