Resolving "SR DAL Server is off line/incorrect name" when creating an SQL folder
This support note applies to:
- AE System Release (AU)
These instructions require technical expertise
Make sure you know what you're doing and are using one of the products listed. If you're not sure, ask your IT professional or MYOB.
When attempting to create an SQL folder in System Release 8.0d or above, System Services may display the error message "SR DAL server is off line/incorrect" followed by the error "Folder could not be established on this path".
If this error message occurs you need to make sure the following areas are correct:
- Ensure when creating an SQL folder, the server name is set to the windows computer name where SQL is installed and running
- Ensure the System Release DAL service is configured correctly and running.
- Ensure SQL instance is running.
- Follow the Menu Path Start > Control Panel. The Control Panel window appears.
- Double-click on System Release DAL. The System Release DAL window will appears.
Navigate to the Configuration tab and note the field SQL server to host databases. Ensure this is the correct instance. E.g. a Default instance would just be the SERVERNAME, a Named instance would be the SERVERNAME\INSTANCE NAME.
This can't be modified whilst the service is running it must be stopped
Navigate back to the Status tab and ensure the SR DAL Status is set Running. If it states Stopped please click Start but only after ensuring step 3 has correctly been done.
Click OK. The System Release DAL window closes.
MYOB INTERNAL STAFF ONLY
Nearly all AE sites will should be using a default instance. Named instances are only for New AO