Solved

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

Posted on 2013-05-24
5
1,582 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
  • 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 69

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

911 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now