Problems upgrading 4.2 - 4.3

Hi Have 2 installs both hosted on the same server same sql server both with errors running the sql upgrade script.  Please see below if anyone could advise.  


(310 rows affected)
Msg 208, Level 16, State 1, Line 986
Invalid object name 'Language'.
Msg 208, Level 16, State 1, Line 1045
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 1053
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 1061
Invalid object name 'Setting'.
Msg 208, Level 16, State 6, Procedure DeleteGuests, Line 3 [Batch Start Line 1084]
Invalid object name 'DeleteGuests'.
Msg 208, Level 16, State 1, Line 1161
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 1170
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 1178
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 1186
Invalid object name 'Setting'.
Msg 4902, Level 16, State 1, Line 1196
Cannot find the object "Order" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1203
Cannot find the object "Discount" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1209
Cannot find the object "RewardPointsHistory" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 6, Procedure ProductLoadAllPaged, Line 3 [Batch Start Line 1391]
Invalid object name 'ProductLoadAllPaged'.
Msg 208, Level 16, State 6, Procedure DeleteGuests, Line 3 [Batch Start Line 1995]
Invalid object name 'DeleteGuests'.
Msg 4902, Level 16, State 1, Line 2083
Cannot find the object "GenericAttribute" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Line 2089
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 2097
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 2105
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 2113
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 2121
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 2129
Invalid object name 'Setting'.
Msg 208, Level 16, State 6, Procedure ProductLoadAllPaged, Line 3 [Batch Start Line 2134]
Invalid object name 'ProductLoadAllPaged'.

(1 row affected)
Msg 208, Level 16, State 1, Line 2924
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 2932
Invalid object name 'Setting'.

(173 rows affected)

(1 row affected)
Caution: Changing any part of an object name could break scripts and stored procedures.

(1 row affected)
Msg 208, Level 16, State 1, Line 3028
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3051
Invalid object name 'ActivityLogType'.
Msg 208, Level 16, State 1, Line 3065
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3122
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3140
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3148
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3156
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3169
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3177
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3185
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3193
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3201
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3209
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3217
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3225
Invalid object name 'Setting'.

(8 rows affected)

(1 row affected)

(1 row affected)

(1 row affected)

(1 row affected)

(1 row affected)

(1 row affected)

(1 row affected)

(1 row affected)
Msg 208, Level 16, State 1, Line 3251
Invalid object name 'Country'.
Msg 4902, Level 16, State 1, Line 3259
Cannot find the object "RewardPointsHistory" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Line 3264
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3272
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3280
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3289
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3297
Invalid object name 'Setting'.
Msg 208, Level 16, State 1, Line 3305
Invalid object name 'Setting'.

is your schema different than 'dbo'?
https://www.nopcommerce.com/en/boards/topic/81827/420-to-430-upgrade-failed/page/2

Are you executing the script in the correct database?  If you just connect to the server, then you may be in 'master'. You need to USE yourdbname.   If you think you are in the right DB, then check that you are in the right schema  (typically dbo)
SELECT SCHEMA_NAME()

Apologies on the delay,  After checking i've definitely run against the correct DB as see a transaction log also the schema looks the same as a db that has upgraded ok. Still running the upgrade i get the same errors.

Checking Connect is dbo Grant and also looking at the schema i can dbo visible.

As i'm no sql person i look to your guidance.

Regards

What tool are yu usn to connect to SQL sever ?  SSMS?

Execute this (and post results here.  Hide DB name if you like, but do confirm it's the correct one.)

SELECT DB_NAME()
SELECT SCHEMA_NAME()
select Name from sys.tables order by name

Hi Thanks for helping.

angnet
dbo

AclRecord
ActivityLog
ActivityLogType
Address
AddressAttribute
AddressAttributeValue
Affiliate
BackInStockSubscription
BlogComment
BlogPost
Campaign
Category
CategoryTemplate
CheckoutAttribute
CheckoutAttributeValue
Country
CrossSellProduct
Currency
Customer
Customer_CustomerRole_Mapping
CustomerAddresses
CustomerAttribute
CustomerAttributeValue
CustomerPassword
CustomerRole
DeliveryDate
Discount
Discount_AppliedToCategories
Discount_AppliedToManufacturers
Discount_AppliedToProducts
DiscountRequirement
DiscountUsageHistory
Download
EmailAccount
ExternalAuthenticationRecord
Forums_Forum
Forums_Group
Forums_Post
Forums_PostVote
Forums_PrivateMessage
Forums_Subscription
Forums_Topic
GdprConsent
GdprLog
GenericAttribute
GiftCard
GiftCardUsageHistory
Language
LocaleStringResource
LocalizedProperty
Log
Manufacturer
ManufacturerTemplate
MeasureDimension
MeasureWeight
MessageTemplate
News
NewsComment
NewsLetterSubscription
Order
OrderItem
OrderNote
PermissionRecord
PermissionRecord_Role_Mapping
Picture
PictureBinary
Poll
PollAnswer
PollVotingRecord
PredefinedProductAttributeValue
Product
Product_Category_Mapping
Product_Manufacturer_Mapping
Product_Picture_Mapping
Product_ProductAttribute_Mapping
Product_ProductTag_Mapping
Product_SpecificationAttribute_Mapping
ProductAttribute
ProductAttributeCombination
ProductAttributeValue
ProductAvailabilityRange
ProductReview
ProductReview_ReviewType_Mapping
ProductReviewHelpfulness
ProductTag
ProductTemplate
ProductWarehouseInventory
QueuedEmail
RecurringPayment
RecurringPaymentHistory
RelatedProduct
ReturnRequest
ReturnRequestAction
ReturnRequestReason
ReviewType
RewardPointsHistory
ScheduleTask
SearchTerm
Setting
Shipment
ShipmentItem
ShippingByWeightByTotalRecord
ShippingMethod
ShippingMethodRestrictions
ShoppingCartItem
SpecificationAttribute
SpecificationAttributeOption
StateProvince
StockQuantityHistory
Store
StoreMapping
StorePickupPoint
TaxCategory
TaxRate
TierPrice
Topic
TopicTemplate
UrlRecord
Vendor
VendorAttribute
VendorAttributeValue
VendorNote
Warehouse

Anyone got any ideas please, be appreciated.

Regards
Craig Mitchell