i am getting the following error while trying to install the system:
An error occured: Line 9: Incorrect syntax near '('. Running scripts from file: D:\hshome\user\domain.com\install\Scripts\nopCommerce_createDatabase.sql
What are you using to run the script? You are probably just running the script using the nopCommerce install page right? You can run the scripts manually.
The best way I have found to run sql scripts is the use the sql command prompt.