Hi I'm having trouble on adding a MSSQL Database data source on Data Sources -> Connections -> MSSQL database as I keep getting the error message below:
"Unknown error: A network-related or instance-specific error occured while establishing 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 allow remote connections."
I have attached the image of information for my msssql server. On the Webcon designer studio, I'm inputting the informations like this:
Conection type: Windows Authentication User Impersonation
Server: (localdb)\localDB1
Database: demoDB
User: DESKTOP-75etc.
Can someone help me how to properly add a mssql datasource or if im doing something incorrectly. Thanks in Advance.