You’re offline. This is a read only version of the page.
55
I have a GP 2015 server that I need to point to different SQL server name. Can someone guide me to the right direction?
Thanks
*This post is locked for comments
Hi Sang,
Have you thought about assigned a DNS Alias to your new GP server that would hold the name of the old one ? this way you can switch to the new server without having to redo all the ODBC definitions from your GP client workstations and you wont have to reset all the user's passwords (because that's what is going to happen if you change the server name in the ODBC connection).
Did you change the ODBC connections on the workstations to point to the new server?
That is only other place that GP looks.
Bill,
Thank you for your quick response, I did transferred data and permission to different SQL server. However, what do I need to change in GP application so it will connect to my new SQL server?
I think that this is one of the best KB's on the topic. It outlines all the steps you need to take to move the current databases for your GP installation to a new server and how to move and 'save' the passwords from old server to new server.
support.microsoft.com/.../878449
Hope this helps. If so, be sure to tell us.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (