ODBC Data source

I have MS server 2010 express installed and when I try to configure an ODBC DSN for SQL Server it fails to show any servers, instead showing Blanks.

I have tried using all of the following drivers with success:
SQL Server Native client 10,
SQL Server Native Client 11
SQL Server

I have done the same installation on another computer and when I attempt to configure under SQL Server Native client 10 - it displays multiple servers including "local". But on this computer the list is Blank.

Any idea what I am doing wrong ?

Who is Participating?
Dave BaldwinConnect With a Mentor Fixer of ProblemsCommented:
Make sure the SQL Browser service is started and it is allowed to accept requests thru the firewall.  The SQL Browser service connects requests to SQL Servers when they are asked for by 'instance name'.  Also, TCP/IP must be enabled in the SQL Native Client as well as the server.
AubynConnect With a Mentor Commented:
Turn off any firewall temporarily and try again to see if that may be the cause. If that fails, try enabling TCP/IP protocol using the SQL Server configuration console.
pclarke7Author Commented:
Thanks guy's,
worked a treat. Onwards and upwards

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.