none
SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]

    Question

  • Hi,

    Rest of our particular error message:

    OLE DB provider "SQLNCLI" for linked server "MSLCOCSSQL2\MSSQLMON" returned message "Login timeout expired".

    OLE DB provider "SQLNCLI" for linked server "MSLCOCSSQL2\MSSQLMON" returned message "An error has occurred while establishing a connection to the server .  When connecting to SQL Server 2005, this feature may be caused by the fact that under the default settings SQL Server does not allow remote connections.".

    Getting the above error - and have ran through the article here

    http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx

     

    Results from using portqry:

    D:\Program Files\Microsoft\portqryv2>portqry.exe -n mslcocssql2 -p UDP -e 1434

    Querying target system called:

     mslcocssql2

    Attempting to resolve name to IP address...


    Name resolved to 10.22.5.62

    querying...

    UDP port 1434 (ms-sql-m service): LISTENING or FILTERED

    Sending SQL Server query to UDP port 1434...

    UDP port 1434 (ms-sql-m service): FILTERED

    D:\Program Files\Microsoft\portqryv2> 

    I am not SQL savvy - trying to get our application working an this is what I've been able to determine so far.

    I believe it's clustered SQL 2008 instance.  The sql server and app server are in the same FW zone/subnet.



    The rest of the message we get is:

     

    Monday, March 28, 2011 8:54 PM

Answers

All replies