Post reply

Login Information changed after moving to new server

  • March 30, 2016 at 5:18 am

    #1868534

    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

    #1868641

    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

    #1869399

    Thank you very much guys !

    Really appreciate your feedback

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply