Upgrade consolidate v9 v11 Remote server not connect MsSql

[Former Member]

Sql anywhere 11.0.1.2044. Windows 2003 Server. ODBC driver version Microsoft SQL Server ODBC Driver Version 03.86.3959

I just upgraded my consolidated database from v9 to 11. All is working well except for my remote connection to a MS Sql database. I am using an ODBC dsn for the connection information which is the same as v9 was using but I get an error that login failed for user xxxx. If I go into the ODBC Admin and check the dsn connection there all is well. I tried creating a new remote server connection and that failed as well. I am using windows NT authentication to MS Sql. Not sure where to go from here.

Thanks.

[VolkerBarth]

Just a note: AFAIK, 11.0.1.2044 is the original maintenance release of 11.0.1. In case you're just upgrading, I would recommend to consider the usage of a current EBF, cf. the "current downloads list" from Breck's blog...

[Former Member]

Amazing how well things work when you add the correct user to the database service. :(.