I figured it out. Everything worked perfect it was me. Forgot to update the DSN to the new server name. That will do it every time.
Joshua Giese
CIO
Direct: 920.593.8299
IT Dept: 920.437.6400 Ext. 337
Site ID: 27450-E905702A-SQL64
Wisconsin Converting, Inc.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, July 21, 2015 6:59 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Copy Live VM for use as Test
I think you may need to perform a drop and re-add of your SQL server. I think this link should help you.
Rename a Computer that Hosts a Stand-Alone Instance of SQL Server
Rename a Computer that Hosts a Stand-Alone Instance of SQL Server When you change the name of the computer that is running SQL Server, the new name is recognized during SQL Server startup. You do not have to run Setup again to reset the computer name. |
|||||
Preview by Yahoo |
|||||
Kind Regards
Simon Hall