Forum Discussion
Failed to connect SqlServer database with DirectQuery
Steps Get Data->SQL Server Database fill in Server with [servername]:[port] slect DirectQuery as Data Connectivity Mode,click OK fill in accounts and connect select one table in navigator pane...
Hi H__H ,
1. Go to edit the connection -> Clear permissions -> try to give credentials again.
2. Command Prompt -> Run as administrator -> sfc /scannow -> Enter and wait for completion
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
this solution not working
