Go Back   Access World Forums > Apps and Windows > SQL Server

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-17-2019, 01:54 AM   #1
Plem
Newly Registered User
 
Join Date: Apr 2019
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Plem is on a distinguished road
Problem creating ODBC connection to SQL SERVER 2012 EXPRESS

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 is offline   Reply With Quote
Old 04-17-2019, 03:28 AM   #2
Plem
Newly Registered User
 
Join Date: Apr 2019
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Plem is on a distinguished road
Re: Problem creating ODBC connection to SQL SERVER 2012 EXPRESS

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.
Plem is offline   Reply With Quote
Old 04-17-2019, 07:26 AM   #3
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 32,708
Thanks: 11
Thanked 4,000 Times in 3,938 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Problem creating ODBC connection to SQL SERVER 2012 EXPRESS

Thanks for posting the solution and welcome to the site!

__________________
Paul
Microsoft Access MVP

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ODBC connection problems to SQL Server BennyLinton Queries 1 01-30-2018 02:34 PM
access 2012 frontend not showing correct data from linked ODBC sql 2012 tables starrcruise SQL Server 1 06-04-2014 07:11 AM
Upsizing to SQL Server 2012 Express - Localdb? Peter Reid SQL Server 2 01-11-2013 06:56 AM
Check for ODBC SQL Server Connection frankbutcher Forms 0 11-26-2007 05:30 AM
access to sql server express connection grahamsyuk SQL Server 5 10-03-2007 06:56 PM




All times are GMT -8. The time now is 12:29 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World