SQL Error 17

cpetrich

I registered a named instance <servername>\LOCALDEV. I used the wizard.

Backup failed, complaining it couldn't find the server. Note that the server name is NOT LOCALDEV\LOCALDEV

See below

I have no idea why it is trying to connect to a server named <instancename>\<instancename>

Thank you

SQL Backup log file 7.1.0.72

-SQL "BACKUP DATABASE [License_Apps] TO DISK = 'T:\FileTransfer\SGN2SGN\_License_Apps.sqb' WITH ERASEFILES = 1b , CHECKSUM, DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, COMPRESSION = 4, INIT, THREADCOUNT = 3, COPY_ONLY "

---

ERRORS AND WARNINGS

---

6/18/2013 1:27:48 PM: Backing up License_Apps (full database) on LOCALDEV instance to:
6/18/2013 1:27:48 PM: T:\FileTransfer\SGN2SGN\_License_Apps.sqb

SQL error 17: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Server : LOCALDEV\LOCALDEV
Windows authentication
6/18/2013 1:28:06 PM: Failed to connect to SQL Server instance: LOCALDEV\LOCALDEV

petey

Could you please check in the registry

HKLM\Software\Red Gate\SQL Backup\BackupSettingsGlobal\LOCALDEV

if there is an entry for 'SQLServerName'?

cpetrich

No. However, uninstall at the machine, then reinstall seemed to get things working.

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate]

[HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup]

[HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettings]

[HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettings\(LOCAL)]

[HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettings\LOCALDEV]

[HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal]

[HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\(LOCAL)]
"DataPath"="C:\\ProgramData\\Red Gate\\SQL Backup\\Data\\(local)"
"LogFolder"="C:\\ProgramData\\Red Gate\\SQL Backup\\Log\\(local)"
"ServiceLogin"=""
"CopiedVersion4Settings"=dword:00000001
"Copied32BitSettings"=dword:00000001
"SkipChecks"=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\LOCALDEV]
"DataPath"="C:\\ProgramData\\Red Gate\\SQL Backup\\Data\\LOCALDEV"
"LogFolder"="C:\\ProgramData\\Red Gate\\SQL Backup\\Log\\LOCALDEV"
"ServiceLogin"=""
"CopiedVersion4Settings"=dword:00000001
"Copied32BitSettings"=dword:00000001
"SkipChecks"=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\InstalledInstances]

[HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\InstalledInstances\(LOCAL)]

[HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\InstalledInstances\LOCALDEV]