EntityException when connecting to remote database

Question

EntityException when connecting to remote database

Navigation

#1 by (1 votes)

2

When connecting to the local bank, the application runs 100%. However, when I try to connect to the sql server remotely (on a nethost server), the application raises the following exception:

Below is an error and a connectionstring.

add name="DefaultConnection" connectionString="Data Source = HOST;   Initial Catalog = Integrated Security = True; persist security   info = False; User ID = ID; Password = PASSWORD; "   providerName="System.Data.SqlClient"

{"Network path not found"}

Is there any configuration in the db or in the application that makes this connection impossible?

c# entity-framework asp.net-mvc-5

asked by anonymous 09.09.2014 / 02:02

1 answer

How to make a script run only once? Oracle connect identifier problem is too long

score 1 · Answer 1

For any remote connection to SQL you need to pass IP\Nome_da_instancia . It may also be Nome_Servidor\Nome_da_instancia , but then it depends on whether the name resolution part is working properly. Also, make sure you can connect through SQL Server Management Studio. There are settings to make on the host to allow remote connections.