Sybase SQL Anywhere Remote Server to SQL Server with Windows Authentication

[former_member292966]

Hi,

I'm using SQL Anywhere 16 and trying to create a Remote Server to a SQL Server database using Windows Authentication. Both are on separate Windows 2019 server.

For ODBC to connect to the SQL Server, the Sybase service account is authenticated to SQL Server because of the Windows Authentication.

The Sybase service account does not have permissions to the databases on SQL Server. When I create the Remote Server, I am hoping to have the ability to impersonate or redirect the sign on to a different account that does have permissions to the database on SQL Server.

Is this possible? From what I can see, Remote Servers will only work with local accounts on SQL Server and not Windows Authentication.

Thanks,

Brian

[chris_keating]

The default service account is LOCAL SYSTEM and that account is not something that can be an Integrated Windows authentication based connection. The solution is to change the SQL Anywhere service account to an user account on that machine. In the service, change the log on as from Local System account to This account. This will work but all remote server connections from this SQL Anywhere service will use that account.

[chris_keating]

When running SQL Anywhere in the context of a Windows service, the account that is supplied to an Integrated Login request is the account for the service. It will not use the account of the connected user to SQLA.