All geek questions in one place

Problem deploying website in IIS and connecting to SQL Server 2012, getting network error

I have deployed the site in IIS and am trying to access the database through the connection string.

My SQL Server and connection string are correct, as I tested it in the following ways:

  • My development environment transfers data correctly.
  • Connecting to SQL Server is good, as I could see from SQL Server Management Studio
  • Other pages of the website that are deployed are correct, and only those pages that transmit data fail.

The problem is that only through the IIS website do we have this error, and when I launch it from Visual Studio, everything is in order.

Here is the stack code I get:

Stack trace error

My connection string:

<add name="cnnSQLDB" 
     connectionString="server=**********;database=*********;Integrated Security=True;User ID=******;Password=******;" 
     providerName="System.Data.SqlClient"/>
+4
2

, 1433. SQL Server.

0

. :

  • SQL "Integrated security = false". , SQL.
  • , SQL, .
  • , GRANT , , .

, sp_readerrorlog, . , , : this this

0

Source: https://habr.com/ru/post/1678882/

More articles:


All Articles