I have moved mdf and log files from sql sever 2014 to 2017 but i tried to remove all users and then re-created them with same name. Now i am facing issues.
I could not be able to access database through ssms but my application is using same username and password.
I have created user with below script
Create LOGIN Lakes_Edit WITH PASSWORD='276', CHECK_POLICY=OFF ;
DENY VIEW ANY DATABASE TO Lakes_Edit;
ALTER AUTHORIZATION ON DATABASE:: Lakes TO Lakes_Edit;
Now i'm unable to access lakes db? Please help to to resolve it