Thursday, 9 June 2011

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.



The error I got was - 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: 28 - Server doesn't support requested protocol) (Microsoft SQL Server, Error: -1)

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”

No comments:

Translate