cancel
Showing results for 
Search instead for 
Did you mean: 

how to use sql anywhere monitor for personal server ?

Former Member
3,080

Is it possible to use the sql anywhere monitor for a personal server?

I have a .Net application that starts up a personal server and connects to a client database.

But when I try to add a resource with sql anywhere monitor, I get an unspecific error.


So I first start my application, the Personal Server is running: Version 12.0.1.3873

  • then I go to the Monitor
  • Add resource
  • give a name 'test'
  • Host: localhost
  • port: empty
  • server: 'PersonalServerName'
  • DataBase: 'c:mylocationmydatabase.db'
  • other: empty

DBA User Id: useridoflocaldb

Password: passwordOfLocalDB


then I get this Error: An error occurred configuring the resource for monitoring. Please check that the server is running and that the correct connection parameters were given.

Accepted Solutions (1)

Accepted Solutions (1)

VolkerBarth
Contributor

The monitor uses TCP/IP to connect whereas the personal engine starts only the shared memory protocol by default and therefore does not listen to TCP/IP by default.

Confine the 12.0.1 doc page on the "Monitor architecture":

The monitor connects to SQL Anywhere databases over TCP/IP. To monitor a database running on the local database server (dbeng12), start the database server with the -x all or -x tcpip option.

Answers (1)

Answers (1)

Former Member

I've been able to startup network server and attach my application to that so the monitor has been startup...