Red Gate forums :: View topic - Backup File Location on Network - Unable to drill down
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup Previous Versions
SQL Backup Previous Versions forum

Backup File Location on Network - Unable to drill down

Search in SQL Backup Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
TCLiven



Joined: 23 Sep 2009
Posts: 3

PostPosted: Wed Sep 23, 2009 7:12 pm    Post subject: Backup File Location on Network - Unable to drill down Reply with quote

We have several SQL servers being backed up with Red Gate. All servers but two have the option to drill down to specific network shared folders within the backup file location field. The servers specifically can access the network shared folders via unc and network neighborhood with no problems, so the permissions are OK. It is just Red Gate that will not allow that drill down. Is there anything specific that needs to be config'd to allow this via Red Gate?

I did not setup the other servers, I just built a new SQL server that is having this issue... Any advice is greatly appreciated. Thanks
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 937
Location: Red Gate Software

PostPosted: Thu Sep 24, 2009 8:45 pm    Post subject: Reply with quote

Thank you for your post into the forum.

New to SQL Backup V6, users can create a new registry key and list the user accounts that are able to browse.

The Registry value name is BrowsingUserList. Key type is either REG_SZ (single value) or REG_MULTI_SZ (multiple names) and the value data list the user names or names and must be in the DOMAIN\user format.

Can you please try configuring the above registry on the SQL Server with SQL Backup Server Components installed in the following registry directory:

HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\(local) or SQL Instance Name

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
TCLiven



Joined: 23 Sep 2009
Posts: 3

PostPosted: Thu Sep 24, 2009 8:47 pm    Post subject: Reply with quote

Thanks for the reply however this post is for SQL Backup 5. We have not yet upgraded to 6. Can I perform this same registry hack within 5?

Update -> I have confirmed that I can not use this registry hack in SQL Backup 5 since the path's are not there.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6670

PostPosted: Fri Sep 25, 2009 6:42 pm    Post subject: Reply with quote

Just to point out, prior to 6.0, you have to do quite a bit of security configuration to get the file browser working when you use Windows authentication in SQL Backup's UI and are running the UI from a computer other than the SQL Server and the share was on a third computer. This situation causes a "double-hop" authentication issue that you can only work around by ensuring that you authenticate to the SQL Server using Kerberos.

Versions 5.3 and lower simply require you to be a member of the computer's local administrator group, then the file browser would use the SQL Server account credentials. It's a bit messy, I'll admit. That's why the "browsinguserlist" registry key came into being.
Back to top
View user's profile Send private message
TCLiven



Joined: 23 Sep 2009
Posts: 3

PostPosted: Fri Sep 25, 2009 7:18 pm    Post subject: Reply with quote

We are on version 5.4. The user as well as the sql service (just to be safe) is part of the local admin group. Bummer.. still no luck..
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6670

PostPosted: Mon Sep 28, 2009 11:14 am    Post subject: Reply with quote

In 5.4, you essentially need to configure the SQL Server and SQL Server services for Kerberos to avoid the NTLM double-hop issue.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group