Skip to main content
Asked a question 3 months ago

Does DashboardFox support SQL Express as a data source, I'm unable to connect?

sqlexpress

Where am I?

In DashboardFox you can ask and answer questions and share your experience with others!

Yes, but by default typically SQL Express doesn't have the network communication enabled.  To connect via DashboardFox configure the following.

Open the SQL Server Configuration Manager which will show this screen.

Does DashboardFox support SQL Express as a data source,  I'm unable to connect?

The first thing to check and update if needed is the SQL Server Browser must be Running and set to Start Mode automatic.  By default, this is turned off on a fresh SQL Server (or SQL Express)

Double-click on the SQL Server Browser item and you can adjust the Start Mode.

Next, under the SQL Server Network Configuration, click on Protocols for <servername> and ensure that TCP/IP is enabled.  By default, it will be disabled on a fresh installation.

Does DashboardFox support SQL Express as a data source,  I'm unable to connect?

Double-click on that item and you can update the setting to enabled.  

Restart the main SQL Server service to have the changes take effect.  Then you can retry your app registration as you would for a normal SQL Server83.

If you do run into further problems, please contact us at team@dashboardfox.com83

 

Originally answered to "sqlexpress"

Hello,  you can find more about how to leverage SQL Express with DashboardFox on this answer - https://support.dashboardfox.com/question/does-dashboardfox-support-sql-express-as-a-data-source-i-m-unable-to-connec--608f2e6166ad4137c513aefe?answerId=608f2f3eb1cbec174d7cac63

If that doesn't help, please reply back with more specifics.

thanks!