March 29, 2016 at 5:48 pm
Hi All ,
I moved login from 1 server to another .
What I did is I script the login by right click and choose Create Login as
Example :
CREATE LOGIN [XYZ/Andy Lau] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english]
GO
Originally this login is set as sysadmin role (Public role and Sysadmin role are checked) but when I move it to the new server , sysadmin role is GONE . so Only Public role there
I am so curious why this could happen ?
Any feedback are highly appreciated
Cheers
March 30, 2016 at 5:18 am
You only created the login, not the permissions. You will need to GRANT permissions to the user. I believe you can use sys.server_principals to see what is on the old system.
March 30, 2016 at 8:52 am
djj is correct. Everything in SQL is a separate item. The login is separate from the user in a database. The permissions to objects are separate from both, as are roles.
If this should be a sysadmin,
ALTER SERVER ROLE [sysadmin] ADD MEMBER [XYZ/Andy La]
should fix things
April 3, 2016 at 10:24 pm
Thank you very much guys !
Really appreciate your feedback
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply