Just for anyone who wants to use NT Authentication for SQL Server checks,
this is how we have SA setup.
The service is running under a domain user account.
We have ODBC DSN's setup to use Windows Security for each of the
databases we want to check.
Then we use the ODBC query add-on to execute a stored procedure in
the database.
The domain user account has very limited access and can only execute
that procedure.
It's a bit of a drag having to setup the DSN's, but at least we can now check two servers that only accept Windows Authenticated logins.
It's a bit of a drag having to setup the DSN's, but at least we can now check two servers that only accept Windows Authenticated logins.
Thanks
Phillip Carter
Ph: +61 3 9235 1691
IMPORTANT DISCLAIMER - THIS MAY AFFECT YOUR LEGAL RIGHTS: Because this document has been prepared without consideration of any specific clients investment objectives, financial situation or needs, a Bell Potter Securities Limited investment adviser should be consulted before any investment decision is made. While this document is based on the information from sources which are considered reliable, Bell Potter Securities Limited, its directors, employees and consultants do not represent, warrant or guarantee, expressly or impliedly, that the information contained in this document is complete or accurate. Nor does Bell Potter Securities Limited accept any responsibility to inform you of any matter that subsequently comes to its notice, which may affect any of the information contained in this document. |
This document is a private communication to clients and is not intended for public circulation or for the use of any third party, without the prior approval of Bell Potter Securities. Disclosure of Interest: Bell Potter Securities Limited receives commission from dealing in securities and its authorised representatives, or introducers of business, may directly share in this commission. Bell Potter Securities and its associates may hold shares in the companies recommended. Bell Potter Securities Limited ABN 25 006 390 772 AFS Licence No. 243480 |