Access to the remote server is denied because no login-mapping exists, ASP.NET

I know my stored procedure works with the linked server, when i run it from a web project i get this error, apparently i do not have the correct user named in mapping to run against the linked server.
shelbyinfotechAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
dbaSQLConnect With a Mentor Commented:
if you configure the link from serverA to serverB, the login used in serverA linkes server needs to be the login from serverB

see this:
http://www.databasejournal.com/features/mssql/article.php/3116011
0
 
dbaSQLCommented:
what is the whole statement you used with sp_addlinkedserver?
0
All Courses

From novice to tech pro — start learning today.