Solved

grant windows authentication to Developer with workstation outside the domain

Posted on 2014-09-09
5
109 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 48

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

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, …
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

829 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