I am beside myself. Sites have been down for 18 hours now. All files have been moved. All data has been moved. There seems to be some problems with my sql server connection string...it was working fine on my windows server 2008 and seems to be problematic on 2012.
Here is my 2008 connection string:
Set conn = Server.CreateObject("ADODB.Connection")
The file structure on that server was:
C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS
The file structure on my new server is:
C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER
The error highlights the conn,open line and says it can't find the instance. I tried replacing SQLExpress with SQLSERVER but that didn't help.
I don't know if many of you have made the great mistake of using the Cisco Thin Client model with the management software VXC. If you have then you are probably more then familiar with the incredibly clunky interface, the numerous work arounds, and …