Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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.

asked 02 Dec '13, 04:16

soto's gravatar image

soto
96228
accept rate: 0%


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.

permanent link

answered 02 Dec '13, 07:08

Volker%20Barth's gravatar image

Volker Barth
40.2k362550822
accept rate: 34%

edited 02 Dec '13, 07:09

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

permanent link

answered 02 Dec '13, 06:02

soto's gravatar image

soto
96228
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:

×32

question asked: 02 Dec '13, 04:16

question was seen: 2,679 times

last updated: 02 Dec '13, 07:09