Windows Server 2012 Thread, Svr2012 and SQL 2012 in Technical; We have two instances of SQL installed on one Server 2012 box, and need to run queries from one to ...
15th November 2013, 12:23 PM #1
Svr2012 and SQL 2012
We have two instances of SQL installed on one Server 2012 box, and need to run queries from one to the other. At the moment we are getting the error
OLE DB provider "SQLNCLI11" for linked server "servername\instance" returned message "Login timeout expired".
OLE DB provider "SQLNCLI11" for linked server "servername\instance" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.".
Msg -1, Level 16, State 1, Line 0
SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
I followed the below and all seems fine here: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified - SQL Protocols - Site Home - MSDN Blogs
Also tried the portqry.exe and the server responses to port 1434
I'm not a SQL wizz so not sure where to go!
22nd November 2013, 07:02 PM #2
- Rep Power
Try opening your SQL Server Config Manager and under the SQL Network Config --> Instance in question --> Open Properties on the TCP/IP and check the IP Address Tab, and scroll down. Most times it dynamically creates a port. If you are changing this to a static Port, you need to remove the Dynamic info and put your port in the TCP PORT field only. This should only be needed though if the program you are using does not work with Dynamic ports for some reason (Some legacy apps do). I would make sure that Dynamic port is opened on the Windows Firewall. Usually I just add that port to the pre-created SQL Server Firewall Rule under the Windows Firewall Advanced settings.
27th November 2013, 03:02 PM #3
Thanks for your comment dmanning unfortunately I can't see that this is the problem, I have checked the settings which look into and the firewall is off, thanks for taking the time to point this out to me though
By sgavan in forum MIS Systems
Last Post: 9th July 2009, 03:31 PM
By mac_shinobi in forum Web Development
Last Post: 21st October 2008, 10:43 AM
By interele in forum MIS Systems
Last Post: 2nd February 2008, 06:43 PM
By andrewsmart in forum MIS Systems
Last Post: 14th June 2007, 09:13 PM
By danIT in forum General Chat
Last Post: 14th February 2007, 02:19 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)