Getting "invalid authorization specification" when creating linked server
Figured out the problem. Even though the user I was adding to the Linked Server security section had permissions into the target database, the user I was logged into the SQL Server instance at the moment didn't. Since the error message is incredibly unhelpful (it doesn't say which user failed to log in), I discovered this entirely by accident.