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's gravatar image

jimboidaho
111141422
accept rate: 0%

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...

(01 Jun '12, 03:19) Volker Barth

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

permanent link

answered 31 May '12, 18:11

jimboidaho's gravatar image

jimboidaho
111141422
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×56

question asked: 31 May '12, 11:13

question was seen: 1,491 times

last updated: 01 Jun '12, 03:19