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. asked 31 May '12, 11:13 jimboidaho |
Amazing how well things work when you add the correct user to the database service. :(. answered 31 May '12, 18:11 jimboidaho |
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...