I am getting this error in visual studio express for the web 2013 when I try
to click on my database

icons in the server explorer. It did not happen before yesterday when I had
to uninstall and reinstall

sql server. The error is:

A network related or instance specific error occurred while establishing a connection to SQL Server. The

server was not found or was not accessible. Verify that the instance name is
correct and that SQL Server is

configured to allow remote connections. (provider: SQL network interfaces
error 50 Local database runtime

error occurred. Cannot create an automatic instance. See the Windows application event log for error details.

Can you please give me any help?

The error is pretty common error especially, when you just installed the sql server

refer this links, you should be able to fix it..

http://www.sswug.org/articlesection/default.aspx?TargetID=44331

http://stackoverflow.com/questions/18060667/cannot-connect-to-server-a-network-related-or-instance-specific-error

http://stackoverflow.com/questions/16256533/a-network-related-or-instance-specific-error-occurred-while-establishing-a-conne

Can you check SQL Server are up and running

Check TCP/IP protocol is enabled

Check Browser service is enabled

Make sure exception is there in firewall

make sure you connect like hostname\sqlexpress

Now when I try to put dell-pc\sqlexpress in the server name box from the modify connection page which I get from right clicking on my database icon in server explorer the folders under the icon appear but I get this message:

Could not load file or assembly

'Microsoft.SqlServer.Management.Sdk.Sfc, Version=11.0.0.0

Culture=neutral, PublicKeyToken=89845dcd8080cc91 or one of

its dependencies. The system cannot find the file specified.

My sqlserver is running in services. I have spent two days researching this on the internet. Any further help would be greatly appreciated.

http://www.advancesharp.com/blog/1113/could-not-load-file-or-assembly-microsoft-sqlserver-management-sdk-sfc

http://sqlbeyond.blogspot.in/2012/08/vs-2012-error-could-not-load-file-o

Thanks for your response. Can you tell me how I configure the exception in firewall and connect like hostname\sqlexpress?

Hi,

The error that you are getting now is a whole different from before :-)
According to your new error, It is look like you are missing some files that the Visual Studio server explorer use.

Your problem is probably oposit of this but the same explanation :-)
https://support.microsoft.com/en-us/kb/956178

You are using Visual Studio which is 32 application (there is only 32 version), but your server is 64 bit version, then you might need some more files.

According to your information You probably just need to download and install the same two file that mentioned in the article but for 32 but.

Since this is a public forum, and I only have information that you provide and no direct option to check and monitor the problem, I cant give you direct recommendation to install anything :-) anything that you are doing must be on your own risk, but this is the solution that wold probably chose

* you can download the files for SQL 2014 from here:
https://www.microsoft.com/en-us/download/details.aspx?id=42295

Please inform us if this help and dont forget to close the thread. If this did not help pls try to connect first from the SSMS and make sure that this work OK for you.

Hi,

Thanks for all the help. The last thing I tried was to repair Visual Studio 2013 for the web and all errors went away! Problem Solved!

• Marked as answer by Lydia ZhangMicrosoft contingent staff, Moderator 5 hours 22 minutes ago

You are most welcome :-)

Thanks for posting your solution :-)

* by the way, the missing files that I mentioned are part of the VS installation if you chose the sdk, and therefore uninstall+re-install will work... but in most cases like this one I think that this is a bit extreme to uninstall for 2 missing files. In any case this is a great solution :-)

* You can mark your own solution and/or other solutions as well, as the solution answer, in order to close the thread (on the way you can vote to responses in the thread... Both "mark as answer" and "vote" can be done to one or multiple resp