I have set up a web Application using IIS 7 .Following details:-
Database server is sql server 2008 r2 and located on another machine
I am using forms authentication and while trying to logon using my start page where i am validating the user from database. This error is coming while login
i am working on .net framework 4.0
What can be the reason for the same .
I'm developing an intranet site in asp.net 3.5 using linq to sql. When I run the site on my development system, it works great. I moved the site and SQL Server database to my CLient's Server for testing.
When I execute the following vb.net code
Dim linq1 = From PageGroup In dbs1.ZZ_PageGroups Where (PageGroup.PageName = pasPageName)
For Each PG In linq1
I get the above error message. I suspect the problem may be authenticating the user in SQL Server. When using Linq to SQL, how/where is the connection string set and how does it know the user?
Im getting the following error when I try to login to web page with a valid username and password:
Oops. The error: Login failed for user 'NT AUTHORITYANONYMOUS LOGON'.
This is my web.config :
<configuration>
<system.web>
<customErrors mode="Off"/>
<authentication mode="Forms">
<forms name=".ASPXFORUM" loginUrl="login.aspx" protection="All"
timeout="30" path="/" />
</authentication>
<authorization>
<deny users="?" />
</authorization>
</system.web>
</configuration>
Anyone know what this error mean?
I'm running IIS 6.0 on a Windows 2003 server and running an ASP.NET 4 application which connects to an SQL Server 2005 database on another server. I have my Default.aspx page set to Windows authentication with anonymous access disabled.
When I load up the page it asks for a username and password (as expected), I enter my credentials and it comes up with the following error:Login failed for user ''. The user is not associated with a trusted SQL Server connection.
If I add the following to my web.config file: <identity impersonate="true"/> then I get the following error:
Login failed for user 'NT AUTHORITYANONYMOUS LOGON'.
And if I add the <identity impersonate> tag set to true and with my username and password included it connects successfully.
I can't leave this in there as I want each user to connect as themselves, so why is the server not using the credentials that I enter when prompted to connect to the database ?
i have a Error :
<forms name="appNameAuth" path="/" loginUrl="~/login.html" defaultUrl="index.html" </forms>
Server Error in '/' Application.
Access is denied.
Description: An error occurred while accessing the resources required to serve this request. The server may not be configured for access to the requested URL. Error message 401.2.: Unauthorized: Logon failed due to server configuration. Verify that you have permission to view this directory or page based on the credentials you supplied and the authentication methods enabled on the Web server. Contact the Web server's administrator for additional assistance.
The web.config in folder admin of my
<?xml version="1.0"?><configuration><system.web> <authorization><deny users="?"/><allow users="admin,administrator"/><allow roles="admins,administrators"/><deny users="*"/></authorization></system.web></configuration>
In file Global.
routes.MapPageRoute("login", "login.html", "~/login.aspx");routes.MapPageRoute("default", "index.html", "~/index.aspx");
If I use extensions .aspx, it runs normally
<forms name="appNameAuth" path="/" loginUrl="~/login.aspx" defaultUrl="index.aspx" </forms>
I am using Integrated Windows authentication and Role based authorization.The web.config file has two Active Directory groups.Sample code of web.config file for Role based authorization (Actually I got this sample code from a moderator of this site Gary works well).
Code:
<location path="Bloodgroup.aspx">
<system.web>
<authorization>
<allow roles="MedcenterGroup1"/>
<deny users="*"/>
</authorization>
</system.web>
</location>
So user's who doesn't belog to "Group1" AD group, should get Unauthorized error. It works exactly like that. But, before getting unauthorized error, it shows a pop up screen (as shown in the attached picture) prompting to put userid and password. If a user in AD group "Group1" accesses "Blood group. aspx" page, popup message doesn't come which is correct. Following is the code in web.config file to handle errors:
Code:
The <customErrors> section enables configuration of what to do if/when an unhandled error occurs during the execution of a request. Specifically, it enables developers to configure html error pages to be displayed in place of a error stack trace. -->
<customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
<error statusCode="401" redirect="Errors.aspx" />
<error statusCode="403" redirect="NoAccess.htm" />
<error statusCode="404" redirect="FileNotFound.htm" />
</customErrors>
Question 1: why does the popup box prompting user id and password comes up?
Question 2: I have put in web.config file in customErrors tag to direct to Errors.apsx page when I get 401.2, it should be redirected to Errors.aspx page. But it is not getting re-directed.
in my aspx.vb page i have written
Label1.Text = Me.Page.User.Identity.Name
when i do view in browser (without publishing to any server) i see label's text as
abcxyz which is correct
but when i publish it, i dont see any text . I have made setting IIS to allow anonymous users so that anyone can open the wesite and see their computer login id
like abcxyz
I was configured an application in IIS,while running it shows login page successfully and i entered the credentials then it was redirected to HomePage with an error of(HomePage not displayed but the URL is rediredcted to HomePage)
Error message 401.2.: Unauthorized: Logon failed due to server configuration.Already i was searched in google and tried to resolve the problem but no use.
I'm using this for connection to SQL Server 2005 [Windows authentication]
<add key="ConnectionString" value="Data Source=MALIKsqlexpress;Initial Catalog=gainpeace;Integrated Security=SSPI"></add>
but it generates an error
Cannot open database "gainpeace"
requested by the login. The login
failed. Login failed for user
'MALIKASPNET'.
I am using SQLEXPRESS 2008 R2 and developing ASP.net 4 application. I am getting this error:
Cannot open database "mydbfile" requested by the login. The login failed.
Login failed for user 'IIS APPPOOLASP.NET v4.0'.
I have an ASP.NET MVC 2 web site that runs okay on my local machine. The first page that comes up uses data from a SQL Server 2005 database that is on a separate machine.
When I deploy the website to an IIS 6.0 web server and try to open the website in a browser on the web server desktop I get the following:
Server Error in '/AutoDoc' Application.
Login failed for user ''. The user is not associated with a trusted SQL Server connection.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
Source Error:
Line 27: </div>
Line 28:
Line 29: <% Html.RenderAction("GenreMenu", "DocStore"); %>
Line 30:
Line 31: <div>
Source File: c:InetpubAutoDocAutoDocViewsSharedSite.Master Line:
29
Stack Trace: [SqlException (0x80131904): Login failed for user ''. The user is not associated with a trusted SQL Server connection.]
There are so many ways to approach this that IM a little lost in the forest. What is the best way to address giving the hosting web server access to the database server? Or should I say give the web site access to the specific database?
I have a Asp Application built in VS 2010, it works prefectly on my box , when I moved the code to the dev server, it gives error on a particual web page saying cannot open the database requested by the login, login failed, the other web pages in the application are also suing the same database and they are loading perfectly.
View 4 Repliesfirst here is my connection string:
"Data Source=tcp:sql2k803.discountasp.net;Initial Catalog=SQL2008_736225_aldookandb;User ID=SQL2008_736225_aldookandb_user;Password=******; "
note that i can successfully connect to the db using the user 'SQL2008_736225_aldookandb_user' when i use a remote connection tool, such as sql server managment studio
And you can reproduce this problem, see it live and see the stack trace by doing the following:
A) :
1.go to my website [URL]
2.login as username: Teacher1 password: 123456 (Note that you have been logged in successfully)
3. go to the link in the upper right corner where it says (Teacher Page)
4. booooom!
B):
1. go to the website and create an account as a "Teacher"
2. do steps 2 to 4 from above and same problem occurs
I have created a set up of website using the template WebSetUp project in VS 2008/.net 3.5 and sql server 2005.
I get the following error after i install the set up.
Cannot open database "Project_Tracking" requested by the login. The login failed.Login failed for user 'NT AUTHORITYNETWORK SERVICE'.
How to add sql server connections in local host .my project is run in IIS now i need to insert data in my page but it throw the error. using asp.net 2008 and sql server 2005
Server Error in '/' Application.
Cannot open database "bramandam" requested by the login. The login failed.
Login failed for user 'IIS APPPOOLEmplyee'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Cannot open database "bramandam" requested by the login. The login failed. Login failed for user 'IIS APPPOOLEmplyee'.
Source Error:
Line 82: catch (Exception e)
Line 83: {
Line 84: throw e;
Line 85: }
Line 86: finally
Source File: d:ramandam siteApp_CodeMarvel.cs Line: 84
Stack Trace:
[SqlException (0x80131904): Cannot open database "bramandam" requested by the login. The login failed.
Login failed for user 'IIS APPPOOLEmplyee'.]
Marvel.GETDS(String qry) in d:ramandam siteApp_CodeMarvel.cs:84
EmployeeRegistration.TextBox1_TextChanged(Object sender, EventArgs e) in d:ramandam siteEmployeeRegistration.aspx.cs:90
[Code] ....
I have created an ASP.Net website and tested it using the default server. I used the integrated membership provider for the users login and everything worked fine.
Now I moved to IIS 7 and nothing works anymore. I disabled the read-only feature but every time I try to either register a new user or add an item to the chart I get this error
Cannot open user default database. Login failed.
Login failed for user 'NT AUTHORITYNETWORK SERVICE'.
Cannot open user default database. Login failed. Login failed for user X
View 3 RepliesI wanted to post my problem and solution since I've gotten some good information on this board. When deploying my Visual Studio 2008 C# .NET 2.0 web application Production, I encountered some problems, which is not unusual. What was unusual is that my Crystal Reports .NET reports that use the Report Viewer control would not work; they errored out with:
note: Crystal Report works fine in dev environment....
Logon failed. Details: ADO Error Code: 0x Source: ADODB.Connection Description: Provider cannot be found. It may not be properly installed. Unable to connect: incorrect log on parameters.We are using Oracle 11g 64 bit as database. We establish crystal report database connection by two ways,
1. Microsoft OLE DB Provider for Oracle
2. Microsoft OLE DB Provider for ODBC
but we got the same error in report module when we using two methods.
Our Coding : //CrystalDecisions.CrystalReports.Engine.ReportDocument crpt = new ReportDocument();
private ReportDocument crpt = null;
private void Page_Init(object sender, EventArgs e) [code]....
I've created a data set, which is used by a web service I've created on my Windows 7 Ultimate box. (I'm running VS 2010.) When attempting to run it, I get the following error message:
System.Data.SqlClient.SqlException was unhandled by user code
Message=Login failed for user 'IIS APPPOOLASP.NET v4.0'.
Source=.Net SqlClient Data Provider
Now, I've checked for answers to how to handle this, and found the following 2 threads on this website:
[URL]
If at all possible, I'd rather just use a connection string which I've already specified in my Web.Config file, for the dataset, and associated table adapters.
I am using visual studio 2008 in a asp.net project where my database is SQL Server 2005. i am trying to deploy the project in IIS by creating a virtual directory. But it gives the error while i run from IIS. It gives the followin error. Login failed for user 'Machine NameASPNET'.; I used the command secpol.msc to set the 'log on as batch job' to the user name ASPNET. But still i got the message.
View 2 RepliesI have login page, users enter their username and password ... I want when users enter their password wrong after 3 time they can't enter password until 24 hours after that they can try it again, How i can do it?
View 1 RepliesI have a problem with using login controls form authentication ! as my website serves some pages for guest users(Anonymous user) and some pages are for only secure user(they must have to login for those requested pages)...... my problem is this that when i apply form authentication in web.config file to login control then visual studio directly shows only login page where i want that in general case only : guest user pages must be shown and if user clicks on login then after login the requested page he may open !
View 2 RepliesI need to create an application with Forms Authentication and/or Windows Authentication. If the application is set to use mixed authentication (Forms + Windows Auth) and the user don't have a Windows user account, the login will fail and he must be redirected to a forms login page. How can I do this?
Are there any different way to provide mixed authentication?
I've got an MVC 2 app that works fine when launching from VS 2010. However, when I deploy (using File System on the server in the same box) and attempt to run I get the error shown below. The wierd thing is that the Physical path shows: C:inetpubwwwrootWorksheetsSiteWorksheetsAccountLogOn which leaves out the "View" folder in the path.
[Code]....
I have a DC (Win 2K3,IIS 6.0..) and put my site there. I have a local computer (win XP2) with computer name PC1 is already joined to the DC. in PC1 I login with account (user: abc, passs: 1234567) was created on the DC to log on to domain. After successful login into the domain, andand type in my web address, so I have to write code in my web site to understand how abc account login to the domain will always login to the my site must be signed in .not logged in login module that in my site.
I have a DC (Win 2K3) and put my site there. I have a local machine (win XP) with PC1 name is already connected to the DC. PC1 I log in with machine account (user: abc, passs: 1234567) was created on the DC to log on to domain. After successful login khj me on my website, so I have to write code in my web site to understand how abc account login to the domain will always log into the site must be signed in toi.khong Login Module.