Is it possible to connect to a Windows Server 2012 Essentials without having to create a new user login for Windows?
I want to just take someones Windows 8 machine and connect it to the server to allow it to access the database without having to have them have to create a new Windows login account to access it.
We have a Windows Server 2012 Essentials domain and a home-grown client/server application that uses SQL Server 2012 as its backend. That backend requires Windows authentication. For that reason, I have created both domain and corresponding SQL Server security accounts for a specific set of users.
I'd like these users to be able to authenticate/join the domain for the sole purpose of gaining access to the backend database. I'd prefer that the other side effects of domain joining, such as a new desktop login, not happen.