cancel
Showing results for 
Search instead for 
Did you mean: 

Multi SQL Environment w EV Reporting

Scott__Hastings
Level 5
Partner Accredited Certified

I am deploying EV in an environment w 4 SQL Servers. One server will have Directory, Auditing, Monitoring, One will have DA Databases. and the other 2 will have Vault Store Databases and FP Databases.

My question.. Do I have to install SQL/EV Reporting and point to all 4 SQL Servers, or does the Auditing, Monitoring, Directory know where to get DA and Vault Store data, thus just needing SQL/EV Reporting installed on the one server.

 

Thanks for any guidance.

Scott D Hastings Sr
1 ACCEPTED SOLUTION

Accepted Solutions

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

sql reporting only needs to be installed on one server and the EV reports deployed to that SSRS instance. it will get all the references it needs to the other databases from the EV Directory Database

View solution in original post

2 REPLIES 2

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

sql reporting only needs to be installed on one server and the EV reports deployed to that SSRS instance. it will get all the references it needs to the other databases from the EV Directory Database

Scott__Hastings
Level 5
Partner Accredited Certified

Thank you most kindly sir!

Scott D Hastings Sr