I have an application in asp.net mvc which, among other functions, registers personal data of clients. We recently switched database access from one server to another, which has a copy of the database from the previous server.
The problem is that in this new database the application can not write data to the Contact and Address tables, but can read the data and can write to the other tables. In innerException it gives the following error:
Network-specific or instance-specific error when connecting to SQL Server. > The server was not found or was not accessible. Verify that the name of the > instance is correct and that SQL Server is configured to allow > remote connections. (provider: SQL Network Interfaces, error: 26 -> failed to find Server / Specified Instance)
Remembering 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 might be?