не могу подключиться к серверу базы данных onsite

<?xml version="1.0" encoding="utf-8"?>
<connectionStrings>
 
  <add name="redis" connectionString="host=localhost;db=2;port=6379;timeout=20;maxReadPoolSize=10;maxWritePoolSize=500" />
  <add name="defPackagesWorkingCopyPath" connectionString="%TEMP%\%APPLICATION%\%APPPOOLIDENTITY%\%WORKSPACE%\TerrasoftPackages" />
  <add name="tempDirectoryPath" connectionString="%TEMP%\%APPLICATION%\%APPPOOLIDENTITY%\%WORKSPACE%\" />
  <add name="sourceControlAuthPath" connectionString="%TEMP%\%APPLICATION%\%APPPOOLIDENTITY%\%WORKSPACE%\Svn" />
  <add name="elasticsearchCredentials" connectionString="User=gs-es; Password=DEQpJMfKqUVTWg9wYVgi;" />
  <add name="influx" connectionString="url=http://10.0.7.161:30359; user=; password=; batchIntervalMs=5000" />
  <add name="messageBroker" connectionString="amqp://guest:guest@localhost/BPMonlineSolution" />
  <add name="db" connectionString="Data Source=MSKDTC01-SQL01\CRM; Initial Catalog=ELZTerrasoft; User ID=Terrasoft123; Password=Root123-4;MultipleActiveResultSets=True;Pooling=true;Max Pool Size=100" />
</connectionStrings>

выше мой файл настроек

у пользователя есть права владельца 

но при попытке открыть сайт выдает 
 

Security Exception

Description: The application attempted to perform an operation not allowed by the security policy.  To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file.

Exception Details: System.Data.SqlClient.SqlException: 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)

Source Error:
 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:
 

 

Нравится

1 комментарий

Дмитрий, добрый день! 

 

Данная ошибка связана с тем, что возникают проблемы подключения к серверу базы данных SQL с сервера IIS.

С рекомендациями по устранению данных проблемы можно ознакомиться тут 
https://stackoverflow.com/questions/16256533/a-network-related-or-instance-specific-error-occurred-while-establishing-a-conne
и
https://thycotic.force.com/support/s/article/System-Data-SqlClient-SqlException-0x80131904

Показать все комментарии