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
Notification
LVL 17
Chris MillardAsked:
Who is Participating?
 
Chris MillardConnect With a Mentor Author Commented:
Remote connections on SQL Server were already enabled, but TCPIP connections on MSSQLSERVER were not!

Everything is working now.
0
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
Kindly try to enable Remote connections on SQL Server by performing the list of steps mentioned below:

http://sysbadmin.wordpress.com/2012/09/25/how-to-enable-remote-connections-sql-server-2012-express/

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