Upgrade to 3.5 with database on a separate server?

Discussion of open issues, suggestions and bugs regarding code review tool for Visual Studio – Review Assistant
Post Reply
mwhitney
Posts: 2
Joined: Wed 26 Oct 2016 19:34

Upgrade to 3.5 with database on a separate server?

Post by 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?

Post by 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/stever ... ty-easily/

Mary

Post Reply