ODBC remote Connection Issues running Sql Server 2008 Express Edition running on Windows Server 2008 R2

[Jude_Ejuh]

I had had errors doing remote connection using odbc using above confogurations. Is that Express Edition does not allow remote connection. I have done the needful but its still okay. 

ODBC client driver is SQL Server Native Client  10.0.

Errors is as follows

SQLState '08001'

SQL Server Error: --1

SQL Server doesn support requested protocol [xFFFFFFFF], Connection failed

SQLState 'HYT00'

SQL Server Error: 0

[Microsof][SQl Server Native Client 10.0] Login Timeout expired

Jude

Thanks

[Andy_Steinke]

You need to enable TCP/IP for the instance. Below is a link to an MSDN article that details how to do it.http://msdn.microsoft.com/en-us/library/bb909712(v=vs.90).aspxAdditionally, enable remote connectionshttp://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspxAndy

[Jude_Ejuh]

Thanks Andy

Your materials was helpful it has been resolved. Why is ODBC issues always problematic?. I believe perhaps its the different OS installations that causes these different sceanarios. 

Thanks a millions times.

Jude