+ Post New Thread
Results 1 to 3 of 3
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 ...
  1. #1
    FatBoy's Avatar
    Join Date
    Oct 2007
    Location
    Kent, UK
    Posts
    251
    Thank Post
    55
    Thanked 20 Times in 16 Posts
    Rep Power
    18

    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!
    Thanks
    FB

  2. #2

    Join Date
    Sep 2010
    Posts
    23
    Thank Post
    2
    Thanked 1 Time in 1 Post
    Rep Power
    0
    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.

    sql.png

  3. #3
    FatBoy's Avatar
    Join Date
    Oct 2007
    Location
    Kent, UK
    Posts
    251
    Thank Post
    55
    Thanked 20 Times in 16 Posts
    Rep Power
    18
    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

SHARE:
+ Post New Thread

Similar Threads

  1. CMIS and SQL 2008 install
    By sgavan in forum MIS Systems
    Replies: 2
    Last Post: 9th July 2009, 02:31 PM
  2. php and sql ?
    By mac_shinobi in forum Web Development
    Replies: 15
    Last Post: 21st October 2008, 09:43 AM
  3. SIMS and SQL Express
    By interele in forum MIS Systems
    Replies: 3
    Last Post: 2nd February 2008, 05:43 PM
  4. SIMS and SQL, which version
    By andrewsmart in forum MIS Systems
    Replies: 4
    Last Post: 14th June 2007, 08:13 PM
  5. unix and sql commands
    By danIT in forum General Chat
    Replies: 9
    Last Post: 14th February 2007, 01:19 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •