Error occurs after attaching the database using SQL Authentication Blackbaud Management Console never prompts user to enter SQL Credentials
This issue can occur when creating a new Login in SQL Server management Studio(SSMS) there is one option “User must change Password at next Login” in general section. > If this option is checked when the user was created in SSMS and if that user has never logged-in even once to SSMS, this error may occur. The error “Failed to connect to server” prompts in BMC while attaching a DB using SQL Authentication for that particular user. > When above option is unchecked while creating a new user then this error is not reproducible.
Steps to resolve For existing users- Login to SQL Server once and change your password to use BMC seamlessly. While creating new users- Uncheck the option “User must change Password at next Login”.
Workaround: Attach the database using Windows Authentication