SQLCMD -L Returns Bizarre Response Instead of Server List
4
votes
1
answer
1564
views
I have a server with three installed SQL Server 2014 instances with Service Pack 1 (build number is 12.0.4213.0) installed. When I run SQLCMD -L on the server I am getting the bizarre response below.
> C:\Users\Tester>sqlcmd -L
>
> Servers:
> ;UID:Login ID=?;PWD:Password=?;Trusted_Connection:Use Integrated Security=?;
> *APP:AppName=?;*WSID:WorkStation ID=?;
The SQL Server is running normally and the SQL Browser service is started. Querying the SQL Browser service with another tool on the same server yields the expected results. I can run regular SQL queries with SQLCMD and get the expected results.
I was able to verify that the output above is the same on a workstation where I caused SQLCMD -L to receive no responses at all by enabling the firewall; however, the firewall is not an issue on this server. I've checked the settings and, as stated previously, my other tool gets SQL Browser Service responses to a broadcast just fine.
Also, running WHERE reports that the path to SQLCMD is
C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\SQLCMD.EXE
, which is correct per File Locations for Default and Named Instances of SQL Server .
Does anyone have any idea why SQLCMD is doing this and how to fix it?
Asked by JamieSee
(441 rep)
Jun 8, 2016, 06:36 PM
Last activity: Apr 23, 2024, 03:04 PM
Last activity: Apr 23, 2024, 03:04 PM