Establish Trust Between IIS And SQL Server On Different Machines?
Nov 12, 2010
I have a .net web app hosting in IIS6 with Windows Authentication and anonymous access disabled. The web app is making connection to a SQL Server that is in the same domain, but on a different machine.
I want to have the IIS Worker process acount I_USR_... to be granted access to the SQL Server.
Will this work ?
(Is there a one to one trust ? Or should I make some extra effort to make the trust work ?)
(edit) On this page I read:
IUSR_ must be in the domain, and given proper access to the SQL Server; or, you must disable anonymous access on the site / application - which will allow IIS to pass the users' credentials to SQL Server. Not doing either of these things will result in an error.
View 5 Replies
Similar Messages:
Dec 20, 2010
My company has developed a .NET web service and a client dll that uses that web service. The webservice is hosted on our server over ssl and the cert is provided and signed by GoDaddy. We have some clients in a hosted environment that are getting the following error message from the client dll when it tries to access our web service.
System.Net.WebException The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.
Our fix has been to have them open IE on the server, which is a challenge in and of itself for a lot of the hosted services, and go to the WSDL url. IE then prompts them with a security alert dialog. It says the cert date is valid and a valid name matching the name of the page, but was issued by a company you have not chosen to trust. When they click Yes to proceed, the client dll can then succesfully connect to the web service and operate as normal. why GoDaddy would not have been in there valid publishers list? All of the servers we have running has GoDaddy as a valid authority. I'm guessing, for security reasons, they've uninstalled the authority for GoDaddy, but not totally convinced that there's not some other underlying issue.
Unfortunately, I haven't had much luck trying to recreate this locally. If I go into Internet Options and remove the GoDaddy authorities and hit our service, ssl works just fine. I go back into the list of publishers and GoDaddy gets put right back in. So my second question is, How the heck do you get rid of GoDaddy so I can get an invalid cert warning?
Okay, last question. Is there a way in code I can tell the web service to ignore invalid certs. I've seen some posts on doing this programatically with WCF but not old web services.
View 2 Replies
Jul 25, 2010
i have a web application that is using a https webservice and for accessing this webservice i have installed the PFK file into the mmc console in the personal storage folder and also installed in IIS. After installing the PFK file the properties of the installed PFK file shows a warning that "Windows does not have enough information to verify this certificate" but the installation is done with success. After this i go to add the wsdl to my project as service reference, but it shows the error "Could not establish trust relationship for the SSL/TLS secure channel with authority". What is the solution for this?
View 17 Replies
Oct 11, 2010
My question is about accessing local machines' files from a webserver.. I have an intranet project that works on my network.. My project is about accessing the other local machines,then displaying images from that machines.. For example my project is working on 192.168.9.170...when enter the site..it can be displayed lots of images from local machines..for example an image of them src path is:192.168.9.180, one of them is 192.168.9.181.. So,i want to publish this project on web.Can i access local machines from webserver..how can i map that machines
View 1 Replies
Dec 16, 2010
I am planning a SaaS system, to be written in C#, ASP.NET using WCF that has two separate components:
On a static IP web server in the cloud will be a web app, common to all clients. Inside each client's office will be another app, installed on a server with IIS.
The site app will obviously be able to connect to the web services published on the web site. But here's the rub - I also want the web app to be able to initiate a connection to the site app... and the on-site server may not necessarily have a static IP. I can't control this, because we may have hundreds of clients at some point in the future, and we cannot limit our saleability by insisting that the customer has a server with fixed IP.
So, how to do this?
I could have the site apps "checking in" with the web every minute or so, to give the web app the possibility of responding with a "while you're here, do x,y,z..." but that seems very inelegant. Also, if we're talking about hundreds of clients, I don't want to be bombarding my web server with all these "hi there!" messages if they're not actually required.
View 6 Replies
Oct 21, 2010
Two machines. One a little faster than the other. The slow one runs windows xp, visual webdeveloper express 2010, sql server 2008. The fast one runs windows server 2008, visual wev developer express 2010, sql server 2008.The code in queston involves an automatically generated update function in one of the table adapters, called 'adapter'. Our C# code generates a data table called 'table', with which we update our 'datatable' in the table adapter.
The table has about 100 entries.We then update our datatable in the .xsd file by calling.
int rowsaffected = adapater.Update(table);//this is the line that takes long on fast computer return rowsaffected > 0;//since function returns a bool On the slow machine this line of code takes a few milliseconds.One the fast machine it takes 5 seconds.These results are consistent. It has nothing to do with one machine being busy, the other idle.
What could be the reason and how could it be solved? How can the same code, on the same platform, on a faster machine take 500 times longer than on a slower machine?
View 6 Replies
Feb 28, 2010
I m getting error while running page(.aspx)
"Login failed for user 'HOME-D6A8A84CE4ASPNET'." and at the same time i m also getting error
Firefox can't establish a connection to the server at localhost:1452.
although the the pages(website was running properly as before)
View 3 Replies
Feb 11, 2011
I have to host a wcf service in a medium trust environment.I want to know which bindings are supported while hosting WCF services in medium trust. There is a MSDN article
http://msdn.microsoft.com/en-us/library/bb412171.aspx which talks about partial trust. I am not sure is it the same as medium trust.
View 1 Replies
Sep 6, 2010
IIS 6 installed on Vista (Virtual PC) not member of domain, Visual studio 2008 based website. Active Directory Membership configured in web.config.
Trust level set to Full. Using Login control to authenticate.
[Code]....
View 2 Replies
Nov 3, 2010
I cannot get a successful connectiong to the active directory when logging onto a web form. Here is the code I have in the web.config:
<configuration>
<appSettings/>
<connectionStrings>
[code]...
View 1 Replies
Jul 23, 2010
We're having an error similar to the one detailed here. We get the error noted above when trying to do AD authentication from our .net (3.5) mvc 2 app. This is our first .net mvc app ...
http://forums.asp.net/t/1161047.aspx
- We are re-using a forms auth library written for a .Net 2 app
- that library/app/config used a service account with min. privileges for binding to AD
- This error occurs in VS 2008, have not tried deploying the app to a server yet (a little early for that)
- like the other user at the previously referenced thread, I can get the 'unable to establish ...' error to go away and display the log on page by putting *MY* credentials in instead of the service account (but not successfully authenticate)
- moving the service account into the same AD OU as my account does not seem to change it ... only using my account credentials does.
- trust level is set to full
Is this some odd permissions trick that is new with .Net 3.5 (even though the ADmembershipProvider is still a 2.0 libary)? This should have nothing to do with MVC itself.
Config looks like this (very standard, like every one else's)
[Code]....
The line/portion highlighted in the debug/stacktrace is:
type="System.Web.Security.ActiveDirectoryMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
View 2 Replies
Mar 5, 2010
I've developed a dot net website that runs fine on my localhost. When I upload it to my ISP on a shared hosted site, I receive the following: "Required permissions cannot be acquired." I've been informed that I need to change my website to medium trust. Can someone get me started in the right direction on how this is done? When I add <trust level="Medium" originUrl="" /> to the web.config it won't BUILD on my local host and when I add it to the web.config on the shared site, it gives me"This configuration section cannot be used at this path. This happens when the site administrator has locked access to this section using <location allowOverride="false"> from an inherited configuration file."
View 3 Replies
Dec 3, 2010
On my PC everything is all rigth but on the webserver I get an error: 'OrderBy' is not a member of 'System.Array', maybe due to the trust level. Is there I way to bypass this or I have to resign myself to it?
View 2 Replies
Aug 9, 2010
In my web.config I have:
[Code]....
If I just have ADProvider1 it works, when I add ADProvider2, even though for testing I only use ADProvider1 I get an error: "Unable to establish secure connection with the server" Am I adding the second provider to the membership section incorrectly?
View 11 Replies
Jul 17, 2015
Web hosting provider has set the .net trust level as Medium. so report viewer & crystal reports are not working. it required full trust.so is it possible to execute the reports in medium trust? and how?
ReportDoc.Load(Server.MapPath("~/Reports/Proposal.rpt"));
DataTable dt = cm.DisplayUserInfo("select * from tblProposal_Master where proposal_id='000006'").Tables[0];
ReportDoc.SetDataSource(dt);
CRV.ReportSource = ReportDoc;
CRV.DataBind();
View 1 Replies
Oct 14, 2010
There seems to be an issue with the "Trust" level when executing within a "Cloud" environment. In order for the following app to work it needs a trust level of at least "Medium." This web app is developed using VB.NET 3.5, and Visual Studio 2008. The app works perfectly on my local sever but when deployed/published to the "Cloud" it returns the error: System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. I have added all 4 required values, ConsumerKey, ConsumerSecret, OAuthToken, and OAuthTokenSecret to the web.config file in the "appSettings" section of the "configuration"
[Code]....
If found that by going to [URL] and signing into the account that is using the application, then go to the "Settings" page, go to the bottom of the page and click on the "API" menu option. Once the API page appears you will clik on the button "2", Register An App. On the right side on the new page, you will see a button "View Your Applications." If you have previously registered your app, click this button, If not fill out the appliction for a new app. Now at the View your Applications page, select the app you want to get the authorization keys for where is says "Edit Details". Now click on the button to the right that says, "Application Detail." Here you will find your Consumer Key and your Consumer Secret Key. On the right side of this page you will see the menu option "My Access Token", click it and you will find your oauth_token and your oauth_token_secret keys! Not that you have all the keys, put them in the "appSettings" section of the web.config file. Add "Dim twConn As New TwitterVB2.TwitterAPI" at the top of the page.
I then created a subroutine where I pass in the Tweet:
[Code]....
This code works great in an enviornment that allows at least a "Medium" trust level. However it appears that many of the "new" hosting envrionments such as "Cloud Hosting" and others do not allow this trust level automatically!However if the trust level is less than "Medium" on your host you will likely receive the error message: "Twitter Returned: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed." If anyone has found a fix for this "Trust Level"
View 9 Replies
Mar 30, 2011
I have application..its runnning on my localhost.. i need one more machine to access that application.. but when in tht link i type my IP address instead of localhost.. it showing cannot find server.. in orderr to access appplication to other machine.. as such there is no UAT server as of now...
View 2 Replies
Mar 31, 2011
I'm having a problem when I deploy my web application in different servers. There seems to be an inconsistency in some DateTimeFormat patterns, like ShortDatePattern, using the same culture (pt-BR).
In my development machine (Windows 7, .NET 4 installed, application targeting .NET 3.5) and a Windows Server 2008 R2 (with the application targeting .NET 4) server the ShortDatePattern is "dd/MM/yyyy" - which is the correct, I guess.
In the production server (Windows Server 2003, using .NET 3.5) it is "d/M/yyyy". It is causing me tons of trouble.
I could solve the issue by setting the patterns by hand, but I'd really like to avoid doing this every time I need to output a date. Specially since this will be non-trivial in many places (like where I use MVC's Html.TextBoxFor) and will require a good amount of rewriting.
If there's a way of changing the patterns for the entire web application in one place it would be great. I've tried the following approach in the Global.asax.cs file, with no success:
CultureInfo info = new CultureInfo(System.Threading.Thread.CurrentThread.CurrentCulture.ToString());
info.DateTimeFormat.ShortDatePattern = "dd/MM/yyyy";
System.Threading.Thread.CurrentThread.CurrentCulture = info;
View 2 Replies
Nov 25, 2010
How to get IP list of a client machines in a network
View 1 Replies
Dec 9, 2010
I have a website that uses the ajax control toolkit targeting 3.5. We use tabs control on a few pages. On some client computers the tab control is not displayed. It doesn't collapse the are like it has a placeholder for the control but nothing shows up. No error message is given. Has anyone experienced similar problems.
View 2 Replies
Nov 10, 2010
I have been trying to solve this problem for several weeks now and it is getting really frustrating. Basically i have a simple project which includes one master page and one content page. the following code is what is found in the content page
<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
[code]...
View 1 Replies
Nov 9, 2010
web.config file. when i go to test connection, i get this errorCould not establish a connection to the database.f you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the providerCan someone help me pls i am trying to deploy it to the remote server. Here is the codes:
<configuration>
<connectionStrings>
<add
name="ApplicationServices"
[code]...
View 1 Replies
Mar 23, 2010
Does anyone know how do i establish a connection through this platform(aspx.vb) with another computer if LAN connection are the only option. Hope some kind soul can guide me through and if possible provide some example so that i can study on it.
View 9 Replies
May 28, 2010
I have Visual Studio 2008 SP1 and ASP.NET MVC 2 (not the RC) installed on 2 computers, one at home and one at work which allows me to work on the same projects (via a synced dropbox account) in both locations.I've recently started with ASP.NET MVC and I've noticed that the projects I create at work won't compile at home (haven't tried it in reverse yet), citing the UrlParameter on line 22 and AreaRegistration on line 29 of the default Global.asax file as having a missing reference.I've checked the using System.Web.Mvc statement is in place and that the reference exists in the project references folder in solution explorer. I've looked in the object browser as well and I can see that my work machine shows the System.Web.Mvc.UrlParameter but my home machine doesn't.I've created a brand new Web MVC project on my home computer and the object in object browser is there, everything compiles and runs fine.
View 3 Replies
May 7, 2010
i have a forms application which pings all the network machines. this works fine and also returns the status of each machine i.e. sucess, timeout etc. however i also want to get the name of the remote machines so i use this code:
[Code]....
the above code works fine however any exception is given when the remote machine is a mac. the exception is:
[Code]....
how can i counter the exception so that it simply ignores the exception and carries on the for loop for the other machines.
View 3 Replies
