Page 1 of 1

Upgrade to 3.5 with database on a separate server?

Posted: Wed 26 Oct 2016 20:33
by mwhitney
Hello,
Can you provide guidance for upgrading Review Assistant to version 3.5 with the SQL Server database on a separate server? I would like to put the database on our SQL Server box, which runs SQL Server 2012 and uses Windows Authentication. If we run the Devart Review Assistant service as a domain service account which has db_owner access to the database, will this give Review Assistant users the access they need?

Thank you,
Mary

Re: Upgrade to 3.5 with database on a separate server?

Posted: Mon 31 Oct 2016 19:23
by mwhitney
I tried that and it looks like it worked. I also added the service account to the Administrators group on the server where Review Assistant runs.

I followed this blog post to create a connection string--I just had to remove the "Provider=..." portion. https://blogs.msdn.microsoft.com/stever ... ty-easily/

Mary