Forum Discussion
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...
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