I have had a difficulty with the EF when the connection the server is stopped or paused, and I raised the same question. So for completeness to the above answers here is the code. /// <summary> /// Test that the server is connected /// </summary> /// <param name=”connectionString”>The connection string</param> /// <returns>true if the connection … Read more
Looks like the initial problem is with the auto-config. If you don’t need the datasource, simply remove it from the auto-config process: @EnableAutoConfiguration(exclude={DataSourceAutoConfiguration.class}) Edit: If using @SpringBootApplication in your main class: @SpringBootApplication(exclude={DataSourceAutoConfiguration.class})
Solving this problem is very easy: Go to control panel. search for services. Open Local services window from your search results Restart your MSSQLSERVER service. Screenshot of the steps: