SSMS Cannot write into file 'C:\ServiceBrokerTest'. Verify that you have write permissions

Vote count:

0

I am trying to set the Service Broker on my databases following this walk-through.

When running the command in SSMS

BACKUP CERTIFICATE InstTargetCertificate
  TO FILE = 
N'C:\ServiceBrokerTest\';
GO

I get the error

Msg 15240, Level 16, State 1, Line 16
Cannot write into file 'C:\ServiceBrokerTest'. Verify that you have write permissions, that the file path is valid, and that the file does not already exist.

I changed N'C:\ServiceBrokerTest\ for N'C:\ServiceBrokerTest\cert.cer'; or N'C:\ServiceBrokerTest'; but did not make any difference.

Both folder C: and ServiceBrokerTest have the following users with full control

• SYSTEM


• LOCAL SERVICE


• NETWORK SERVICE


• Administrators


• Users

How do I fix this problem please?

asked 4 mins ago

Greg

81

SSMS Cannot write into file 'C:\ServiceBrokerTest'. Verify that you have write permissions