Getting the AdministrationServer property

Hello there,

I was wondering if it was possible to get the AdministrationServer property of a database without getting it through the ACL. Administration property of a database.

As a matter of fact, we need a manager access (correct me if I’m wrong) to get this property. I’d like a means to get it without being manager (I need a particular server to retrieve the AdministrationServer property from every single database available at a time, and this server is not manager for any other servers).

I don’t see the point in asking for a manager access. Is it such a vital information that we need a manager access to get it ? Or is it because the ACL class has lots of sensible properties … ?

Anyway, any hints to get a workaround would be appreciated !!!

Thanks by advance,

Kindly,

Mathieu Redzioch

Subject: Getting the AdministrationServer property

You don’t have to be Manager in a DB to get this property through the ACL, but if you want to run a scheduled agent, that accesses other servers, then you need to set the server to be trusted by the other servers. You do this in the server document (of all other servers), Security tab, Server access section, Trusted servers field.

You can’t get this information from anywhere else, since it is kept within the ACL.

Update: You do need some kind of access to the DB, like Reader/Author.

/Peter