Enable Remote Connection on SQL Server 2008 Express and fix error 28
Enable Remote Connection on SQL Server 2008 Express and fix error 28.
In the example given I was trying to connect from my desktop PC to a TMG server’s SQL databases, however I assume you could get this error if you were just trying to connect from your desktop PC to a SQL server. In this example I was using SQL Server 2008 on my PC trying to connect to Microsoft TMG 2010’s SQL Express databases.
There is a few things you need to do to fix this error, some of all of these may help you, I had to do all.
1. On the TMG server In services ensure that the “SQL Server Browser” service is enabled and started, by default it seems to be disabled.
2. On the TMG server In services ensure that the “SQL Server (ISARS)” and “SQL Server (MSFW)” services are both enabled and started automatic.
3. On the TMG Server Open “SQL Server Configuration Manager” and under “SQL Server Network Configuration” ensure that that under “Protocols For MSFW” and “Protocols For ISARS” the TCPIP is set to “Enabled”