Solved

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

Posted on 2013-05-24
5
1,618 Views
Last Modified: 2013-05-29
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
0
Comment
Question by:Chris Millard
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 500 total points
ID: 39193805
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
 
LVL 17

Accepted Solution

by:
Chris Millard earned 0 total points
ID: 39193823
Remote connections on SQL Server were already enabled, but TCPIP connections on MSSQLSERVER were not!

Everything is working now.
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 39193827
is the TCP/IP protocol in the SQL Configuration tool on the server?
0
 
LVL 17

Author Comment

by:Chris Millard
ID: 39193831
Yes - it was in SQL Configuration Manager
0
 
LVL 17

Author Closing Comment

by:Chris Millard
ID: 39203901
I didn't have TCPIP connections enabled on MSSQLSERVER
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A procedure for exporting installed hotfix details of remote computers using powershell
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question