how do you manage connection authentication in the service

[db042190]

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.

[v-heq-msft]

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

[db042190]

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

[PowerUP200]

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.