asp.net - Connection error in Visual Studio -


i'm developing web application using asp.net. database on server called dataserver. database server os windows server 2003 , uses sql server 2008 r2. problem when start computer , run application first time can't connect server , shows following error:

a network-related or instance-specific error occurred while establishing connection sql server. server not found or not accessible

i open my computer , type \\dataserver on address bar of windows explorer , browse server files. after doing problem disappears.

how can fix it?

this may name resolution problem - using domain controller or in workgroup? on , off vpn in order connect server?

in case, can tell visual studio connect ip address of dataserver instead of name (either in connection you've added project or connection string explicitly specified in web.config). can add entry hosts file supersede dns resolution.


Comments

Popular posts from this blog

django - How can I change user group without delete record -

java - Need to add SOAP security token -

java - EclipseLink JPA Object is not a known entity type -