[Sybase][ODBC Driver][SQL Anywhere] Database server not found

[Former Member]

Hi All,

Environment : BOE XI 3.1 SP5

Database : SQL Anywhere

My SIA is down and when checked in the properties, i found that one of the dependency is down which is :

- BOE120SQLAW - Down

- REMOTE Procedure Call (RPC) - Running

- Windows Event Log - Running.

Steps Tried :

- SIA > Properties > Configuration > CMS System Database Configuration .

- Clicked on update Data Source Settings > Selected Database Driver as "SQL ANYWhere" > Selected the tab "Machine Data Source".

- Selected "BOE120" DSN > Entered the database userID and password & submit.

- I receive the error message as "[Sybase][ODBC Driver][SQL Anywhere] Database server not found"

Any suggestions are appreciated.

Thanks,

Rameez 

[Former Member · Accepted solution]

Hi Rameez,

Seems like you have issue with conenctivity issues with SQL ANYWhere.

Before checking the SIA Data Source Settings, I would request you to check your ODBC-> System DSNs.

Make sure that they are DNS Test connection is working fine.

Regards,

JRK PRASAD

[Former Member · Accepted solution]

Hi Prasad,

Thanks for the reply.

I have checked the DSN as well.. it gives me the error message as "connection failed : database server not found"

Could you let me know from where to check of the server is running or not.

Thanks,

Rameez

[Former Member · Accepted solution]

Hi Rameez,

Are you using integrated DB which is installed with BI 4.1 or Do you have External DB as CMS DB?

Regards,

JRK PRASAD

[Former Member · Accepted solution]

Hi Prasad,

Yes, i am using integrated DB which is SQL Anywhere with BOE XI 3.1.

Thanks,

Rameez

[Former Member · Accepted solution]

Hi Rameez ,

The connection failed database server not found error suggest that the user may be locked on database side OR password is changed .

Try and unlock the user OR get the updated password .

Thanks,

Sneha Bankar

[Former Member · Accepted solution]

Hi Sneha,

Thanks for the reply. I am running this as admin user.

I am attaching the screenshot of the error message for your reference.

Please suggest me further steps.

Thanks,

Rameez

[Former Member · Accepted solution]

Hi Rameez ,

We need to investigate at database side logs , please check if you can trace the connectivity with SQL PLUS or any other database connectivity tools .

Also, check some the windows system logs.

Thanks,

Sneha Bankar

[Former Member · Accepted solution]

What is the Status of SQL Anywhere in the Windows Services?

[Former Member · Accepted solution]

Hi Victor,

I have a BOE120SQLAW available in windows service but it is Stopped. I tried to start it but get the error message as attached below :

Thanks,

Rameez Shaikh

[Former Member · Accepted solution]

Did you already try with a restart of the server machine?

[Former Member · Accepted solution]

Hi Victor,

I would like to inform that the issue is resolved now. I have Pointed the database file to the SQL Anywhere Server and restarted the server and it worked.

Thanks all for your help and suggestions.

Regards,

Rameez Shaikh

[neha_jain7 · Accepted solution]

Hello Rameez,

I am facing the same error.

Could you please let me know, how you have Pointed the database file to the SQL Anywhere Server

Thanks & Regards,

Neha

[Former Member · Accepted solution]

Hi Neha,

Iam facing the same issue, by any chance did you find any solution.

Thanks

kumar

[Former Member]

Hello, I have the same issue.. could you plase, describe , how you pointed the data bas file to the SQLAnywhere server ?... I have both, db and BI in the same server...

thanks in advance