- Where Developers Learn, Share, & Build Careers


I am supporting a .NET 4.0 (Visual Studio 2010) web application that authenticates a SQL Server 2008 database My work intranet application has been authenticated for the database using Windows authentication. All fine and dandy if I'm developing on my host, but I'm working on a virtual machine which is not at work domains. Thus, when the project is created and runs, it throws a SqlClient.SqlException

"Logging failed. The login is from an unreliable domain and can not be used with Windows authentication. . "

My host is less in developing and leaving VM, what can I do to prevent this error and successfully verify the database so that I can build / run the web app Can i do I am willing to store my credentials locally anywhere, although preferably nowhere, which will be under TFS source control (like web config) because I can not keep the file out because other developers on the project I

I have tried to run Visual Studio as a separate user (as a user on my work domain) but I am " Trat user name or incorrect password "error.

Note, adding virtual machines are not the option of connecting through the domain (or via VPN). Keep VM away from the domain. Also keep in mind, the virtual machine is running on the computer that is on the computer, and the VM uses a shared connection. So it can use intranet, but it can not do Windows authentication on SQL Server.

You can run Visual Studio (or SQL Server Management Studio) as a user on the domain. The trick is, do you have to use ???? / Netonly A type of alternative Windows device, so that you can run on a non-domain machine as a domain user.

That is, in the command prompt, you run this command (filling your own criteria): 

  runas / netonly / user: & lt; Domain & gt; \ & Lt; User_Name & gt; "& Lt; Your_Program.exe"   
 Alternatively, you can create a shortcut on your desktop, and set this command as a shortcut target. When running the shortcut / command, when you get the signal and the visual studio (or the programs you prefer) will be run as a domain user.

Comments

Post a Comment

Popular posts from this blog

Python SQLAlchemy：AttributeError: Neither 'Column' object nor 'Comparator' object has an attribute 'schema' -

I tried to create a new database in my project, but when I run the script, I get this error, I have another project, this type of definition worked before, but now it gets a single error. I am using Python 2.7.8 and the version of SQLAlchemy module is 0.9.8. By the way, using a project flask- SQLAlchemy, it works well, I'm confused. Traceback information is as follows: Traceback (most recent call final): File "D: / Projects / IOM / db_create.py", line 4, & lt; Module & gt; From the models the base file "D: \ Projects \ OO-IM \ models.py", in line 15, in the & lt; Module & gt; Column ( 'followed_id', int (), ForeignKey ( 'user.id')) file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ schema.py", line 369, __new__ schema = metadata. Schema file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ elements.py", line 662, AttributeError in __getattr__ key): Neither 'column' object nor ...
Read more

java - How not to audit a join table and related entities using Hibernate Envers? -

I use Eners to be hibernate to audit my institutions. I have an audit entity, Foo , which includes a list & lt; Bars & gt; However, I do not want to audit the bar institutions, in the form of properties, I have written that: @inti @edicated public class Foo {@JoinTable (name = "T_FOO_BAR", joinColumns = @JoinColumn (name = "FOO_ID"), inverseJoinColumns = @JoinColumn (Name = "BAR_ID")) @ManyToMany (Cascade = Persist) @ Indited (targetAuditMode = RelationTargetAuditMode.NOT_AUDITED ) Public listing & lt; Bars & gt; GetBars () {Return bars; }} Now, I want to retrieve an amendment of foo : AuditReader reader = AuditReaderFactory.get (GetEntityManager ()); FU modification = (FU) reader.CreativeTeA () .entensEtrevision (Foo Class, 42) .getSingleResult (); Unfortunately, when I want to retrieve all the data (i.e. when it loads lazy times ), error me ORA-00942: table or view is not present , because Tried to query this: Sel...
Read more

mongodb - CakePHP paginator ignoring order, but only for certain values -

While pagging my user model in kppp, I can sort with some values, but not others. For example, I can order results from created or email , for example, but username or reputation seems to come back order by arbitrary command for example with a list of users: $ this-> paginate = array ('condition' => array ( 'User.is_active' = & gt; true), 'border' => 24, 'order' => array ('User.created' => DESC)); Works as expected, but $ this - & gt; Paged = array ('conditions' = & gt; array (' user.isIactive '= & gt; true),' border '= & gt; 24,' command '= & gt; array (' user repeats' = ' & Gt; DESC ')); No, no. I first thought that this could be a database issue, but when I search the database directly, sorted as expected. Note: I am using Mangodebi with the Mongo DB plugin of Ichikawa for the KPPHP; Pagnetizing users are used to work properl...
Read more