• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1690
  • Last Modified:

Cannot connect to SQL Server 2012 on Windows 2012 from Windows 8 Client

I have a standalone Windows Server 2012 machine running SQL Server 2012.

I am trying to create a UDL file on my Windows 8 machine. I have created a blank file called test.udl and double clicked on it.

I put in the details as per the first image below, and click on drill down arrow for the "Select the database on the server:" option, and first of all get the error as shown in image 2 and then the dialog shown in image 3.

I have turned off the firewall on the Windows Server, but it still does not work. It doesn't work if I use the IP address of the server either.

If I perform the same procedure on the Windows Server itself, then everything works OK.

Any ideas please?

Data link properties
Error message
Chris Millard
Chris Millard
  • 3
2 Solutions
Raja Jegan RSQL Server DBA & ArchitectCommented:
Kindly try to enable Remote connections on SQL Server by performing the list of steps mentioned below:


Performing above should help fix the issue..
Chris MillardAuthor Commented:
Remote connections on SQL Server were already enabled, but TCPIP connections on MSSQLSERVER were not!

Everything is working now.
Éric MoreauSenior .Net ConsultantCommented:
is the TCP/IP protocol in the SQL Configuration tool on the server?
Chris MillardAuthor Commented:
Yes - it was in SQL Configuration Manager
Chris MillardAuthor Commented:
I didn't have TCPIP connections enabled on MSSQLSERVER
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.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

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