Forum Discussion

SkanUSAutomation's avatar
SkanUSAutomation
Copper Contributor
Nov 14, 2025
Solved

Error Locating Server/Instance Specified - Tried everything I can find

Hello SQL experts, I am sort of at my wits end at this point and was hoping someone from the community could help me, I have referenced several discussions on this community and still have not found...
  • BastiF's avatar
    BastiF
    Nov 15, 2025

    Hi Dan, your code looks okay for me by flying over. The SQL Server Browser is running. 

    So the error is because sqlcmd can’t find the instance or can’t authenticate it.  

    The instance name has a typo. The Instance name is SSRS at the end and you have SRSS _> this should fix it. 

    If not check:

    You are using SQL Auth may only Windows Auth is allowed? 

    Check if network/firewall blocks port 1433. 

    Best

    Basti

     

BastiF's avatar
BastiF
MCT
Nov 15, 2025

Hi Dan, your code looks okay for me by flying over. The SQL Server Browser is running. 

So the error is because sqlcmd can’t find the instance or can’t authenticate it.  

The instance name has a typo. The Instance name is SSRS at the end and you have SRSS _> this should fix it. 

If not check:

You are using SQL Auth may only Windows Auth is allowed? 

Check if network/firewall blocks port 1433. 

Best

Basti

 

SkanUSAutomation's avatar
SkanUSAutomation
Copper Contributor
Nov 18, 2025

Basti you are a lifesaver, I had overlooked the spelling as I had gone through it so many times, thank you so much, everything works fine now

Best Regards,

Daniel

Resources