Currently I have a SQL Anywhere (version 10) database (.db and .log files) - the idea is to extract the data and utilize it for a MS SQL database.
The problem is that I start a SQL Anywhere server and attach the database in question to it, but then when I try to connect to the server, I cannot pass the authentication (I've tried the default dba/sql combo and Windows integrated security).
However, I can use the same server to access the SQL Anywhere demo database without any problems. This leads me to believe that the user authentication is tied to each SQL Anywhere database and not to the SQL Anywhere server which is currently running.
I've read some of the SQL Anywhere Database Administration official documentation, but I didn't come across any strict details on how authentication is handled.
In short, the question is if one can connect to a random SQL Anywhere database which has been just provided by a 3rd party?
Best Regards,
Borislav