I too had the same problem some time back and I too tried many solutions. Here are the few good steps and a video to resolve this error. http://techpint.com/programming/error-26-%E2%80%93-error-locating-serverinstance-specified-sql-server[^]