I created a linked server which had been running fine. Something has changed since yesterday and for some reason it is throwing me an error.
So i created it;
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'AUXXX'',@useself=N'False',@locallogin=NULL,@rmtuser=N'zxxx',@rmtpassword='########'
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'AUXXX',@useself=N'True',@locallogin=N'zxxx',@rmtuser=NULL,@rmtpassword=NULL
I then wrote a query to test it ; Select * from AUXXX.database.tablename
This works fine and returns expected results.
i then tried to create a SP using the same query
Create Procedure NEWProcedure as Select * from AUXXX.database.tablename and i got this error:
Msg 7416, Level 16, State 1, Procedure NEWProcedure, Line 211 [Batch Start Line 9]
Access to the remote server is denied because no login-mapping exists.
Not sure what to do would love some advice please if you have any?