Okay right now I have a Macola installed on my SQL Server with Terminal Services. Users run the app via Terminal Services.
Macola has probably 9 or 10 companies setup, I don't have the exact number off hand.
So the new setup is as follows
I think this part should be fairly simple?
Server 1 Roughly half the companies - SQL/Terminal Services/Macola
Server 2 Other half of companies - SQL/Terminal Services/Macola
Here's my real question
Server 3 - Server containing all companies from both servers.
The trick here is the companies are spread across 2 SQL instances.
That's the way SQL mirroring works so I have no choice.
Can I configure the Macola client to be able to login spread across 2 sql instances?
If not I can just virtualize a second server if I really need to.
Each server would containing a single instance.
Macola has probably 9 or 10 companies setup, I don't have the exact number off hand.
So the new setup is as follows
I think this part should be fairly simple?
Server 1 Roughly half the companies - SQL/Terminal Services/Macola
Server 2 Other half of companies - SQL/Terminal Services/Macola
Here's my real question
Server 3 - Server containing all companies from both servers.
The trick here is the companies are spread across 2 SQL instances.
That's the way SQL mirroring works so I have no choice.
Can I configure the Macola client to be able to login spread across 2 sql instances?
If not I can just virtualize a second server if I really need to.
Each server would containing a single instance.