Solved

grant windows authentication to Developer with workstation outside the domain

Posted on 2014-09-09
5
110 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 49

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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Help 27 67
length of the password hash sha1:64000 to set sql field property. 13 83
union query column need default text 2 20
SQL server client app 3 26
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

685 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