Home > Archive > SQL Anywhere database > July 2005 > ASA 9, request to start/stop db denied









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author ASA 9, request to start/stop db denied
Julius Pauliukaitis

2005-07-28, 8:23 pm

SSBzdGFydGVkIHRvIGdl
dCB0aGlzIG1zZyAtIFJl
cXVlc3QgdG8gc3RhcnQv
c3RvcCBkYXRhYmFz
ZSBkZW5pZWQsIGlmIEkg
dHJ5IHRvIGNvbm5lY3Qg
dmlhIFN5YmFzZSBDZW50
cmFsIChvciBTUUwg
SW50ZXJhY3RpdmUpLCBz
ZWxlY3RpbmcgYSBkYXRh
YmFzZSBmaWxlLiANCklm
IEkgc3RhcnQgc2Vy
dmVyIG1hbnVhbGx5IGZy
b20gY29tbWFuZCBsaW5l
IChkYnNlcjkuZXhlLCBz
ZWxlY3QgdGhlIGRi
IGZpbGUsIGNsaWNrIE9L
KSB0aGUgaXQgd29ya3Mu
IFRoZW4gSSBjYW4gY29v
bmVjdCB2aWEgc3li
YXNlIGNlbnRyYWwgb3Ig
U1FMIGludGVyYWN0aXZl
IGNob29zaW5nIGEgc2Vy
dmVyIG5hbWUuDQoN
CldhaHQgY2FuIEkgZG8g
dG8gYmUgYWJsZSB0byBj
b25uZWN0IHZpYSBzZWxl
Y3RpbmcgZmlsZSBh
Z2Fpbj8gSSBjb25uZWN0
IGFzIGRiYS9TUUwNCg0K
VGhhbmsgeW91LCANCkp1
bGl1cw==

Raymond Kwong

2005-07-28, 8:23 pm

Check if you have any existing engine (dbeng9.exe) running. dbeng9.exe
likely has started either as a service, or as a Connection Profile --
Sybase Central F9


It's very possible that there is a connection profile set to "Use On
Startup".


If it is a service, then it would be a good idea to use the -gd all
switch in your service configurations.

On 28 Jul 2005 13:28:38 -0700, "Julius Pauliukaitis"
<julius@ivs_fffffff.lt> wrote:

>I started to get this msg - Request to start/stop database denied, if I try to connect via Sybase Central (or SQL Interactive), selecting a database file.
>If I start server manually from command line (dbser9.exe, select the db file, click OK) the it works. Then I can coonect via sybase central or SQL interactive choosing a server name.
>
>Waht can I do to be able to connect via selecting file again? I connect as dba/SQL
>
>Thank you,
>Julius


Chris Keating \(iAnywhere Solutions\)

2005-07-29, 7:23 am

The underlying problem is that you are trying to start a database on an
existing engine (the dbsrv9 process). The solution will depend on your
intent:

1) If you want a separate engine (dbeng9 or dbsrv9) process to host the
second database, you need to either manually start a new engine or provide
an unique engine name (if the engine is left blank, the default engine is
used)

2) If you want to run on the existing engine process, you need to start the
dbsrv9 process with the -gd set appropriately.


"Julius Pauliukaitis" <julius@ivs_fffffff.lt> wrote in message
news:42e9ec44$1@foru
ms-1-dub...[color=darkred]
> This error happens only if have allready one instance of ASA running
> (another product is using it as it's working DB). Then there is an
> instance of dbsrv9.exe process running (but no dbeng9.exe).
>
> "Julius Pauliukaitis" <julius@ivs_fffffff.lt> wrote in message
> news:42e9e95e$1@foru
ms-2-dub...


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com