This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Authentication change from Windows Authentication to SQLServer Authentication

zozonw-ml over 6 years ago

Hello,

I have three questions about Spotlight.

First, I use Spotlight for monitoring SQLServer. And now my authentication is windows authentication.

I want to change my authentication to SQLServer Authentication.

I want to know is there any influence when I change connection details setting.

Second, I am concerned about sysadmin authority needed for gathering data on Spotlight .

Does Spotlight only collect data? It never affect on my SQLServer? (for example, insert or update any data.)

Third, I want to know what data does Spotlight collect and where does Spotlight store such data.

I would appreciate it if someone tell me. Or some documentation url abount questions are also welcome.