Lost SQL access

carlos.teixeira's Avatar

carlos.teixeira

21 Apr, 2017 09:42 AM

Hello,

I have recently starting working for a new company and was about to update octopus server to the latest release as we are fairly back in terms of updates.
So I went ahead and started backing up everything until I got to the database. As my user does not have access and the person that installed octopus is no longer in my company, neither left any credentials for it,I do not have access to the OctopusDeploy database.
Is there any way to find the credentials that the octopus deploy server uses to connect to the database?

Best Regards,
Carlos

  1. Support Staff 1 Posted by Kenneth Bates on 24 Apr, 2017 06:35 AM

    Kenneth Bates's Avatar

    Hi Carlos,

    Thanks for getting in touch! You can see how Octopus connects to your database by checking your connection string. This is located in your OctopusServer.config file (located in C:\Octopus in standard installations), and it is displayed in your Octopus Manager window (see my first screenshot) on your Octopus server.

    If your Octopus instance connects to your database via SQL authentication, your connection string will show the username and password. If it's integrated authentication, it won't show username and password in the connection string, and database connections are made by the user that is running your Octopus service. You can find this user by checking the properties of the 'OctopusDeploy' service listed in your services management console (see my second screenshot). If it's running as local system, then the local system account has access to the database.

    I hope this helps! Don't hesitate to reach out if you have any further questions or concerns.

    Best regards,

    Kenny

  2. 2 Posted by carlos.teixeira on 11 May, 2017 03:32 PM

    carlos.teixeira's Avatar

    Thank you Kenny you are a life saver :D

    You can close this issue.

    Thanks,
    Carlos Teixeira

  3. Support Staff 3 Posted by Kenneth Bates on 12 May, 2017 12:36 AM

    Kenneth Bates's Avatar

    Hi Carlos,

    I'm glad that helped! Don't hesitate to reach out anytime if you have any further questions. :)

    Best regards,

    Kenny

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac

Recent Discussions

25 May, 2017 02:43 AM
25 May, 2017 02:39 AM
25 May, 2017 02:36 AM
25 May, 2017 02:34 AM
25 May, 2017 02:22 AM

 

25 May, 2017 02:08 AM
25 May, 2017 01:10 AM
25 May, 2017 01:04 AM
24 May, 2017 11:59 PM
24 May, 2017 08:55 PM
24 May, 2017 08:14 PM