ServiceDesk

I'm trying to install SD 7.1 on Windows Server 2008 R2 (non-SP1). I've followed the steps to install the native client, SMO collections, and other dependencies. I've also setup the app pools correctly and when running the installer as a domain admin (but not as the App Identity) I get the following error:

 Database integration strategy failed due to an error: Error setting permissions: Incorrect syntax near '-'.

Granting DB access to users failed. You must manually set up accounts like NETWORK SERVICE and ASPNET to have permissions to this database.

System.Exception: Database Configuration could not be installed correct. Installation cannot be continued

   at Symantec.Workflow.Installer.InstallerManager.Run()

Installation Failed. 

I was getting this error when trying to use a Domain AD account to authenticate to SQL during the install, it will state the 'TEST' was OK but it really isn't.

To get around this I created a DB Admin account on the SQL server and gave it permission to administer all DB's on that SQL Server. I then deleted the DB the Service Desk installer created 'ProcessManager' and re-run the install using my 'local SQL' DB Admin account as the SQL connection account.

Used SA account.