Backup SQL to Network Share

If you want to backup the SQL server to a network share, then this account will not have permissions to do so. You'll need to change the SQL Server account to perform such a backup.

The account you create should be an ordinary User account, and have permissions to access the network share.

Stop the SQL service. Go to Start —> Run —> services.msc select MSSQLSERVER. Right click to choose "Properties".

Select the "LogOn" tab.

Select "This account" and provide an account that has rights to access the shared network. Click 'OK.'

Restart SQL Server. Backups should work successfully now.

other Windows Related Tips...

• Activesync complains that the Outlook Profile has changed
  
• Allow Non Administrators to change the PC time in a 2003 Domain Environment
  
• Add alt-text to an image in a Signature in Outlook 2007
  
• Arcserve log files consume Diskspace
  
• Manipulate Autocomplete cache in Outlook
  
• BackupExec Exchange Writer Issues
  
• Disable messages from being Marked as Read after Previewing in Outlook
  
• Exchange IS doesn′t start on boot with Symantec AV installed
  
• Configure Exchange 2003 to reject mail for unknown users
  
• Forward an Email message as an attachment
  
• IE - Open in New Window Doesn′t Work
  
• Word 2007 doesn′t register properly over old version - Mail Merge Problem
  
• MYOB Error opening - lock files
  
• Network Printer Setups
  
• Nod32 Antivirus Setup Version 3
  
• Nod32 Antivirus Setup Version 2 **old**
  
• Installing Microsoft Office 97 on Windows XP SP2
  
• Outlook 2000 - Send Messages Later
  
• Keyboard + Mouse stop working after PC Anywhere installation or removal
  
• Windows Update and Proxy Servers in Vista
  
• Windows Update and Proxy Servers WinXP
  
• Purge a Directory in Windows automatically
  
• Change RDP Listening Port
  
• Remove Automatic Restart After Windows Updates
  
• Cannot Exclude Directories - SBS 2003 Backup Wizard
  
• Locating scanpst.exe
  
• Telnet in Windows Vista
  
• Make Thunderbird use Deleted Items instead of Trash
  
• Files and settings transfer wizard fails
  
• Vacation Messages
  
• Vista Samba problem renaming folder
  
• Win2k Server - Options to Configure Root Hints or Forwarders Are Unavailable
  
• Clear Temporary 90 day license Win2k Terminal Services
  
• Windows 98 - Errors with RAM over 512mb
  
• Windows XP VPN Setup Instructions