Upgrade to 3.5 with database on a separate server?

Upgrade to 3.5 with database on a separate server?

Postby mwhitney » Wed 26 Oct 2016 20:33

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
mwhitney
 
Posts: 2
Joined: Wed 26 Oct 2016 19:34

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

Postby mwhitney » Mon 31 Oct 2016 19:23

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/steverac/2010/12/13/test-remote-sql-connectivity-easily/

Mary
mwhitney
 
Posts: 2
Joined: Wed 26 Oct 2016 19:34


Return to Review Assistant