Solved

grant windows authentication to Developer with workstation outside the domain

Posted on 2014-09-09
5
113 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 34

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 50

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

737 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