December 6, 2012 at 8:00 am
Just want to clarify that my understanding is correct.
Say I want to setup a SQL Server instance that's not in the trusted domain. If I then logon to my PC which is connected to the trusted domain then I have to use SQL Authentication to connect to the SQL instance that's not in the trusted domain.
am I right in thinking that windows authentication would only work if I have a local windows account on that server and I'm actually connected to the server?
In other words, if the SQL instance I need to connect to is not in the domain where AD is used, I must configure it to use both Windows AND SQL authentication. But if the SQL instance is within the domain where AD is used, the safest most secure method is just windows authentication.
Hope I'm making sense!
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
December 6, 2012 at 8:50 am
Abu Dina (12/6/2012)
...In other words, if the SQL instance I need to connect to is not in the domain where AD is used, I must configure it to use both Windows AND SQL authentication. But if the SQL instance is within the domain where AD is used, the safest most secure method is just windows authentication.
You are correct, if the SQL Server is not in the same domain then only local users created on that server could use Windows Authentication, clients from other computers would need to use SQL Authentication.
December 6, 2012 at 9:05 am
Thanks for the confirmation.
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply