troubleshooting Question

db_datawriter, linked server definition

Avatar of dbaSQL
dbaSQLFlag for United States of America asked on
Microsoft SQL ServerMicrosoft SQL Server 2005
18 Comments1 Solution651 ViewsLast Modified:
I have a linked server login on all of my machines.  The associated database user has is a member of db_datareader and db_datawriter within each user database.   The user has also been granted EXECUTE, to be able to exec all procs.

the linked servers are each running under the context of this user

i am executing a proc remotely, and continually failing w/this:
Msg 1088, Level 16, State 7, Procedure procedurename, Line 19
Cannot find the object "tablename" because it does not exist or you do not have permissions.

the procedure does an insert into a table.  the user is a member of db_datawriter.

i have used this linked server definition a gazillion times.  i can't determine the source of this problem.
the table is definitely there.  logged in locally, the proc runs just fine

Database Architect - Dba - Data Scientist

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 18 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 18 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros