• State Verified Answer
  • +1 person also asked this people also asked this
  • Locked Locked
  • Replies 5 replies
  • Answers 2 answers
  • Subscribers 15 subscribers
  • Views 8772 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Failed to login to SQL Instance '(local)'

tsmith
over 7 years ago

When backing up one of my servers that is running SQL on it I keep getting the "Failed to login to SQL Instance '(local)'".  Any suggestions?

Parents
  • 0 over 7 years ago
    Sure.
    The quickest way to do this is to go to the "Create Backup" window
    Then, expand the client where the SQL Plugin is installed
    -Highlight the SQL Plugin-> Hit the "Actions" button above and Select "Configure"
    -A screen to enter the SQL Authentication type will come up
    -Select the SQL Authentication type, and then enter the correct authentication info
    -Click OK and make sure you can then expand the plugin to see the SQL Databases
    -If it is successful, it will show you the databases
    -You can then close the Window and attempt the backup again.

    (In MOST cases, the notes below are not an issue when the above items are done, however...)
    *Note, if it still fails after this is done, it would then indicate that while the credentials are sufficient to login to SQL, they may not have the required permissions to actually conduct a backup/restore against the databases.
    You will need to make sure that the credentials you supplied have the required permissions/roles to allow for backup and restore.

    Please refer to the SQL Plugin User's Guide under the section "Configuring the Plugin" to ensure these requirements are met.
    support.quest.com/.../
Reply
  • 0 over 7 years ago
    Sure.
    The quickest way to do this is to go to the "Create Backup" window
    Then, expand the client where the SQL Plugin is installed
    -Highlight the SQL Plugin-> Hit the "Actions" button above and Select "Configure"
    -A screen to enter the SQL Authentication type will come up
    -Select the SQL Authentication type, and then enter the correct authentication info
    -Click OK and make sure you can then expand the plugin to see the SQL Databases
    -If it is successful, it will show you the databases
    -You can then close the Window and attempt the backup again.

    (In MOST cases, the notes below are not an issue when the above items are done, however...)
    *Note, if it still fails after this is done, it would then indicate that while the credentials are sufficient to login to SQL, they may not have the required permissions to actually conduct a backup/restore against the databases.
    You will need to make sure that the credentials you supplied have the required permissions/roles to allow for backup and restore.

    Please refer to the SQL Plugin User's Guide under the section "Configuring the Plugin" to ensure these requirements are met.
    support.quest.com/.../
Children
No Data