connectionString Local Network Asp.Net MVC SQL SERVER

Asked

Viewed 229 times

0

I am trying to connect a bank in my application, which is networked, so I have put the following path:

<connectionStrings>
    <add name="smc" connectionString="Data Source=192.168.0.29; Initial Catalog=nomeDoBanco; User=sa; Password=senhaDoBanco" providerName="System.Data.SqlClient" />
  </connectionStrings>

error of application:

[Win32exception (0x80004005): Access denied]

[Sqlexception (0x80131904): Instance-specific or network error to establish connection with SQL Server. The server was not found or was not accessible. Check that the instance name is correct and if SQL Server is configured to allow remote connections. (Preview: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)]

error when I try to access from manager inserir a descrição da imagem aqui

However, from the bug. Does anyone know if I need to report anything else in Data Source, or if I have to set something up in the bank?

asp.net-mvc sql-server connectionstring
  • 1

    Rafael, which error message, could insert it in the question?

  • 1

    In the environment you are in, you tried to access through Management Studio with the credentials informed and got? Edits the question and includes the error that occurred.

  • I edited the question and put the error, when access by the application, and when I try to access via manager.

1 answer

0


Browser other questions tagged asp.net-mvc sql-server connectionstring

You are not signed in. Login or sign up in order to post.