Skip to Content
1
Jun 25, 2020 at 10:09 AM

Cannot set up SQL Anywhere service for PowerDesigner Repository on NAS drive

82 Views

I've got several SQL Anywhere databases on a desktop PC hosting PowerDesigner repositories, and I use SQL Central to set up services for accessing them. I have a similar set up on a laptop, and I need to ensure that the databases on the two machines are synchronised - I often set up a demonstration or training course on the desktop and run it from the laptop at a remote site. Up to now I've put the databases into a OneDrive folder, expecting OneDrive to keep them synchronised on the two machines. I avoid accessing the same database on the two machines at the same time, but OneDrive still messes it up, deciding to rename database files seemingly randomly to avoid some form of conflict.

So I decided to move the databases to a NAS drive accessible to both machines, and I'll take a copy of the database files when I need to leave the office.

I changed the database services in SQL Central to point to the NAS drive, and they won't start. They return 'an unknown error' when I try and start them. I CAN connect to them directly without a service, so what's the problem? I've tried using a mapped drive to reference the database, and also the network URL, like this line below - neither works

-n DemoRepository "\\[serverName]\PD_Repos\Demo\16-7DemoDB.db"