Proxy settings & backup to URL (Azure blob storage)

Published Jan 15 2019 05:14 PM 827 Views
Microsoft
First published on MSDN on Sep 29, 2016

With so many users new to Azure, Sometimes an issue appears more complex than it really is.

If you back up your databases to Azure blob storage but your company uses proxy servers for internet access, you will need to configure backuptoURL.exe.config  per SQL Server Backup to URL Best Practices and Troubleshooting .

We had a customer who called us for help because their backup to URL no longer worked after they implemented proxy server for their organization.   They continued to face issues even after they configured backuptoURL.exe.config file.

This is the error they received:

A nonrecoverable I/O error occurred on file " https://<storage acct name>.blob.core.windows.net/container1/<dbname>_backup_2016_09_29_105902.... " Backup to URL received an exception from the remote endpoint. Exception Message: Unable to connect to the remote server.

Customer also pointed out that using azCopy, he was able to copy files from the SQL machine to the same blob storage.  The account used to do azCopy was different from the SQL Server startup account. So we had customer start SQL Server with the account used for azCopy.  Then the backup url was successful.

It turned out that they didn’t configure proxy setting for the service account (they only configured proxy setting for the interactive user) to point to the proxy server.   After logging onto the SQL machine with the service account and configuring the proxy setting via IE, then their backup started to work with the service account.

Below are the a couple of screenshots on how you configure proxy server for an individual users

Jack Li |Senior Escalation Engineer | Microsoft SQL Server

twitter | pssdiag | Sql Nexus

%3CLINGO-SUB%20id%3D%22lingo-sub-318843%22%20slang%3D%22en-US%22%3EProxy%20settings%20%26amp%3B%20backup%20to%20URL%20(Azure%20blob%20storage)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-318843%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20MSDN%20on%20Sep%2029%2C%202016%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3EWith%20so%20many%20users%20new%20to%20Azure%2C%20Sometimes%20an%20issue%20appears%20more%20complex%20than%20it%20really%20is.%3C%2FP%3E%0A%20%20%3CP%3EIf%20you%20back%20up%20your%20databases%20to%20Azure%20blob%20storage%20but%20your%20company%20uses%20proxy%20servers%20for%20internet%20access%2C%20you%20will%20need%20to%20configure%20backuptoURL.exe.config%26nbsp%3B%20per%20%3CA%20href%3D%22https%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Fjj919149(v%3Dsql.120).aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20SQL%20Server%20Backup%20to%20URL%20Best%20Practices%20and%20Troubleshooting%20%3C%2FA%3E%20.%3C%2FP%3E%0A%20%20%3CP%3EWe%20had%20a%20customer%20who%20called%20us%20for%20help%20because%20their%20backup%20to%20URL%20no%20longer%20worked%20after%20they%20implemented%20proxy%20server%20for%20their%20organization.%26nbsp%3B%26nbsp%3B%20They%20continued%20to%20face%20issues%20even%20after%20they%20configured%20backuptoURL.exe.config%20file.%3C%2FP%3E%0A%20%20%3CP%3EThis%20is%20the%20error%20they%20received%3A%3C%2FP%3E%0A%20%20%3CP%3EA%20nonrecoverable%20I%2FO%20error%20occurred%20on%20file%20%22%20%3CA%20href%3D%22https%3A%2F%2F%26lt%3Bstorage%20acct%20name%26gt%3B.blob.core.windows.net%2Fcontainer1%2F%26lt%3Bdbname%26gt%3B_backup_2016_09_29_105902.bak%3A%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20https%3A%2F%2F%3CSTORAGE%20acct%3D%22%22%20name%3D%22%22%3E.blob.core.windows.net%2Fcontainer1%2F%3CDBNAME%3E_backup_2016_09_29_105902.bak%3A%20%3C%2FDBNAME%3E%3C%2FSTORAGE%3E%3C%2FA%3E%20%22%20Backup%20to%20URL%20received%20an%20exception%20from%20the%20remote%20endpoint.%20Exception%20Message%3A%20Unable%20to%20connect%20to%20the%20remote%20server.%3C%2FP%3E%0A%20%20%3CP%3ECustomer%20also%20pointed%20out%20that%20using%20azCopy%2C%20he%20was%20able%20to%20copy%20files%20from%20the%20SQL%20machine%20to%20the%20same%20blob%20storage.%26nbsp%3B%20The%20account%20used%20to%20do%20azCopy%20was%20different%20from%20the%20SQL%20Server%20startup%20account.%20So%20we%20had%20customer%20start%20SQL%20Server%20with%20the%20account%20used%20for%20azCopy.%26nbsp%3B%20Then%20the%20backup%20url%20was%20successful.%3C%2FP%3E%0A%20%20%3CP%3EIt%20turned%20out%20that%20they%20didn%E2%80%99t%20configure%20proxy%20setting%20for%20the%20service%20account%20(they%20only%20configured%20proxy%20setting%20for%20the%20interactive%20user)%20to%20point%20to%20the%20proxy%20server.%26nbsp%3B%26nbsp%3B%20After%20logging%20onto%20the%20SQL%20machine%20with%20the%20service%20account%20and%20configuring%20the%20proxy%20setting%20via%20IE%2C%20then%20their%20backup%20started%20to%20work%20with%20the%20service%20account.%3C%2FP%3E%0A%20%20%3CP%3EBelow%20are%20the%20a%20couple%20of%20screenshots%20on%20how%20you%20configure%20proxy%20server%20for%20an%20individual%20users%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F68478iFCD54558BA722917%22%20%2F%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F68479i159AC8EC93D09157%22%20%2F%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3EJack%20Li%20%7CSenior%20Escalation%20Engineer%20%7C%20Microsoft%20SQL%20Server%3C%2FP%3E%0A%20%20%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2Fjackli8898%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Etwitter%20%3C%2FA%3E%20%7C%20%3CA%20href%3D%22http%3A%2F%2Fdiagmanager.codeplex.com%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20pssdiag%20%3C%2FA%3E%20%7C%20%3CA%20href%3D%22http%3A%2F%2Fsqlnexus.codeplex.com%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20Sql%20Nexus%3C%2FA%3E%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-318843%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Sep%2029%2C%202016%20%26nbsp%3B%20%26nbsp%3B%20With%20so%20many%20users%20new%20to%20Azure%2C%20Sometimes%20an%20issue%20appears%20more%20complex%20than%20it%20really%20is.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-318843%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EStorage%20Engine%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Jan 15 2019 05:14 PM
Updated by: