I built my website on ASP.NET MVC4 using mssql database, I deployed it on my local IIS 7 server and it works fine, but when I do to the exactly the same thing on virtual server hostgator.com it throws me this erro.
And tried 1000 connections strings and still no success.
It is strange because I did the same exact prodecure ion my local machine but it still can't connect to server.
I'm working on this problem last 24 hours and I can not find the solution for this problem.
I've contacted technical support and they said it's out of their support scope adn they can not help me with this.
I've done everything for this error to disapear because I had the same error on my local machine but when I configured it properly it worked, not so much on virtual server.
- Firewall is off
- remote aconnection are enabled in sql configuration
- application pool is set to network service
- I've added network service as new login in managgement studio with access to database
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. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)