Forum Discussion

DavidJLitttle's avatar
DavidJLitttle
Frequent Visitor
7 years ago

Can connect to SQL Server but Databases are not visible

Afternoon, Im trying to connect to a local SQL Server Express Database. I can connect to the local server fine, but PowerBI doesnt list any databses available under the server ? I cant work out why
Need Help
vanessafvg's avatar
vanessafvg
Community Champion
7 years ago

DavidJLitttle  how are you connecting via your active directory?

 

and if you go directly to sql can you see it?

DavidJLitttle's avatar
DavidJLitttle
Frequent Visitor
7 years ago
vanessafvg wrote:

DavidJLitttle  how are you connecting via your active directory?

 

and if you go directly to sql can you see it?


Hi, if i connect directly via SSMS then i can see all DB's and if i connect via VB.Net connection string then i can happily populate the DB. Its just PowerBI cant see any of the 3 local DB's

    • DavidJLitttle's avatar
      DavidJLitttle
      Frequent Visitor
      7 years ago

      Hi, Im using SQL Server Express 2017 and SSMS v17 and im using Import rather than direct query. but neither work. The SQL login connects fine, but the Database list is blank

       

      • TeigeGao's avatar
        TeigeGao
        Solution Sage
        7 years ago

        Hi DavidJLitttle ,

        First, we need to check if you have used the wrong server name, the server name "(LocalDb)\MSSQLLocalDB" is not a standard SQL Server instance, it is a localdb. 

        Then we need to check if these three databases are custom databases, the system database will not be displayed in the PowerBI list.

        After that, we need to check if the SQL Server login you are using have the permission to see these databases. Finally, we can use the SQL Server Profiler to check what's happened during this process.

        Best Regards,

        Teige