Check for mixed mode

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 1

It's stored in the registry, so you could query that... not a great option.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

rshafer SSChasing Mays Points: 655 More actions · Answer 2

Grant Fritchey (12/5/2008)
It's stored in the registry, so you could query that... not a great option.

Thanks for the tip. I did some Googling and came across this site.

The registry LoginMode DWORD is stored in:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer

2 = Mixed Mode Security

1 = Windows Authentication.

Thanks for your help Grant.