DataSource Controls :: Windows Authentication - Connect To Database From A Machine Inside Intranet / Login Failed
Jul 18, 2010
I am getting this error when trying to connect a database from another computer in my home network:
System.Data.SqlClient.SqlException : Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
this database is using windows authentication. sqlserver 2008.
What is the connectionstring that I need to use in order to get the database?
View 1 Replies
Similar Messages:
Dec 18, 2010
we are migrating existing windows form application to asp.net(3.5) intranet portal, there is a requirement whereby database connection should be made by the logged in windows user. Is it possible to achieve this functionality?
View 1 Replies
Mar 24, 2011
I'm trying to enable automatic Window authentication working on our ASP.NET Intranet. I've changed the Authentication on our IIS 7.5 server from Anonymous to Windows Authentication Enabled only, and changed the Web.config file for the website to:
<authentication mode="Windows" />
<authorization>
<deny users="?" />
</authorization>
The Windows login box appears when accessing the website via IE 8, I enter valid credentials, but the login window keeps reappearing as if it does not accept my credentials. By repeatedly cancelling the login box it disappears, and my login name can be viewed on the website. Is there any possible reason for the login box to keep popping up even though valid credentials are being entered? I've restarted the servers / cleared browser cache etc. Also, ideally I would like the user to enter the login details once in the login box and not be required to reenter login details whenever he reopens the browser.
View 3 Replies
Aug 20, 2010
I recently upgraded a WinXP machine that had been running VWD 2005 to a Win7 machine using VS 2010. The application targets .Net 2.0, but since the upgrade, I cannot get VS to connect to my database and this is the first time I've tried working on the site since upgrading, so no changes have been made to any code (with the exception of trying to change my connection string so I can connect). The specific error is:Cannot open database requested in login 'dbName'. Login fails. Login failed for user 'SqlLogin'The sql database is on another machine and I was assigned the login/password; I know the login works because I can connect to it with SQL Server Management Studio. Having read several posts and still having trouble, I tried to do a couple things. First I modified my web.config connection string, which looks like this:
[Code]....
When that did not work, I deleted the connection string from the web config and dragged a sqldatasource control onto a page and tried to use the connection string builder while in design mode. Then the error I got was:The database db1 does not exist or you do not have permission to see it. Would you like to attempt to create it?I'm not sure I understand that there is a problem at all, except that I upgraded the OS/IDE. I'm using IIS 7.5 on my local machine to serve the development site while connecting to the development sql server on the other machine. Since I can't use the IIS aspnet account on the remote sql server and my assigned login is verfied working through sql management studio, what else can I do to get my developement site working again?
View 2 Replies
Jun 15, 2010
while i was using sql server authentication, it was running a quite good but suddenly it starts showing an error 'Login Failed for user sa'
Here is my error-Login failed for user 'sa'.
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 'sa'.
Here is my code-
<add name="MyDB" connectionString="Data Source=ERPTEST;Initial Catalog=LoginDatabase;User ID=sa;Password=sa"
providerName="System.Data.SqlClient" />
View 2 Replies
Feb 5, 2011
I was wondering what the following error means: Login Failed. The Login Is From An Untrusted Domain And Cannot Be Used With Windows Authentication. Initially, when my application was much simpler, I had no permissions and roles and my authentication mode was set to "windows". Afterwards, however, I added authorization, changed the authentication mode to "Forms" and ever since, when I try to login, I get the error above.
View 5 Replies
Jan 9, 2010
I had a problem login management studio (Sql server 2005) using windows authentication because it doesn't show me any server name to connect and if I put my computer name and user name (my-PCpatel) login was failed.
So, I decided to uninstall it and install it again using mixed mode authentication. After installation I select sql server authentication instead of windows authentication and put login name as "sa" and password that I had put it during installation. But the connect button is dark gray(the way I can not select it or press it on) while the other button (cancel, help, option) can be selected or pressed.So, why am i not able select or click on connect button?
View 1 Replies
Jun 30, 2010
I was working on a asp.net project earlier but due to some OS problem I had to re-install the OS..so before re-installing the OS I detached my sql database and then attached it back after installation..but I am having a login problem now..the previous servername was XYZ-DB840C74SQLEXPRESS..so this user i.e. XYZ-DB840C74ASPNET is added to the database's permissions..now my new server name is XYZ-8D50FD73SQLEXPRESS..but I am unable to add this user through the permissions wizard..I am getting the following error: Cannot open database "finance" requested by the login. The login failed. Login failed for user 'XYZ-8D50FD73ASPNET'.
View 7 Replies
Jun 8, 2010
I am writing a page for creating a new user for a website. After the user fills out the form and click the "Create User" button, the information provided is supposed to be sent for storage to the database. I have been getting the same error message for a couple of days now and I've ran out of things to try. The message doesn't seem like a complicated issue, in fact it's quite common and found a great deal of information on how to resolve it. However, nothing I've tried works. I'm using VS 2010, and SQL Server Express 2005. The message I get is the following:Cannot open database "[database]" requested by the login. The login failed.Login failed for user "[MACHINE_NAMEUSER]".I have added my current Windows account to the Users folder under the Security folder through Management Studio and granted it all the role memberships. I'm also using Windows authentication. If there's any information I'm not providing to figure out what's the issue, let me know and I'll post it.Stack Trace:
[Code]....
View 3 Replies
May 16, 2010
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'.
View 6 Replies
Jan 8, 2010
I started a new Sql Server 2008 with mixed authentication Windows and SQL SERVER AUTh... I created a new login account and use it to directly connect in SQL server managment studio BUT... when i create in VS2008 the connectionstring... everytime i try to open the DB connection i take an exception to the login... some screenshots show all the process ;)
LOGIN: admintvmaismais
PASSWORD: ex
Working to connect in SQL SERVER MANAGEMENT...
LOGIN STATUS ON SQL SERVER MANAGEMENTE
Now in VS2008 Web-Config I declare the connectionstring:
<connectionStrings>
<add name="SqlConnectionString" connectionString="Server=JP;Database=tvmaismais;User ID=admintvmaismais;Password=ex;" providerName="System.Data.SqlClient" />
</connectionStrings>
and When i try to open a connection like this:
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SqlConnectionString"].ConnectionString);
try
{
conn.Open();
...
}
catch (Exception e)
{
retorno = e.Message.ToString();
}
finally
{
if (conn.State == ConnectionState.Open)
conn.Close();
conn.Dispose();
}
I get this exception: Cannot open database "tvmaismais" requested by the login. The login failed. Login failed for user 'admintvmaismais'. What am I missing? What do i need to do, to get this login to work?
View 4 Replies
Jan 9, 2010
We also have sales rep that take call and use the same website to take the orders.
My boss wants me to allow the SR to only be able to take orders if they are in the network itself. When I ask why he tells me "just because".
I'm sure there's a way but I can't see it at the moment. How do I go by doing that? Also keep in mind that if the SR is outside the intranet, he can't be allowed to enter his active directory login/password (so the login window must not even show).
View 3 Replies
Jun 28, 2010
Do any of you guys have experience using Active Directory and the Intranet Zone to silent authentication with a local web site? I've done it in the past with 1.1 and 2.0 .NET, but this 3.5 site I have written doesn't seem to be working for some reason.In the past, how I have done it is:
In web.config, set:
<authentication mode="Windows"/>
In IIS 6, under directory security, check Integrated Windows authentication and Digets authentication for Windows domain servers, and set the realm to my domain, and uncheck Enable Anonymous access.The I add the Host Header for the site to the corporate Intranet Zone in Internet Explorer under trusted sites using Active Directory.And that's basically it. I've done it on plenty of intranet sites before, but with this 3.5 application I am still being propped to login. Anybody see any steps I missed?
View 12 Replies
Jan 7, 2010
I've a project using windows authentication and it will be used in intranet. The client itself already have a web application in their intranet and they built it with Java (they used windows authentication too). The problem occur when they want my web application only appear within their application content section.
What should I do? I did think about using iframe but some people said it's evil. And if I'm going to use iframe, is it save? My web application will use a few pop up window/modal window and ajax.
View 5 Replies
Jul 26, 2010
i m trying to set up an Intranet site with Windows Authentication. I have configured the web.config as shown below.
<authentication mode="Windows">
<roleManager enabled="true" />
I wanted to do authorization by roles so
<authorization>
<deny users ="?"/>
<allow roles="D820MySite_Developers, D820MySite_Admins"/>
</authorization>
I'm in the D820MySite_Developers group. When I attempt to login, it wants my password. I thought that with Windows Authentication it should not prompt for the password. If is use <allow user="*"/> it does not.
1. Is this the correct behavior?
2. My aspnetdb does not appear in the App_Data folder. Should it and is this causing the problem. If it should be there, how do I get it there?
3. I was under the impression that by using Windows Authentication, I can prevent users from accessing pages by folder. Is this provided by IIS or is this provided by Windows (using Windows Explorer)?
View 3 Replies
Mar 23, 2010
I'm trying to set up Windows authentication on an intranet site. I have this code in the web.config:
<system.web>
<authentication mode="Windows"/>
<authorization>
<allow users="domainuser, domainuser2" />
<deny users="*" />
</authorization>
</system.web>
I can log in with my own credentials, but I have virtually all the rights in AD. User2 can not log in. The website is set to use Windows authentication in IIS manager. And I've tried setting permissions in IIS manager and NTFS permissions for the folde
View 3 Replies
Dec 6, 2010
We are having an issue with the windows authentication and IIS restart for asp.net application Our environment is an intranet site (an asp.net application ) that uses windows authentication, uses integrated security application pool, physical path credentials are set for a service account, who is admin for sql server, IIS etc. web.config - Connection string has Integrated Security = true, authentication = Windows, and authorization - deny *, allow = security group. Anytime we start - stop service (or restart) (IIS); and hit the website thru some other machine IE, it fails to show the website (401.2), and any subsequent hit to the website doesn't go thru.
However when we start the service, and hit the website on server's (where website is deployed) browser first time then everything works fine for subsequent hits from anywhere as long as authenticated on corp net and member of security group configured in web.config. This behavior however goes away if we uncheck the configuration "Enable Kernel-mode Authentication" on the asp.net application. ( but then Firefox browser stops working with this configuration!!) Why such behavior? In the documentation it states its recommended to keep it enabled. What is recommended way of publishing a website with windows authentication enabled? Any side effects of "Enable Kernel-mode Authentication" being unchecked ( other than what we found for firefox not working) Environment : IIS 7.5 windows 2008 Server R2, VS2008, SQL Server 2008, ASP.NET 2.0
View 5 Replies
Sep 26, 2010
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'.
View 1 Replies
Jul 8, 2010
We have developed a website in asp.net using windows authentication and deployed it on the intranet (IIS v6.0). Most of the times, when users try to access this website they are taken straight to the website, but occasionally some users get a prompt to enter their windows username and password. I understand that this could be caused because of several reasons like:
Cached active directory password. Recently active directory password changed. Active directory account locked out. I want to fix this issue for good because it is annoying the users.
View 1 Replies
Oct 16, 2010
I wanted my local iis running application to connect my database in sql authentication mode rather than windows mode,
but it is showing errors of " Cannot open database "aspnetdb" requested by the login. The login failed.
Login failed for user 'DBUser'. ". i also ublocked port from firewall,and allowed remote connection of mssql from sql manager, enabled TCP/IP and named piped protocols from SQL surface config, and with sql manager i also changed server authentication mode to sql from windows.
my datastring is <add connectionString="Data Source=PARTHIV-PCSQLEXPRESS;Initial Catalog=aspnetdb;User ID=******;Password=******/" name="LocalSqlServer" providerName="System.Data.SqlClient" />
i made a user named DBUser in database as well i don't understand where it gone wrong ???
here is error log
[Code]....
View 4 Replies
Dec 30, 2010
Is there any way to use a custom Login Page (Not Windows Login Box) for Windows Authentication of SharePoint publishing sites?
View 2 Replies
Jan 8, 2010
I have just installed SQL Server 2005. I selected windows mode authentication. I am not able to login in management studion. Now, I want to use mixed and server authentication option inplace of windows authentication. so, would that be possible after installation.
View 2 Replies
May 26, 2010
I 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?
View 1 Replies
Jun 14, 2010
While i was using asp.net membership provider database(aspnetdb) on asp.net development server for storing username and password it was working right but as soon as i added my pages to intranet(IIS 6.0) USER was not able to login due to ASPNETDB Database.Now how can i use asp.net membership with that database using SQL Server2005
View 1 Replies
Dec 17, 2010
to connect the MS Sql server 2008 using windows authentication in ASP.Net 4.0 without change IIS user (ASPNet) permission.
View 1 Replies
