I have hosted a website that has MSSQL Server 2005 database on different machine. I am using the following connection string
<add name="ConnectionString" connectionString="Server=mssql2005.ableos.com.au;Database=visualinventory_ableos_com_au;Uid=myuserid;Pwd=mypassword;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />
I am getting 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. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
What may be the potential problem. ?
I am able to connect to the same database using same user id and password through third party software that allows me to monitor it. why my website is not able to connect to it ?
Any suggestion appreciated.