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:
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:
go sql server configuration manager , see instances installed - should show 2 sql server express instances, , instance names:
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
Post a Comment