The distinctions among Windows user permissions and any set of SQL Server GRANTs seem like unrelated concepts. As often as not, it seems to actually be implemented with pseudo-logins for database roles; but that doesn't map usefully back to Windows permissions. Assuming single-login identity verification, why not just go with the simples...
We have some corporate intranet users using a WinForms app to work on a system with SQL server behind. Integrated Security is setup, allowing all users update and delete permissions, where application security limits how and where table updates take place. However, some users are power users with SQL query tools at their disposal, and a...
Hi, We are developing an intranet web application on .NET 2.0 platform. The application is using Integrated Windows Authentication for Single Sign On. The users are authorized to use diffent modules according to the Active Directory Groups they are in. Up to the point where authentication and authorization is accomplished everything w...
right now I have the following architecture built with classic asp and visual basic 6 I have a COM+ component developed in VB6 which connects to the dabatase. I set the DB conf thru an .udl file configured with integrated security. At the web server (IIS) I register the componente with the com+ manager, and configure it to be run under...
This one is killing me. I have an ASP.net (2.0 Framework) app that uses integrated security. IIS is setup appropriately and works fine as a virtual directory off the default website. My OLEDB connection (Jet 4.0) works fine and connects to a database file via network share (\GIS1\GIS Server - PublicWorks_StreetSigns). BUT, when I create...
I am wanting to perform a number of tasks in SourceGear Vault (V4.1.4) with Nant (V0.86.3317.0). Is there any way we can get Vault to use Windows Authentication from Nant to create the connection? The Nant block I am using to initialise the vault connect is : <target name="InitialiseVaultSettings"> <echo>InitialiseVaultSettings</echo>...
Hello all, we have a system where they client wants integrated Windows authentication. This is an ASP.NET 3.5 application, connecting to Sql Server 2005. The web server is Server 2003 R2 SP2. The db server is Server 2003 SP2 (not R2). In the db server, I ran the following script exec sp_grantlogin 'myDomain\myUserGroup' USE myDbNam...
Please, can someone PLEASE give a simple, straight-forward way to enable ASP.NET > Kerberos > Sql Server? We have clientMachine > webServer > databaseServer. The client is insistent that the site must pull the windows login and not prompt, hence the need for Kerberos and Integrated Authentication. It also MUST impersonate the user onto...
I have an administrative website on our intranet that currently uses Integrated Windows Authentication through IIS. We would like to move this application to a public website and secure it with SSL so our users can access it from anywhere. I had been planning on using an HttpModule to redirect from http to https, but it doesn't look lik...
Is it possible to have a link that attempts windows integrated security authentication on one of my pages in an project where the web.config is set to Forms? ...
Hi guys I have an ASP.Net MVC app using Integrated Security that I need to be able grant open access to a specific route. The route in question is '~/Agreements/Upload' and the config I have setup looks like this: <configuration> ... <location path="~/Agreements/Upload"> <system.web> <authorization> ...
Using Visual Source Safe with IIS integration (the working dir is the IIS site) Visual Studio, pointed to the IIS site would load up the Web project. It would be under VSS control (have to check out files, etc). Recently, we had to switch to Integrated Security for our database connections from the web app. This means changing the i...
I published ASP.NET MVC web site to a server on a virtual machine (Hyper-V). SQL Server Express installed on the same server. The problem is that ASP.Net Membership system doesn't work in integrated mode. When Web.config file contains records as follows: <connectionStrings> <remove name="LocalSqlServer" /> <add name="MyDBCo...
Is it possible, safe and practical to use Windows Integrated Security on an Extranet? E.g. there is an IIS website on the intranet that can be used over the LAN with integrated authentication. When the user disconnects from the LAN he wants to be able to use the browser on his domain-joined-notebook to connect to the same website over t...
I have a setup where I impersonate an AD user as described here. The app connects to the (Oracle) database using integrated security, but the impersonated credentials are not propagated to the database. Are there any known issues with impersonating AD users and accessing the database with integrated security? ...
I'm dealing with a problem trying to use Windows authentication with IIS 7 in Windows Server 2008. Also i'm using WCF. I have a client application and the server application. The server application manage the user accounts using Active Directory. Everything starts when the client sends its user and password to the server application, wh...
I have a WCF service hosted in IIS 5.1 on my development XP machine. The service cannot connect to sql server DB with integrated security=true. The same service works fine when hosted in a console app. I have unchecked Anonymous access and checked the Integrated Windows Authentication in IIS These are my setting in Web.Config <connect...
What is the best/simplest way to transmit the user credentials (Active Directory) over the transport layer. I have two systems A and B connected with a 3rd party message layer C. Is there any way (preferable in .NET) to somehow store/serialize the credentials of the authenticated user on the side A, transmit it over the C, then to de-s...