Hello, I'm usign SQLExpress and i've same problem. Can I use it? Why I've message:
1) Unable to use SQL Server because ASP.NET version 2.0 Session State is not installed on the SQL server. Please install ASP.NET Session State SQL Server version 2.0 or above.
2) login failed Impossibile aprire il database "G:\SITI\NOPCOMMERCE\NOPCOMMERCEWEB\APP_DATA\NOPCOMMERCE.MDF" richiesto dall'account di accesso. Accesso non riuscito. Accesso non riuscito per l'utente 'Blucons-Glauco\Admin'
1) By default nopCommerce uses in-process session state. But if you want to use an out-of-process SQL Server database to store state information, you should install it first. You should execute "aspnet_regsql -S serverName -U userName -P password -ssAdd".
You can read about session state configuration here
ok, my computer use 'Blucons-Glauco\Admin' user from visual studio 2005 web servr debug, and 'NT AUTHORITY\SERVIZIO DI RETE' / 'NT AUTHORITY\NETWORK SERVICE' form IIS.
Both users can't acces to Database. I think that the users can't execute the storedProcedure. Is possible? How can I resolve it?
I've just installed NopCommerce, and when I run it form '//localhost:123/', I recivie the error message 'Cannot open user default database. Login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.'
Normally, with asp.net application, I don't have to modify the permission for DB. I've 3 application with sqlExpress DB and no more setup are necessary.
however, the user NT AUTHORITY\NETWORK SERVICE is db_datareader and db_datawriter, but this user can't execute the storedProcedure
I've tested the same database in the same directory, with custom testApplication using System.Data.SlqClient connection and command, and not have error.
How is possible? Moreover, when other application is started and conneciont opened, NopCommerce can connect with database without problem The same code in the NopCommerce module, releas the same connection error!!!!!!!!!!!!!!!!!!!
Can you help me?
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.