Problem creating ODBC connection to SQL SERVER 2012 EXPRESS (1 Viewer)

Plem

Registered User.
Local time
Today, 17:48
Joined
Apr 17, 2019
Messages
14
Hi, I have setup a new network with a server running Windows Server 2016 hosting a SQL SERVER 2012 express database. When I try to setup an ODBC connection on one of the client PC's the drop down box in the ODBC configuration does not show the SQL SERVER instance?

I have made sure the SQL services are running and enabled TCP/IP and named pipes.

Any help much appretiated
 

Plem

Registered User.
Local time
Today, 17:48
Joined
Apr 17, 2019
Messages
14
Hi,
Just to let you all know that i resolved the problem. it was a port setting in the Firewall for UDP port 1434 and TCP port 1434 which had to be enabled in Inbound Rules.
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 10:48
Joined
Aug 30, 2003
Messages
36,118
Thanks for posting the solution and welcome to the site!
 

Users who are viewing this thread

Top Bottom