Hello, i’m trying to export the data using Octopus Export Wizard but i’m getting below error:
Error: SQL Error 4060 - Cannot open database “Octopus” requested by the login. The login failed.
Error: Login failed for user ‘local windows authentication’.
Error: System.Data.SqlClient.SqlException
However, I’m able to log into the SQL Server Management Studio with the Windows authentication, but then I cannot browse the Octopus database.
To upgrade our current instance from 4.1.4 to 2018.10.3 I need to the Data to test with the new LTS version on our test environment.
Looking at the information provided it appears that the account you are using doesn’t have the required permissions to access your Octopus database. You will need to reach out internally to find out who has the permissions required to grant access to your account.
You can confirm which account your Octopus Server is using to access the database by browsing to c:\Octopus and inspecting the Octopus.Server.config file, below is the line you are looking for: key="Octopus.Storage.ExternalDatabaseConnectionString">Data Source=(local)\SQLEXPRESS;Initial Catalog=Octopus;Integrated Security=True</set>
Please let me know if you have any further questions,