Last post Feb 24, 2017 02:45 PM by Dmitry Sikorsky
Feb 24, 2017 10:43 AM|satyam.nwd|LINK
I am devolving an web application where i have to read data from DB and populate in the grid view.
i am getting below error "The SELECT permission was denied on the object 'ct_event', database 'ULT_X', schema 'dbo'."
user have access to run the select command in the sql browser. but in the Asp.net it's give the error.
user don't have admin access on the sql server.
Feb 24, 2017 02:45 PM|Dmitry Sikorsky|LINK
Check your connection string (or post it here without the password). I think the problem is in the connection string. Maybe it is because of the wrong user name.
Are you login in SQL Server Auth when testing access? Or in Windows auth?
This is 100% working connection string, tested in ASP.NET Core with MS SQL Server:
"ConnectionString": "Data Source=localhost;Initial Catalog=Platformus;MultipleActiveResultSets=True;Persist Security Info=True;User ID=platformus;Password=?"