From your example, I assumed you are using SQL Server authentication, the SQL Server login having the same name as the database (V112). I tried it in a similar setting and it works, thank you!I also made it work with Oracle. However, it looks like it doesn't work with Windows authentication.
I was trying to put all credentials in the same LOGIN object, but apparently you have to have only one SQL credential per LOGIN object. Thus, what I think is missing from documentation about alternative login is:
- Have one LOGIN object for each unique credential (pair Username/Password), with only one SQL-type entry per LOGIN
- Do not use Windows (Active Directory) credentials in the LOGIN object
Thank you again for making it clear!
Leonard