ENVIRONMENT: Commerce 1.0 SP1, Win 7, SQL Server 2005 Express
Commerce installation fails every time at step 4 (set up database). Stacktrace:
(there is more to the stacktrace description, but the MediaChase window does not let me see it all, and I cannot copy the text with my cursor..)
It seems related to the admin user I created for use with Commerce. From the installation instructions:
"Creating an SQL login. (...) - Enter a name for the new login (admin for example), give the user all roles and permissions."
I set the roles "public" and "sysadmin" under the Server Roles tab, but where else should I set "all roles and permissions"?
The error described above ocurrs when I use SQL Authentication for the Database Owner. Using Windows Authentication instead seems to work for me.
It's recommended that you use SQL Authentication for both the Database Owner and the SQL Admin.
In regards to which roles and permissions the account needs, just select the two roles Public and sysadmin.
I had a similiar problem when setting up the database locally even though I had set up a SQL Admin user as described.
I used sa as the SQL admin and things set up fine for me.
David, did you use SQL Server 2008? (I now see that the eCommerce system requirements lists 2008 as minimum).
However, I experience the same error on both 2005 and 2008. Feels like I'm going in circles here :-)
I have tried having the sites locally and using an SQL Server 2008 installation on another machine in my domain, but no go. Is this not possible/not recommended?
Yes, I used named SQL 2008 instance. I did explicitly name my instance rather than use the ".\SQL2008" notation as it was recommended in the instructions.
As I mentioned earlier the first attempt to install failed when using a SQL admin user I set up for the purpose. So I completely started again, new EPiServer instance, databases etc. After using the sa user all worked fine.
Good luck - its a complicated beast and I'd be interested to hear if you get it installed :)!
So you have already tried installing fresh on a SQL 2008 server and you get the same error? That's very strange!
How do you create your database owner? In the installation or manually?
Seems to work if I create both the database owner account AND the SQL login before starting the eCommerce installation.
Note that I got this working on an SQL Server 2005 Express installation. Which part of this framework require 2008?