March 2, 2021 at 7:27 am
Hello All
I was tasked with setting up a new instance on the same server, but with a higher version (from 2012 to 2016).
User would like to test higher version before moving dbs there.
After installation I recreated all the logins using these guidelines - https://www.sqlshack.com/move-or-copy-sql-logins-with-assigning-roles-and-permissions/
User confirmed successful login, but one thing that's different already is that they cannot see all Logins from Security folder in a new one. What am I missing there?
KR,
John
March 3, 2021 at 8:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
March 3, 2021 at 9:24 am
Okay I found out that I was missing - server wide securables.
For anyone with same problem you can either check it directly from SSMS in Instance > Security > Logins > Login Properties > Securable or through this query
SELECT l.name as grantee_name, p.state_desc, p.permission_name
FROM sys.server_permissions AS p JOIN sys.server_principals AS l
ON p.grantee_principal_id = l.principal_id
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply