Error " Database does not exist or you don't have permissions to connect to it .." during installation

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
11 years ago
Hi,
i'm performing a fresh installation of Nop 2.50 in my local environment. (win7 pro 64bit, iis 7.5, sqlserver 2008)
1) I have previously created a new db in sql server called "test" with no particular settings. See Here (http://dl.dropbox.com/u/22852135/screen3.JPG)
2) Used SQL Server (or SQL Express) database. See Here (http://dl.dropbox.com/u/22852135/screen1.JPG)
3) Used integrated Windows authentication

but i receive this error
Setup failed: System.Exception: Database does not exist or you don't have permissions to connect to it in Nop.Web.Controllers.InstallController.Index(InstallModel model) in f:\Own\nopDownloads\downloads\nopCommerce_2.50_Source\Presentation\Nop.Web\Controllers\InstallController.cs:riga 406

see Here (http://dl.dropbox.com/u/22852135/screen2.JPG)

Could you please tell me step by step how to solve?
Do i have to use a different autentication?
Thanks
0
11 years ago
Have a look here and see if this helps.

http://blogs.msdn.com/b/sql_protocols/archive/2008/04/30/steps-to-troubleshoot-connectivity-issues.aspx
1
11 years ago
1) I have previously created a new db in sql server called "test" with no particular settings.

One other thing, I noticed in the screenshots that you entered "test" as the name of the database. NOP will create the database itself, there is no need to create a database advance. Try running the install again and this time enter a name for a database that you know for certain DOES NOT already exist.

That could be the problem.
0
11 years ago
Thanks JonEvans,
very useful link but it still doesn't work...i will check again
Yes i even tryed to let him create the db just givin the name but... without success!

...the most ridiculous thing?  I've installed Nop in another PC with the same environement and it worked immediately. The only difference is that the SQL in the second PC is set to mixed authentication.
0
10 years ago
silviuz wrote:
Hi,
i'm performing a fresh installation of Nop 2.50 in my local environment. (win7 pro 64bit, iis 7.5, sqlserver 2008)
1) I have previously created a new db in sql server called "test" with no particular settings. See Here (http://dl.dropbox.com/u/22852135/screen3.JPG)
2) Used SQL Server (or SQL Express) database. See Here (http://dl.dropbox.com/u/22852135/screen1.JPG)
3) Used integrated Windows authentication

but i receive this error
Setup failed: System.Exception: Database does not exist or you don't have permissions to connect to it in Nop.Web.Controllers.InstallController.Index(InstallModel model) in f:\Own\nopDownloads\downloads\nopCommerce_2.50_Source\Presentation\Nop.Web\Controllers\InstallController.cs:riga 406

see Here (http://dl.dropbox.com/u/22852135/screen2.JPG)

Could you please tell me step by step how to solve?
Do i have to use a different autentication?
Thanks



I had this same problem with nopCommerce 3.0 version yesterday and it took me full day to find out what exactly the problem was. In my case I was using wrong application pool ('IIS APPPOOL\ASP.NET v4.0 Classic') where as it should be ASP.NET v4.0 Integrated mode.

I hope this might help someone and save some time.
1
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.