c# - Visual Studio 2013 DB creation error : a network related or instance specific error occurred while establishing connection with sqlserver -

c# - Visual Studio 2013 DB creation error : a network related or instance specific error occurred while establishing connection with sqlserver -

first of all, allow me tell have tried every damn thing googling overcome error , have not done typo error either. but, none of google results helped. allow me tell scenario... installed visual studio ultimate 2013 (and nil else, no separate sqlexpress, nothing). non-db apps working fine. but, 1 project, when tried create new database connection (by right clicking 'data connections' or clicking 'connect database' icon creating localdb), got error:

"a network-related or instance-specific error occurred while establishing connection sql server. server not found or not accessible. verify instance name right , sql server configured allow remote connections. (provider: sqlnetwork interfaces, error 26- error locating server/instance specified)"

then, usual, tried google it. of answers related sqlexpress (which didn't installed separately). 1 reply "sqlserver configuration manager" , enabling sqlservices , called surface area.... but, "sqlserver configuration manager" not there in 'all programs' on windows 8 (64x) machine, downloaded sqlexpress , sqlserver management studio too. item named "surface area manager...." not there. enabled sqlservices, tcp/ip ports. shut downwards firewall. still getting same error.

note: dont have connection string in webconfig till because going create new db. the reply editing conn string doesn't mattered me.

note: not case visual studio 2012. on vs2012 (and nil else) installation, worked fine creating dbs , other things. so, what's wrong vs2013??

server \ instance name must reachable client, creation of connection string seek verify connected ok. seek workstation:

sqlcmd -sservername\instance_or_ipaddress_of_sql_server -e -q"select @@version"

until proper server name or instance, not able create db connection.

c# asp.net sql-server windows-8 visual-studio-2013