Forum Discussion

UncleLewis's avatar
UncleLewis
Icon for Responsive Resident rankResponsive Resident
7 years ago
Solved

Cannot Connect to SQL Database

Hi all,   I setup SQL Server Express 2014 and attached Northwind and pubs databases. However, when I try to connect to pubs from Power BI I receive an error:   Details: "Microsoft SQL: A connect...
Need Help
  • Watsky's avatar
    Watsky
    7 years ago

    Have you tried clearing Global Permissions?

UncleLewis's avatar
UncleLewis
Icon for Responsive Resident rankResponsive Resident
7 years ago

Thanks Watsky,

 

I tried...

Edit Queries >> Data source settings

 

I selected the SQLServerExpress Instance, and clicked on Clear Permissions and I steed through the dialog's again to get access to the databases attached to the server. It worked this time, although I am not sure what I did the first time through to cause the error?

 

At least resolved - thanks!

-w

Watsky's avatar
Watsky
Icon for Solution Sage rankSolution Sage
7 years ago

It may not have been anything on your end. It may have been something changed on the server end.