Connect To SQL Server Using Windows Authentication ?
Dec 17, 2010to connect the MS Sql server 2008 using windows authentication in ASP.Net 4.0 without change IIS user (ASPNet) permission.
View 1 Repliesto connect the MS Sql server 2008 using windows authentication in ASP.Net 4.0 without change IIS user (ASPNet) permission.
View 1 RepliesI have an ASP.Net app, that runs using windows authentication. The connection to the SQL Server is usually done by creating a sql server account and using that in the connection string.
However, in this specific very restrictive hosting environment, we have been asked to use a specific WINDOWS/active directory account to connect to the SQL Server.
note it is not the windows credentials of the user of the website, we need to connect to the SQL server with - it is one specific windows/AD account.
How do I configure that in my connection-string?
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]....
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 RepliesI 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?
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 RepliesI installed sqlserver 2008 R2 on my laptop for development and am sure I sellected mixed mode for connecting. Anyway, I have been using it for a while with asp.net and when using sql server management studio connecting using windows authentication, everything
has been fine. I now need to connect to sql server using a login and password (installing umbraco) but cant seem to do this. I have tried connecting through sql server management studio using sql authentication with sa account but it always fails with error "login failed for user .... 18456". I have changed sa password in sql server management studio (as I can log in using windows authentication) but this did not work. I also created new users but still could not connect.
I have got this error
Unable to connect to the remote server
when I call the web service from the windows service. But I can visit this web service through IE and I also wrote another console application to call the web service and it works fine, too.
The exception infomation is below:
A socket operation was attempted to an unreachable network 127.0.0.1:8888
Here is my code:
WebImageSVC webSvc = new WebImageSVC();
ConfigManager.LoadConfigManager();
webSvc.Url = ConfigManager.WebSvcAddress;
webSvc.Proxy = null;
webSvc.CanUpload(0, "");
I try many methods, like turn off the firewall and anti-virus software, set the web services proxy property to null. but still cannot solve this issue.
in my ASP.NET applicaton I have ftpdata folder, where is MS Access 2010 somename.accdb file. On my local computer (Win XP), there is no problem to connect with OleDb to this file and read write datas into and from tables. But on server (Windows Server 2008), I cannot connect to the same file like on localhost.
View 3 RepliesI have a web application set up on our intranet that uses windows authentication (successfully) that I am trying to link to a database running on a separate server.
The problem that I am having however, is that when I try to use a trusted connection to log in to the sql server, instead of passing the domain/username of the person using the website the application is passing NT AUTHORITYANONYMOUS LOGON.
I checked that the authentication was working by having the website display a greeting that does identify my username correctly when I log on to the site, so it isn't an anonymous access issue. I think it is an impersonation issue somehow despite the fact that set in the web.config file for the application.
Curiously, the web application works fine when I run it on either my dev machine or even locally through remote desktop on the production server. I'm not sure what's going on here.
Finally, I'm running iis 7.5, windows server 2008 r2 and sql server 2008
This is a real quick question, is it possible to allow Windows Authentication for an ASP.Net intranet site (on a test server) to authenticate against the production server user accounts? If so, how would I go about doing so.
View 2 RepliesI have IIS 7 windows server 2008 R2 64 bit on which I have few web sites which are sending emails thorugh asp.net. Each web site has seperate "From Address (used inside the code)".
In IIS 6.0 mananger >> Delivery Tab >> Out bound security >>I gave Integrated windows authentication for one account (Let us say abc).
When the emails are firing from different applications, the emails are going only if the from address is abc mentioned in the authentication. If any other email address is used then it is going to bad mail folder saying "Diagnostic-Code: smtp;550 5.7.1 Client
does not have permissions to send as this sender".So to make it work I have changed the authentication to anonymous then again the emails are going to bad mail with "Diagnostic-Code: smtp;530 5.7.1 Client was not authenticated" error.
I have one web application which is configured to be use froms authentication.
But, I don't want to use SQL Authentication to connect to SQL server, I want to use windows authentication.
I have a site on domain1. I need to open a ModalDialog with a Page on domain2. My Domain2 is protected not to allow anonymous access so i get a login window like:
My problem is, for this one functionality, i want users to be able to see that ASPX, through the ModalDialog, without authenticating.
I tried using the ftp way:(URL)
and i get a javascript error.
My site is hosted in IIS6, Windows Server 2003 and i have full access to the server.
Just going to start making a web application and was wondering which was better, or at least what are the main differences between them (as it probably matters what I am using them for)?
View 3 RepliesMixed Authentication Using IIS 7 On Windows Server 2008?
View 2 Repliesi am using windows server 2008 and IIS , somebody installed Dynamic Business Portal everytime users trying to use the portal they enter the servername or by ip @ of the windows server /Bp but a login authentication asking them to insert a username and password they can t login the system even they enter their windows authentication
I published another new ASP called Mytest users put name of ther server or ip of the server /Mytest they were able to access the page and no pop up asked them or authentication I added IUser and Everyone and enabled full access.. i check the PB configuration in IIS it was the same Everyone and Iuser are added and full access is enabled how to get rid of the authentication popup
im using windows 7 home premium-64 bit,when i want to install sql server its not asking for mixed mode its directly creating windows authentication mode but i want to use sql server authentication mode,when im installing im unable to see any mode selection?
View 4 RepliesI'm using VS 2010 RTM and SQL Server 2008 on my clean development laptop, running Windows 7 Pro.
Using Visual Studio's Server Explorer, I can easily do an Add Connection by simply right-clicking, and then completing the dialog, and choosing "Use Windows Authentication". I can then click the button "Test Connection".
However, if I wish to do an Add Connection, and then choose "Use SQL Server Authentication", I get a message "Login failed for user 'appSlir'", as shown here:
When I try the same thing on my other development machine, which is VS 2008, SQL Server 2008, and Windows XP Pro, it works fine.
There seems to be a problem/bug that prevents Add Connection with "Use SQL Server Authentication" to SQL Server 2008, when running on Windows 7 Pro.
i have installed sql server express using windows authentication mode,but i have a doubt if we want to acces the data from front end we type like uid="",pwd="",servername="" but when using windows auth what credentials we have to give or there is no need of any details?
View 3 RepliesI have a requirement I should connect to MS SQL server under IIS Application pool account from ASP.NET application where Windows Authentication is enabled. I cannot use user name and password in connection string.
ASP.NET application should use Entity Framework 4.0 to work with data.
I have a clean installation of Windows 7 with VS2010 RTM and am trying to get the ASP.NET Development Server to work. When I run the project, the WebDev server starts and shows that it's listening on port x on localhost. I've tried:telnet to the port. The port is not listening. running netstat -o shows that the WebDev server is in fact not listening on any port. manually changing the WebDev port to a different port and restarted VS without effect. I have Windows Firewall turned off entirely and am not running any other firewall software either.
View 1 RepliesWhat's the difference between Basic Authentication and Integrated Windows Authentication in IIS?
View 3 RepliesI set authentication mode to Windows in the web.config and I enable Windows Authentication and disable the Anonymous Authentication in IIS 7 on win 7, but HttpContext.Current.User is always null.It works fine when I host the web app in IIS 6.0.
View 1 RepliesI have been trying to avoid the windows login userid and password window when I use the Windows Authentication mode for a web site. I need to capture the the windows logon user name without prompting for the user id and password and display that on the web site. I had tried almost everything... changed authentication,security setups on IE and IIS etc... still not being able to avoid the window...
View 1 Replies