I want to use MSSQL authentication for a database I’m creating for a corporation.
The problem is, due to corporate politics, the IT department will not allocate any virtual server space to us.
It also seems unwise to use a laptop sitting somewhere in the office as a server, as this is an unsecured machine.
So now, I’m going to be using a remote host.
That leaves SQL authentication as a possible solution, but the customer does not want to have another login they must use to login. They want to be able to use the login already available with their corporate domain.
That brings me to my question: Is there a way to have the MSSQL server authenticate against a domain remotely?
My first instinct is Virtual Private Network. We have such a system through our IT department, but that’s going to require additional cooperation from the host and the IT department (which has been uncooperative).
Anyone have any suggestions?
Answer
The SQL Server has to be able to access a domain controller that can authenticate the users in the corporate domain. You can either have an addition domain controller of the corporate domain near the remote SQL server, or the domain in which the SQL server resides in trusts the corporate domain.
-Sysadmin Guy
Attribution
Source : Link , Question Author : HumbleWebDev , Answer Author : Sysadmin Guy
