I have a development-environment (dev) on which I have my .Net-application running which contains a RoundHouse-project to keep the database up to date. The database is running on the same machine. There are no problems with dev.
I also have a test environment with the same application and also a copy of the database. To keep the database on the test-environment up to date I run the RoundHouse-project from dev using the connectionstring to the database on the test-environment.
This always worked fine but for some reason when I now run RoundHouse with the connectionstring to the test database I get the following error: 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.
Funny thing is that when I recreate the connectionstring using a .udl file using the same properties and credentials I am able to connect to the test-database.
Running the webapplication using that same connection results in the same error.
I have already checked all the settings in the SQL Server Configuration Manager and made sure TCP/IP and Named Pipes are enabled.
I can ping the server and can connect to it using Remote Desktop.