I am trying to establish a connection between two SQL severs located in different location and trying to read/fetch the tables. When I connect the remote Standard SQL Server from SQL Server Express and fetch table, it works fine. When I try to connect SQL Server Express from Standard SQL Server, I get an error Msg. Just to mention that I do have the writes to read, create, update tables in the Standard SQL Server.
Error Msg is:
Msg 15247, Level 16, State 1, Procedure sp_MSaddserver_internal, Line 34 [Batch Start Line 2] User does not have permission to perform this action.
Remote SQL Server is "DKLYDB3" and Local SQL Server is "PC89450\SQLEXPRESS"
Query which works fine is below.
exec sp_addlinkedserver @server='DKLYDB3'; SELECT * FROM [DKLYDB3].BRISK_AIS.dbo.Crossline;
Query which does not work is here.
exec sp_addlinkedserver @server='PC89450\SQLEXPRESS'; SELECT * FROM [PC89450\SQLEXPRESS].BRISK_AIS.dbo.Crossline;