Problema gateway power services

Hi,rohit1991 ,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.
Hello,Syndicate_Admin .I am glad to help you.
The username and password used when configuring the gateway should be Windows credentials that enable access to SQL Server. Typically, these credentials are in the format Domain\Username. if you don't have a password, try creating a new user with the appropriate permissions and setting a password for it.
Adding Domain Users to the Local Administrators Group in Windows | Windows OS

If you can't use the windows (domain user authentication) method, you may consider using basic to authenticate the data source credentials.
basic requires you to fill in the username and password of the SQL account created in your SQL Server database.
All database instances will have an SA account by default after creation, you can manually change the password and give it access rights to the corresponding database.

Make sure that the gateway and SQL Server are in the same domain and that the gateway computer is authorized to access SQL Server If you still cannot save the settings, you may need to check the network connection between the gateway and SQL Server.
Update the gateway version: Make sure you are using the latest version of the Local Data Gateway.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.