Last post Jan 01, 2015 04:02 PM by a2h
Jan 01, 2015 07:54 AM|Philosophaie|LINK
I have just added Microsoft Visual Studio 2010 to a previously existing VWD Express.
When I refresh the SQL database I get this error in both vs2010 and VWD:
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: 26 - Error Locating Server/Instance Specified)
Jan 01, 2015 09:24 AM|Rion Williams|LINK
If the issue is related to the actual installation itself, you can generally try running the installer with administrative privileges (e.g. Right-click > Run as Administrator) or if it is occurring while running Visual Studio, you could try just
running it as an administrator as well.
A bit of quick research on that issue directed me to the following set of troubleshooting tips to check out for this issue :
You can find some additional references related to this issue below :
or read a bit more about this conversation here.
Jan 01, 2015 04:02 PM|A2H|LINK
provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Looks like your code cannot find the Server or Instance name mentioned in your connection string. Please check your connection strings again and ensure the below points
1) Make sure your server name is correct, e.g., no typo on the name.
2) Make sure your instance name is correct and there is actually such an instance on your target machine.
Some time you may need to give double slashes between server and instance (Server\Instance), so if you have single slash and if you are facing issue try with double slashes like Server\\Instance
Check this link for more details : http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx