Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
db042190
Post Prodigy
Post Prodigy

how do you manage connection authentication in the service

Hi, i added a connection recently and was wondering what the smart auth method is.   I feel like i want a non expiring windows id but really dont know what to consider.  Can the community help?   i dont want to change this every time my personal pswd changes.

 

screenshotyyy.png

3 REPLIES 3
v-heq-msft
Community Support
Community Support

Hi @db042190 ,
Based on your description and the screenshot provided, you are now trying to configure credentials using the windows authentication method, and based on the articles I've looked up, you can either disable password expiration by turning on Local Users and Groups, or disable it via code using Command Prompt.
You can refer to the method in the following article to disable the password expiration policy in local accounts
How to Enable or Disable Password Expiration in Windows 11 (makeuseof.com)
Enable or Disable Password Expiration for Local Accounts in Windows 10 | Tutorials (tenforums.com)

Best regards,

Albert He

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

thx albert i didnt see a local users and groups options.

PowerUP200
Frequent Visitor

Is using a service account an option? Our organisation creates dedicated service accounts that have access to specific SQL servers, and we use their credentials instead of our personal ones (credentials are stored in a password manager). Service account passwords rarely change, and that limits the admin overhead and has worked well for us. 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors