At the moment, we’re designing the part of the SQL Response interface that allows you to choose the servers you want to monitor. This has proved to be a complicated issue, as we require – for every SQL Server you want to monitor:
- credentials to log in to the physical Windows box
- credentials to log in to the SQL Server instance
It may be that, as a DBA, you have a single account set up that allows you access to both the physical server and the SQL Server instances on it. Or, at the other extreme, maybe each SQL Server instance has its own separate account and password, which you would need to enter separately. What is the situation in your organisation?
- Do you have to provide one set of credentials for the machine and another for the SQL Server?
- Do you have several domain accounts or just one?
- Does each instance have its own account?
- Do you use integrated security or SQL Server authentication?
- Also, do your accounts/passwords ever change? If so, how regularly??
We’re trying to develop an interface that can cater for all of these situations. So it won’t annoy you if you want to add 100 servers at once using the same credentials; neither will it annoy you if you have to enter credentials for each and every server you want to monitor. But we’d like to know how broad the spectrum of use-cases actually is, so we can meet your needs accordingly.