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.
Could really use some resolution here.