Msg 15007, Level 16, State 1, Procedure _addlinkedsrvlogin, Line 76 Now, the question was how can I provide a mapping to a user? Here was the error which would come if we even try that. CREATE USER WITHOUT LOGIN WITH DEFAULT_SCHEMA= It is important to note is that user_no_login is NOT a login but a user in the database created using below command. Msg 7416, Level 16, State 2, Procedure usp_fetch_data, Line 5 Īccess to the remote server is denied because no login-mapping exists. CREATE PROCEDURE usp_fetch_dataĪnd here is the error message when I execute it as below. The procedure is created in database SQLDB0. Here is an oversimplified version of the stored procedure. Here is the error which was coming when we were executing a stored procedure.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |