Solved

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

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

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…

760 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

21 Experts available now in Live!

Get 1:1 Help Now