Help get this topic noticed by sharing it on Twitter, Facebook, or email.

CREATE TABLE permission denied

Can you provide some guidance on setting up linked server? We have created a server running Windows 2012 and SQL Server Express 2008 R2 and installed DBAmp on it. On this server (Server1) we have created the [salesforce backups] database and the stored procedures. The connection to Salesforce is working and we can successfully run the following on Server1.

EXEC dbo.sf_refreshall 'SALESFORCE', 'Yes'

Now we need to be able to execute stored procedures from another server (Server2). Server2 is running Windows 2003 and SQL Server 2008 R2 STD. On Server2 we have created a linked Server to Server1. When we run the following -

EXEC [Server1].[salesforce backups].dbo.SF_Refresh 'SALESFORCE', 'CustomTable_SF__c', 'Yes'

We get the following error -

Msg 262, Level 14, State 1, Line 1
CREATE TABLE permission denied in database 'salesforce backups'.
--- Starting SF_Refresh for CustomTable_SF__c V3.1.5

How do we set the permissions to allow this to run?
1 person has
this question