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


  • 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


    Results from using portqry:

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

    Querying target system called:


    Attempting to resolve name to IP address...

    Name resolved to


    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


All replies