How can we help you today? How can we help you today?

SQL Error 17

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
cpetrich
0

Comments

2 comments

Sort by
  • petey
    Could you please check in the registry

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

    if there is an entry for 'SQLServerName'?
    petey
    0
  • 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]
    cpetrich
    0

Add comment

Please sign in to leave a comment.