x Want to participate? Join the group to interact
Options
  • State Not Answered
  • Replies 1 reply
  • Subscribers 1 subscriber
  • Views 76 views
  • Users 0 members are here
Browse Forums
Announcements
32
topics
2
replies
General Discussion
851
topics
2k
replies
twakefield

SQL Server database mirroring

Posted By

Sorry if this is stated somewhere, but wanted to know how to configure the Sage Fixed Asset - Premier Depreciation up for SQL Server database mirroring. With most applications this is configured within the DataSource Connection String like this:
data source=IP of primary server; initial catalog=DatabaseName; User ID=SQLLoginID; Password=Passwordtext; Application Name=Sage; failover partner=IP of secondary server

  • 0
    Hello twakefield,

    We have no advice to give on SQL mirroring. We do not support SQL server and the setting up of a failover cluster which, I believe is your intent, is not some we test here. The Fixed Asset databases are not Cluster aware and keeping the Fixed Asset databases in clustered environment has caused issues in the past (connection issues, database corruption, etc.) and I have heard of customers getting this to work, but since we do not test this the affects of this is unknown.

*Community Hub is the new name for Sage City