What permission for what user is needed on this view. Seems that migration script is not complete.

 

The SELECT permission was denied on the object 'vw_DSC_Product_Stock', database 'NAME', schema 'dbo'.

 

Line 60:         lblSearchKeywords.Text = keywords;

Line 61:         if (!string.IsNullOrEmpty(keywords)) {

Line 62:             lvwProducts.DataBind();

Line 63:             ProductCount = dpg2.TotalRowCount;

Line 64:             lvwPages.DataBind();

d:\XXXXXXXXXXXXXXXXXXX\Web\Controls\Core\Search.ascx.cs

 

 

Looks like your permission got screwed up during migration. Try running this file again. Ignore the errors in the end.

Should I use this password as it is :

PASSWORD = 'dsc XXX@XXXXXXXX'

 

I executed the script :

 

 

GRANT EXEC ON dbo.DSC_UserTrack_WhosOnline TO DSC_Public
 

It was executed correctly until the above statement.

 

Msg 15151, Level 16, State 1, Line 38
Cannot find the object 'DSC_List', because it does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 39
Cannot find the object 'DSC_List_Data', because it does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 40
Cannot find the object 'DSC_List_Field', because it does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 48
Cannot find the type 'IdValueUDT', because it does not exist or you do not have permission.
Msg 15232, Level 16, State 1, Line 2
A certificate with name 'dynamicCert' already exists or this certificate already has been added to the database.
Msg 15023, Level 16, State 1, Line 1
User, group, or role 'dynamicCertUser' already exists in the current database.
Msg 15151, Level 16, State 1, Line 29
Cannot find the object 'DSC_List_Data', because it does not exist or you do not have permission.
Msg 15557, Level 16, State 1, Line 3
There is already a signature by certificate 'dynamicCert'.
Msg 15557, Level 16, State 1, Line 4
There is already a signature by certificate 'dynamicCert'.
Msg 15557, Level 16, State 1, Line 6
There is already a signature by certificate 'dynamicCert'.
Msg 15557, Level 16, State 1, Line 7
There is already a signature by certificate 'dynamicCert'.
Msg 15557, Level 16, State 1, Line 8
There is already a signature by certificate 'dynamicCert'.
Msg 15557, Level 16, State 1, Line 9
There is already a signature by certificate 'dynamicCert'.
Msg 15557, Level 16, State 1, Line 10
There is already a signature by certificate 'dynamicCert'.
Msg 15557, Level 16, State 1, Line 11
There is already a signature by certificate 'dynamicCert'.
Msg 15557, Level 16, State 1, Line 12
There is already a signature by certificate 'dynamicCert'.
Msg 15557, Level 16, State 1, Line 13
There is already a signature by certificate 'dynamicCert'.
Msg 15557, Level 16, State 1, Line 14
There is already a signature by certificate 'dynamicCert'.
Msg 15557, Level 16, State 1, Line 15
There is already a signature by certificate 'dynamicCert'.
Msg 15557, Level 16, State 1, Line 16
There is already a signature by certificate 'dynamicCert'.
Msg 15557, Level 16, State 1, Line 17
There is already a signature by certificate 'dynamicCert'.
Msg 15557, Level 16, State 1, Line 18
There is already a signature by certificate 'dynamicCert'.
Msg 15557, Level 16, State 1, Line 19
There is already a signature by certificate 'dynamicCert'.
Msg 15557, Level 16, State 1, Line 20
There is already a signature by certificate 'dynamicCert'.
Msg 15557, Level 16, State 1, Line 21
There is already a signature by certificate 'dynamicCert'.
Msg 15151, Level 16, State 1, Line 22
Cannot alter the object 'dbo.DSC_ListData_Add', because it does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 23
Cannot alter the object 'dbo.DSC_ListData_AddField', because it does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 24
Cannot alter the object 'dbo.DSC_ListData_DeleteField', because it does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 25
Cannot alter the object 'dbo.DSC_ListData_Get', because it does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 26
Cannot alter the object 'dbo.DSC_ListData_GetById', because it does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 27
Cannot alter the object 'dbo.DSC_ListData_Update', because it does not exist or you do not have permission.
 

You can ignore these errors.

No error in search but no results, still not working when entering an SKU

In web.config you need to change the settings that make sense to you.

 

            <add name="SeachIngoredChars" value="[-',*\\(\\)]"/>
 

SeachIngoredChars or SeachIgnoredChars

 

I added but not working still.

If you want to search for "-", you will need to remove it from the configuration.

Ok , It wroked, but the keyword is misspelled : SearchingIngoredChars

 

 

Ah, thanks. We are fixing the typo.