sms setup & sql security setting

[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, @#$% I don't know!! How does one verify the security setting of the SQL server?

 

[NoWittyName]

Presuming you have an SQL server, open up SQL Server Enterprise Manager, right click on your server name click properties and then click on the security tab, under authentication it will tell you whether the sql server is running in SQL Server and Windows(mixed) or just SQL server(integrated)

Master of Disaster.....Recovery

 

[Count430]

Hello:

If your not sure which mode to use, just choose one. I like
to use the integrated mode for the following reasons.

I use a dedicated SQL database with SMS which is why I use the Windows Security AKA integrated mode.

Windows Authentication, previously called integrated security, is the minimum administration overhead option for SQL Server.

This type of security maps the SMS Service account to the SQL Server database, and then it passes through the SMS Service account to SQL Server for validation and data access.

Sorry for the verbiage but it explains it in detail.