Setting database location to SQL Server

(0) Share

Report

Posted on by Larry Powell

100

Hello,I'm looking to move teh POS system database from the local MSDE database to a SQL server. I've restored a recent backup (.bck) to a SQL server machine on our network and I'm looking for information on how to reconnect the POS to teh new SQL server. Before we go live I will restore a new backup but I'm just testing the solution for now.The overall plan is to separate teh database from teh cash register and allow SQL server to perform backups and other normal database task. Is there a separate configuration tool for changing data connection information?Can the configuration be changed in the POS and if so I'm guessing it would be available to users with the owner’s role only?Thanks,

Larry

*This post is locked for comments

All responses (1)

Answers (0)

Ryan Wigestrand on at

Like (0)

Report

Re: Setting database location to SQL Server

Hi Larry,

This forum is for Dynamics GP posts you will want to post your question on the Retail Forum found usig the following link.

https://community.dynamics.com/forums/t/30710.aspx

Thank you

Ryan