Forum Discussion
AdministratorProblema 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.
AdministratorHello
What a shame with my insistence but I can't solve the problem. Honestly, you mention certain things that I don't understand very well since I'm new to permissions and gateways and I barely understand. What I can tell you is that I performed the steps mentioned above. As for creating a new account, SQL does not allow me, it generates an error. I don't know if the error is because I have to add domain user to the group. But if that were the case, it would be to create a new user as an administrator in lusrmgr.msc?. Additionally, the sa comes out with an x in that user and it doesn't let me change password. When you mention "Make sure that the gateway and SQL Server are in the same domain and that the gateway computer is authorized to access SQL Server," what do you mean?
I tell you that the gateway does work perfectly. What I can't do is connect to SQL.
I attach the photo where on-premise data gateway works.
And a second photo where it generates the error for not being able to perform the authentication.