Errors on Installation

Hello all.. Here are the steps I have performed..

1. Opened NOP solution in Visual Studio and built the solution
2. Ran prepare.bat and deploy.bat
2. Run the Deployable\NOP_2.40 web directory on local machine, all worked perfectly well including SQL Server installation
3. Copied above folder to remote host
4. Run site to get to install page
5. Enter in all details including remote SQL server (all are correct)

I then run into this error message on the remote host that seems to be referencing files on my local machine?? Can anyone shed some light on this??



nopCommerce installation

To complete this wizard you must know some information regarding your database server ("connection string"). Please contact your ISP if necessary. If you're installing on a local machine or server you might need information from your System Admin.

    Setup failed: System.Data.SqlClient.SqlException (0x80131904): The SELECT permission was denied on the object 'TABLES', database 'mssqlsystemresource', schema 'INFORMATION_SCHEMA'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() at System.Data.Objects.ObjectContext.ExecuteStoreQueryInternal[TElement](String commandText, String entitySetName, MergeOption mergeOption, Object[] parameters) at System.Data.Objects.ObjectContext.ExecuteStoreQuery[TElement](String commandText, Object[] parameters) at System.Data.Entity.Internal.InternalContext.ExecuteSqlQuery[TElement](String sql, Object[] parameters) at System.Data.Entity.Internal.InternalContext.ExecuteSqlQueryAsIEnumerable[TElement](String sql, Object[] parameters) at System.Data.Entity.Internal.InternalContext.ExecuteSqlQuery(Type elementType, String sql, Object[] parameters) at System.Data.Entity.Internal.InternalSqlNonSetQuery.GetEnumerator() at System.Data.Entity.Internal.InternalSqlQuery`1.GetEnumerator() at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) at Nop.Data.Initializers.CreateTablesIfNotExist`1.InitializeDatabase(TContext context) in c:\Users\Ryan\Desktop\FBU_Test\Libraries\Nop.Data\Initializers\CreateTablesIfNotExist.cs:line 39 at System.Data.Entity.Database.<>c__DisplayClass2`1.<SetInitializerInternal>b__0(DbContext c) at System.Data.Entity.Internal.InternalContext.<>c__DisplayClass5.<PerformDatabaseInitialization>b__3() at System.Data.Entity.Internal.InternalContext.PerformInitializationAction(Action action) at System.Data.Entity.Internal.InternalContext.PerformDatabaseInitialization() at System.Data.Entity.Internal.LazyInternalContext.<InitializeDatabase>b__4(InternalContext c) at System.Data.Entity.Internal.RetryAction`1.PerformAction(TInput input) at System.Data.Entity.Internal.LazyInternalContext.InitializeDatabaseAction(Action`1 action) at System.Data.Entity.Internal.LazyInternalContext.InitializeDatabase() at System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(Type entityType) at System.Data.Entity.Internal.Linq.InternalSet`1.Initialize() at System.Data.Entity.Internal.Linq.InternalSet`1.get_InternalContext() at System.Data.Entity.Internal.Linq.InternalSet`1.ActOnSet(Action action, EntityState newState, Object entity, String methodName) at System.Data.Entity.Internal.Linq.InternalSet`1.Add(Object entity) at System.Data.Entity.DbSet`1.Add(TEntity entity) at Nop.Data.EfRepository`1.Insert(T entity) in c:\Users\Ryan\Desktop\FBU_Test\Libraries\Nop.Data\EfRepository.cs:line 36 at Nop.Services.Installation.InstallationService.<InstallMeasures>b__f(MeasureDimension x) in c:\Users\Ryan\Desktop\FBU_Test\Libraries\Nop.Services\Installation\InstallationService.cs:line 375 at System.Collections.Generic.List`1.ForEach(Action`1 action) at Nop.Services.Installation.InstallationService.InstallMeasures() in c:\Users\Ryan\Desktop\FBU_Test\Libraries\Nop.Services\Installation\InstallationService.cs:line 375 at Nop.Services.Installation.InstallationService.InstallData(String defaultUserEmail, String defaultUserPassword, Boolean installSampleData) in c:\Users\Ryan\Desktop\FBU_Test\Libraries\Nop.Services\Installation\InstallationService.cs:line 9399 at Nop.Web.Controllers.InstallController.Index(InstallModel model) in c:\Users\Ryan\Desktop\FBU_Test\Presentation\Nop.Web\Controllers\InstallController.cs:line 429

I can now replicate this issue on the local machine by pointing the settings.txt file to the remote DB.

It is trying to access system tables on the remote database and getting an error (as expected).

The SELECT permission was denied on the object 'TABLES', database 'mssqlsystemresource', schema 'INFORMATION_SCHEMA'.

Line 37:                 {
Line 38:                     //we have some table names to validate
Line 39:                     var existingTableNames = new List<string>(context.Database.SqlQuery<string>("SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE table_type = 'BASE TABLE'"));
Line 40:                     createTables = existingTableNames.Intersect(_tablesToValidate, StringComparer.InvariantCultureIgnoreCase).Count() == 0;
Line 41:                 }


Source File: C:\NOP\Libraries\Nop.Data\Initializers\CreateTablesIfNotExist.cs    Line: 39

Are you trying to "Create the database" during install?  Instead, manually create the db with the host control panel, the use that db name during install.

I have tried both.

I have created the DB on the remote server via SQL but the same error persists. I guess the real issue is, why is it trying to access system tables?