0
I have an application in Asp.net mvc that, among other functions, registers personal data of customers. We recently switched the database access from one server to another, which has a copy of the previous server database.
The problem is that in this new database the application can not record data in the Contact and Address tables, but can read them and can write to other tables. In innerException it gives the following error:
Instance-specific or network error when connecting to SQL Server. >The server was not found or not accessible. Check that the >instance name is correct and that SQL Server is configured to allow remote connections. (Preview: SQL Network Interfaces, error: 26 - Server Find/Specified Instance Error)
Remember that I use the Entity Framework to perform operations and the error is not in the application code, because it works normally with the previous database. Can anyone tell me what the possible problem would be?
How is the Entity Framework setup? Your Web.config? All actions come from a single connectionString?
– Randrade
Yes, they all come from a web connection.config. The system can access the database, carry out selects and write data in the other tables, the error happens specifically when I write data (Insert and update) in the tables cited in the question
– Gustavo Correia
Could post how the configuration of the same?
– Randrade