Hi I'm migrating a database to SQL Server 2012, and I have a problem.
Let me start by saying the application (ISV) has horrible security! So try not to cringe too much.
- The app logs in with sa authentication.
- The sa password is hard-coded into the app.
So the sa password on the 2012 instance must match the app login. However, it does not meet the 2012 password requirements.
Is there a way to override this functionality?
Best Answer
Try
(I feel dirty now)
In order to mitigate some of the potential horrors this allows, I'd recommend renaming the built-in sa account to something else, then creating a new login called sa with the rights the app actually requires.