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
-
Shane_White Cireson Support Super IT Monkey ✭✭✭✭✭
We resolved this issue by updating the connection strings in the DB :-)
5
Answers
We resolved this issue by updating the connection strings in the DB :-)