What are the challenges you face when working across database platforms? Take the survey
Options

SQL Error 17

cpetrichcpetrich Posts: 3
edited June 20, 2013 11:24AM in SQL Backup Previous Versions
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

Comments

  • Options
    peteypetey Posts: 2,358 New member
    Could you please check in the registry

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

    if there is an entry for 'SQLServerName'?
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    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]
Sign In or Register to comment.