SQL security setting/type

[SMO6]

I'm setting up an SMS server and I'm stuck on the step that asks for the SQL server security setting. Setup wants me to specify whether the SQL security is 'mixed' or 'integrated'. How does one verify the security setting of the SQL server?

 

[nigelrivett]

You can use enterprise manager and lok at server properties, SERVERPROPERTY(IsIntegratedSecurityOnly) or the registry.


======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[SMO6]

I've been to the security tab inside of the server properties and seen the two choices but neither of them are 'mixed' or 'integrated'. It would be nice if they tried a terminology standard. I didn't want to assume anything and just pick one. Is it safe to assume the following?

'SQL Server and Windows' = mixed
'Windows Only' = integrated

Please post a reply to correct or verify. Thx. Happy New Year!

 

[SMO6]

The actual question that setup is asking is:

Do you want SMS to use integrated security when accessing SQL server? Yes/No

Default set to No.

At the bottom of the window there is a blurb concerging the security setting:

If you choose to use integrated security when accessing the SQL server, the server must have already been setup to use mixed or integrated security.