Creating Database Authentication for SQL Server 2008 Express

Question

To have cross-domain access to my test instance of SQL Server, I need a login with a database user, not a Windows user.

As soon as this works, I could start doing it from my * NIX environment, but basically Windows will not allow me to access the database in this way and it will generate a validation error 28000 / SQL Server Error 18456.

I already did

ALTER LOGIN [administrator] WITH DEFAULT_DATABASE=[...]
ALTER LOGIN [administrator] WITH PASSWORD=...

Answer 1

Make sure that SQL Server is configured to allow SQL Server auth (unlike Windows-auth).

https://support.microsoft.com/en-us/kb/2121736

, , . ODBC , SQL Server, .

https://blogs.msdn.microsoft.com/sql_protocols/2006/02/21/understanding-login-failed-error-18456-error-messages-in-sql-server-2005/

SQL Server?