I'm trying to connect power bi with my sql server database, however, the error below is occurring.
NOTE: TCP / IP and Name Piper are enabled on the SQL server.
These were the database connection data.
Server:
122.122.122.122 \ MSSQLSERVER
Database (optional): Test
Details: "Microsoft SQL: Network or instance specific error when connecting to SQL Server." The server was either not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to (provider: SQL Network Interfaces, error: 25 - Invalid connection string) "