v38 install bug

hezyz wrote:

Hi Hezy,
there are different versions of MS SQL Server Express. The tools (and the profiler) are free; but only contained in the bigger packs:
https://www.microsoft.com/en-us/download/details.aspx?id=43351
* Express with Tools (SQLEXPRWT)
* SQL Server Management Studio Express (SQLManagementStudio)
* Express with Advanced Services (SQLEXPRADV)

Feature list here: https://msdn.microsoft.com/en-us/library/ms174219.aspx

Or the Developers³ ( https://www.youtube.com/watch?v=Vhh_GeBPOhs ) version for free: https://www.microsoft.com/en-us/cloud-platform/sql-server-editions-developers

Otherwise http://expressprofiler.codeplex.com/

HTH

a.m. wrote:

Hi,
Is this solved now or should we continue to test? With which versions of SQLServer?

My first look would be at the permissions as always:

* If the shopsoftware should create the database, the apppool have to be dbo before.
(Because this is too high for further productive state, this should be removed by hand after install)

BestPractice
* If the db is created by hand, the db is in the authorization context of the (System- and/or SQLServer)Admin = SQLAdmin is dbo. The shopsoftware will access through the context of the apppool. To set the apppool could be a bit buggy/tricky in some environments.

devustocomp wrote:
We cannot reproduce this issue. That's why asking our community to do it (test).

Can you install nopCommerce without any errors?

devustocomp wrote:

edit: messed up dbo with db_creator:
the apppool have to be db_creator in the master db ...

and can't find the edit button for the old post - not my day ;-)

And sorry, can't test with the src pack due to other problems on my side