Solved

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

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

Free NetCrunch network monitor licenses!

Only on Experts-Exchange: Sign-up for a free-trial and we'll send you your permanent license!

Here is what you get: 30 Nodes | Unlimited Sensors | No Time Restrictions | Absolutely FREE!

Act now. This offer ends July 14, 2017.

Question has a verified solution.

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

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.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…

705 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