I’m struggling to install Octopus and connect to an Azure SQL Database. The error is:
"There was a problem connecting to your SQL Server database. Error: SQL Error 18456 - Login failed for user ‘octopus’.
I turned on auditing on the database, and it successfully connects:
DATABASE AUTHENTICATION SUCCEEDED Principal name octopus
The next message is:
BATCH COMPLETED <batch_information><failure_reason>Err 208, Level 16, Server latitudetestserverInvalid object name ‘OctopusServerNode’.</failure_reason></batch_information>
statement: DELETE FROM OctopusServerNode
I seem to get the Login Error 18456 when I try to login to the master database. Is it possible the setup code is doing that? If so, that doesn’t make sense for Azure SQL Databases.