Home General Discussion

Problem with SQL connection

Hi Team! I have a problem with SQL connection.

In my dev environment I have DB ServiceManagement it work

In my prod environment I have DB ServiceManagement also it work

When I make backup from prod and restore in dev it not work.

Who can help me, below i give my connection string and compare DB, error which return cireson portal

DEV

<connectionStrings>

  <add name="ServiceManagementDatabase" connectionString="Server=SQLFCI13\inst7;Database=ServiceManagement;Trusted_Connection=True;" />

  <add name="EntityModels" connectionString="data source=SQLFCI13\inst7;initial catalog=ServiceManagement;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework" providerName="System.Data.SqlClient" />

  <add name="CiresonAnalytics" connectionString="data Source=SQLFCI13\inst7;Initial Catalog=CiresonAnalytics;Trusted_Connection=True;" />

  </connectionStrings>

PROD

<add name="ServiceManagementDatabase" connectionString="Server=AL-SQLSCSM1, 1451;Database=ServiceManagement;Trusted_Connection=True;" />

  <add name="EntityModels" connectionString="data source=AL-SQLSCSM1, 1451;initial catalog=ServiceManagement;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework" providerName="System.Data.SqlClient" />

  <add name="CiresonAnalytics" connectionString="data Source=AL-SQLSCSM1, 1451;Initial Catalog=CiresonAnalytics;Trusted_Connection=True;" />



Best Answer

Answers

Sign In or Register to comment.