Problem Moving To New Servers
Problem reported by Ben Santiardo - October 12 at 11:38 AM
Resolved
I am doing a test run of a move of our ST to new servers. I've restored the DB to a new SQL Server, and I have restored the Website files to a new IIS Server. I went into the ".../App_Data/Config" folder and deleted the SystemSettings.xml file, which according to the directions on the ST site, should cause the DB Connection Wizard to run again, so I can point it to the new DB Server.

Well ... When attempting to run the website I get the following error:

Unhandled error
 - Page: [http://REDACTED/default.aspx]
 - Referrer: []
 - User Agent: [Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.100 Safari/537.36] - IP: [REDACTED]
Invalid connection string
System.Exception: Invalid connection string
   at SmarterTrack.Data.ConnectionString.Parse(String connString)
   at #wQc.#18n.CreateTasks(List`1 #oOi)
   at SmarterTrack.Data.DatabaseUpgrade.#8Wc()
   at SmarterTrack.Data.DatabaseUpgrade..cctor()


ST: 14.0.6743.14154
OS: Windows 2016
DB: SQL Server 2016
IIS: 10.0

According to the System Requirements page, I should be fine.

Anyone have any ideas what is wrong?
____________________________________
Ben Santiardo, Programmer Analyst
Eastern Suffolk BOCES

2 Replies

Reply to Thread
0
Eric McCarthy Replied
Employee Post
It sounds like your SmarterTrack instance was running when you deleted the SystemSettings.xml file. I suggest trying to restart the app pool after deleting the file.
Eric McCarthy
Software Developer
SmarterTools Inc.
(877) 357-6278
www.smartertools.com
0
Ben Santiardo Replied
Marked As Resolution
I ended up doing a "fresh" install of ST, then I "stopped" the website & application pool. Then I copied the APP_DATA folder from my old installation and removed the SystemSettings.xml file. Finally, I started the application pool and website and navigated to it. I was able to then select the new database correctly.

Thanks for your time and help!
____________________________________
Ben Santiardo, Programmer Analyst
Eastern Suffolk BOCES

Reply to Thread