Detalhes: "Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to al

Question

Não consigo carregar o exercício do Power BI devido ao erro descrito no título

Answer 1

Hi Clayton Teotonio de Lima Silva,
To troubleshoot the SQL Server connection error, first open services.msc and confirm that the SQL Server service (MSSQLSERVER or SQLEXPRESS) is running, restarting it if necessary. Then verify the instance name in your connection stringuse SERVERNAME for a default instance, SERVERNAME\SQLEXPRESS for a named instance, or connect directly with 192.168.x.x,1433. Next, enable TCP/IP in SQL Server Configuration Manager under SQL Server Network Configuration. Make sure your firewall allows inbound traffic on TCP port 1433, and if you’re using named instances, also allow UDP port 1434 for SQL Browser. Finally, test connectivity by running ping SERVERNAME or telnet SERVERNAME 1433, and if needed, try connecting with the IP address instead of the hostname.

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/network-related-or-instance-specific-error-occurred-while-establishing-connection

Hope This Helps!

Thanks,

Lakshmi.