Upgrading SQL Management from Express 2012 to Enterprise 2016

66 Views Asked by At

I am migrating my Webappserver from SQL2012Express to SQL2016Enterprise. for this I have installed a Windows server 2016 with IIS10 my current IIS db connection String is

"data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true"

this is on Windows 2008 and IIS 7 with SQL 2012 Express.

Now on the new webappserver my source is no longer SQLexpress since the SQL is enterprise not express. my instance name was SQL2012 I changed it to Sql2016 in my Software's web.config and IIS as well I am not able to connect my software to the Database.

Here is what my current Db String is on the current webappserver.enter image description here

My SQL management Studio is enter image description here

On the New Server My ISS db connection string is the same which is express? enter image description here

and my SQL Studio properties are enter image description here

My connection string in my MVC app web.config file is

I hope I am giving you enough information to help me on this challenge I am facing.

This is my first time migrating SQL server and I am sure I have create the instance correctly. my connection String to the site on IIS is

data source=.\SQL2016;Integrated Security=True;App=Worldwide;Initial Catalog=Worldwide

Any Help is very, very appreciate it.

Thank you.

0

There are 0 best solutions below