[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 351
  • Last Modified:

ODBC Data source

Hi,
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 ?

regards
Pat
0
pclarke7
Asked:
pclarke7
2 Solutions
 
AubynCommented:
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.
0
 
Dave BaldwinFixer 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.
0
 
pclarke7Author Commented:
Thanks guy's,
worked a treat. Onwards and upwards

Pat
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now