Update from SQL Server 2012 Express to SQL Server 2014 Express -


(newbie alert - have used sql server extension of visual studio).

i'm trying management studio 2014 (ssms) , visual studio 2013 use sql server 2014 express instead of sql server 2012 express.

they both appear installed:

enter image description here

when start ssms , login selecting mypc\sqlexpress, resulting server =

  mypc\sqlexpress (sql server 11.0.5343 - mypc\me) 

11.0.5343 2012, best can tell.

how can ssms , vs point sql server 2014 express instead of 2012?

update: in response suggestions below, here configuration manager shows:

enter image description here

enter image description here

go sql server configuration manager , see instances installed - should show 2 sql server express instances, , instance names:

enter image description here

the instance name appears after sql server text in brackets; mssqlserver signifies default, unnamed instance, while sql server express default gets installed sqlexpress. in case, appears 2012 instance - 2014 instance must have different instance name (or possibly it's installed unnamed, default instance - in case, use . or (local) server/instance name connect it).


Comments

Popular posts from this blog

dns - How To Use Custom Nameserver On Free Cloudflare? -

python - Pygame screen.blit not working -

c# - Web API response xml language -