sql server - Upgrading SQL Management from Express 2012 to Enterprise 2016 -


i migrating webappserver sql2012express sql2016enterprise. have installed windows server 2016 iis10 current iis db connection string

"data source=.\sqlexpress;integrated security=sspi;attachdbfilename=|datadirectory|aspnetdb.mdf;user instance=true"

this on windows 2008 , iis 7 sql 2012 express.

now on new webappserver source no longer sqlexpress since sql enterprise not express. instance name sql2012 changed sql2016 in software's web.config , iis not able connect software database.

here current db string on current webappserver.enter image description here

my sql management studio enter image description here

on new server iss db connection string same express? enter image description here

and sql studio properties enter image description here

my connection string in mvc app web.config file

i hope giving enough information me on challenge facing.

this first time migrating sql server , sure have create instance correctly. connection string site on iis

data source=.\sql2016;integrated security=true;app=worldwide;initial catalog=worldwide

any very, appreciate it.

thank you.


Comments

Popular posts from this blog

java - UnknownEntityTypeException: Unable to locate persister (Hibernate 5.0) -

python - ValueError: empty vocabulary; perhaps the documents only contain stop words -

ubuntu - collect2: fatal error: ld terminated with signal 9 [Killed] -