Hello , I have created Sql Anywhere as a windows service using dbsvc tool, as below

dbsvc -as -sn myserv -w myserv "c:\Program Files\SQL Anywhere 11\bin32\dbeng11.exe"

Service has been created successfully and I am able to see the service name under windows service list. I further checked the property of service where I found Display name : myserv
Service Name : SQLANYe_myserv
1) Why it is so ? 2)Why SQLANYe prefix has added ? 3)How to make Both Display name and service name same?

Thanks in Advance !

asked 23 Apr '13, 04:30

CrystalB's gravatar image

CrystalB
1065511
accept rate: 0%

edited 23 Apr '13, 05:55

Reimer%20Pods's gravatar image

Reimer Pods
4.2k334583


By convention, dbsvc always prefixes it services with SQLANY<c>_ to easily identify the service as a SQL Anywhere service and which type of service - the <c> is 'e' to indicate it is an 'engine' (aka Personal Server). Other letters are:

  • 's' for server (aka Network Server),
  • 'r' for dbremote,
  • 'm' for mobilink,
  • 'z' for dbmlsync,
  • 'l' for dbltm,
  • 'd' for dbns,
  • 'v' for dbvss,
  • 'h' for rshost,
  • 'b' for rsoe,
  • 'g' for mlagent,
  • 'u' for dbcloudagent, and
  • 'o' for odata server.

If you do not want the SQLANY<>_ prefix then you will need to create the service using some other tool - E.g. Microsoft's sc tool.

permanent link

answered 23 Apr '13, 08:02

Mark%20Culp's gravatar image

Mark Culp
23.2k9132272
accept rate: 40%

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:

×42
×35

question asked: 23 Apr '13, 04:30

question was seen: 987 times

last updated: 23 Apr '13, 08:02