Unable to connect SQL Server 2014 Express -
i running visual studio web express 2013 sql server 2014 express. recently, finished installing sql server , tried create model connecting sql server. received message :
a network-related or instance-specific error occurred while establishing connection sql server. server not found or not accessible. verify instance name correct , sql server configured allow remote connections. (provider: named pipes provide, error:40 - not open connection sql server)
the time installed still can see server name under data connection > add connection in visual studio message appeared , no database in list shown. later, don't know did, can't see server name in same dialog.
a list of installation here:
does know going on , how can fix it?
first need check name of local server. can know going in sql server configuration manager n see name of server there.
see in picture name of server sqlexpress
login .\[sqlexpress]
if there no server available need install again.
Comments
Post a Comment