Access to the remote server is denied because no login-mapping exists
I am trying to access an MSQL server through Enterprise Manager. I am trying to update a stored procedure. When I try and save the storeds procedure I get the error "Error 7416: Access to the remote server is denied because no login-mapping exists". This was working fine up until last week and as far as I am aware no changes have been made.
I am part of the domain admins group and my collegues in that group can alter it but I cannot. I also cannot alter it if I connect to the server as sa.
This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.