downloaded the orion NPM trial version but cannot run the s/w as it shows problems such as cannot connect to sqlserver
When you install the Orion evaluation select the express option. This will install SQL Express as part of the installation process. This should ease the installation process.