• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 421
  • Last Modified:

ADP question

I have an ADP file that is connected to an MSSQL server. I want to move this ADP file to a different pc where this same MSSQL exist with the same files, etc. but the Name of the MSSQL server is different. Is there away I can easly just change the name of the MSSQL server so that this ADP will work there?
1 Solution
This is probably not a good answer ( requires excessive maintence in future) but yo could as a quick fix install sql client tools and in the SQl server client network utility add an alias, use the old server name and point it at the new server.

To do it more professionally have a look at http://support.microsoft.com/?kbid=306881
adp server can be changed easily...just goto file/connection and repoint to the new server...

note that this doesn't have any effect on any hard coded dsn's (ie: you are using dsn-less connections and connection strings at runtime)...you can do a project wide search and replace for these...

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now