Solved

grant windows authentication to Developer with workstation outside the domain

Posted on 2014-09-09
5
107 Views
Last Modified: 2014-09-17
Hi for internal policy I have to disable sql authentication on our new sql 2012 server.
Developers that have workstation not in our ad domain complain that they are not able to logon using management studio neither using run as a different user neither using runas /netonly.
How can I accomplish this?
thank you very much
0
Comment
Question by:pozlu0
  • 3
5 Comments
 
LVL 33

Expert Comment

by:ste5an
ID: 40311808
You can't do much. That's what the policy is intended for.

You may create dev accounts in your AD and either the developers run VM's which are part of your AD structure or you run a Terminal Server in your environment or you run Hyper-V VM's in your infrastructure, where your devs can log in.
0
 

Author Comment

by:pozlu0
ID: 40311905
thanks for answer,
I've forgot to mention that my environment is a always on implementation .
I tried to create a sql user but I see it only on one node not in the other one
0
 
LVL 47

Expert Comment

by:Vitor Montalvão
ID: 40311908
If developers are in a different domain you need to request that domain to be trusted in your domain, so they will be able to connect to SQL Server.
0
 

Accepted Solution

by:
pozlu0 earned 0 total points
ID: 40320085
I Resolved the issue using runas /netonly /user:user@mydomain to launch sql management studio executable file
0
 

Author Closing Comment

by:pozlu0
ID: 40327544
I find this solution works very well in my enviroment and required less effort than crating a virtual machine
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Please help with the below query - SQL Server 11 18
This query failed in sql 2014 5 31
Sql Server group by 10 27
Find results from sql within a time span 11 31
Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question