Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

0

SQL Server cannot login and retrieve data

Submitted by Anonymous on ‎10-17-2023 10:53 AM

Hello,
are you encounter this error in SQL Server

Login:

ps_alvin_1-1697565158713.png

Refresh database:

 

ps_alvin_0-1697565117138.png

 

Status: Delivered

Hi @Anonymous ,

 

Please make sure that the username and password you’re using are correct.
SQL Server can be set up to use either Windows Authentication mode or SQL Server and Windows Authentication mode (also known as “mixed mode”). If your server is set up to use Windows Authentication mode only, you might not be able to log in using SQL Server accounts. After changing the authentication mode, you’ll need to restart the SQL Service (SQLEXPRESS) Windows service.

You can find all the latest troubleshooting guidance and resolution to common issues in the SQL Server Troubleshooting documentation.
If none of these solutions work, I would recommend reaching out to Microsoft support or the SQL Server community for further assistance since it‘s Power BI issue forum.

 

 

Best regards.
Community Support Team_ Caitlyn

 

 

See more ideas labeled with:
1 Comment (1 New)
Comments
v-xiaoyan-msft
Community Support
Community Support
‎10-18-2023 12:27 AM
Status changed to: Delivered

Hi @Anonymous ,

 

Please make sure that the username and password you’re using are correct.
SQL Server can be set up to use either Windows Authentication mode or SQL Server and Windows Authentication mode (also known as “mixed mode”). If your server is set up to use Windows Authentication mode only, you might not be able to log in using SQL Server accounts. After changing the authentication mode, you’ll need to restart the SQL Service (SQLEXPRESS) Windows service.

You can find all the latest troubleshooting guidance and resolution to common issues in the SQL Server Troubleshooting documentation.
If none of these solutions work, I would recommend reaching out to Microsoft support or the SQL Server community for further assistance since it‘s Power BI issue forum.

 

 

Best regards.
Community Support Team_ Caitlyn

 

 

Idea Statuses