Post reply

Error Locating Server/Instance Specified, SQL Server 2014/Windows 10

  • August 3, 2016 at 11:03 am

    #315943

    SQL Server 2014 on Windows 2012R2 server. Our application connects to SQL Server without any problem on several Windows 7 computers, but gets the above error on a new Windows 10 machine.

    No firewall or anti-virus running on client.

    Using a named instance, SQL Browser is running.

    Used Portqry and got the following results:

    Server's response:

    ServerName SQL_SERVER

    InstanceName DTSQLSERVER

    IsClustered No

    Version 12.0.4100.1

    tcp 49782

    np \\SQL_SERVER\pip\MSSQL$DTSQLSERVER\sql\query

    UDP port 1434 is LISTENING

    Tried to establish a connection to the instance from the client using ODBCAD32. Failed with same error message. When setting up in ODBCAD32, you can see the instance and select it as the Server, but the test fails.

    Any ideas on where I go from here?

    Isaac

  • August 9, 2016 at 7:05 am

    #1894506

    Isaacd,

    Have you considered configuring SQL to use static ports instead of dynamic ports? I have had similar application connection problems with dynamic ports which are resolved by setting static port to 1433.

    Hope this helps!!

    Jon

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply