.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SQL changes from Mixed to Windows auth mode after SQL updates

Posted By:      Posted Date: September 08, 2010    Points: 0   Category :Sql Server
We run a SQL 2005 cluster on Windows 2008 in Mixed authentication mode.  The last two times we have applied a SQL security patch, it automatically changed the auth mode from Mixed to Windows-only, taking our applications offline.  Most recently was today, when we applied KB970892. Can someone explain why this is happening and how we can prevent it?

View Complete Post

More Related Resource Links

Website Windows Authentication fails when enabling SQL Mixed Mode.


Hello all,

Just to describe the scenario. I have a website. This lives on a webserver. On that webserver is an SQL server. The website connects to this database using windows authentication. I have written a windows form application that connects to the SQL Server on the webserver. This application is being run from a location on out intranet. The Winform application use SQL authentication to connect to the database. The SQL Server didn't have mix mode authentication enabled. So I enabled it. The winform application could now connect to the SQL Server.

This is where it starts getting a little strange.

The Website that was already connecting find using integrated authentication starts failing with:

Login failed for user 'NT AUTHORITY\NETWORK SERVICE'

When you are enabling mixed mode authentication, you are adding another authentication method, why would the original Windows authentication fail?

Thanks for any suggestions and sorry if this is completely the wrong place to be asking this question,


SSRS 2005 "Mixed" Authentication Mode


I have a web application where users can authenticate using either SiteMinder or Windows domain accounts.  This is actually configured as two separate virtual directories within IIS 6.  Both applications need to use the same instance of SSRS.  Is it possible to configure the SSRS web application so that if a user is authenticated by SiteMinder it impersonates a Windows account, but if they are already Windows-authenticated that account is used instead?

Mixed Mode application suddenly stops loading assemblies

I have a mixed modes application that will occasionally stop executing managed code assemblies after a Windows update. This has been occurring for over a month now so I have not been able to identify any particular update as the problem. We see the problem predominately on XPSP3 but have also seen several times on Vista and once or twice on 7. On a machine that stops working the Fusion log will show a file not found error on the last assembly loaded. LOG: This bind starts in default load context. LOG: No application configuration file found. LOG: Using machine configuration file from c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\config\machine.config. LOG: Post-policy reference: AProvider.Data.SqlClient.resources, Version=, Culture=en, PublicKeyToken=c84cd5c63851e072 LOG: The same bind was seen before, and was failed with hr = 0x80070002. ERR: Unrecoverable error occurred during pre-download check (hr = 0x80070002). If I delete this assembly, the application will run although not correctly since the data layer has been removed but it does execute as expected instead of hanging. If we run Procmon and watch the probes the correct folders are searched and the images show as loading. But execution fails, either the application hangs or exits. If we move the assemblies to a 'special' folder such as Program Files or Documents, regasm the p

"Mixed mode assembly is built against version 'v2.0.50727'.... " issue and use custom config file

Hi, My Winform applilcation has used Microsoft.SqlServer.Management.Common namespace(assembly :Microsoft.Sqlserver.smo.dll/Microsoft.Sqlserver.ConnectionInfo.dll) and developed in .NET 4.0. Problem:Application is throw an exception when it tries to use above assembly reference methods. Full error text is shown below, "Mixed mode assembly is built against version 'v2.0.50727' of the runtime and cannot be loaded in the 4.0 runtime without additional configuration information. " Error is resolved when we include "app.config" file with below code, <?xml version="1.0"?> <configuration> <startup useLegacyV2RuntimeActivationPolicy="true"> <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/> </startup> </configuration> But, I need to keep configuration file as "renamed.config" and not to include app.config file as of the project requirement.I have set configuration file as "renamed.config" file using below code, //AppDomain.CurrentDomain.SetData("APP_CONFIG_FILE", "d:\\reanmed.config" ); I have also included <Startup> element in this "renamed.config" configuration file and removed the app.config file.But it raise me below error, it always expect app.config file with <Startup> element to resolve this iss

Mixed Mode assemblies

Does anyone have a good tutorial on how to make the compiler package a mixed-mode assembly?  Specifically:I have a piece of non-trivial C code maintained externally.  I would like to compile that and distribute it with a managed wrapper in a single assembly.  Im looking at the build files for a project which does something similar but right now im at a loss as to how to set this up. 

Mixed mode assembly is built against version 'v2.0.50727' of the runtime and cannot be loaded in t

First, yes I've read every article I can find including this one: http://msmvps.com/blogs/rfennell/archive/2010/03/27/mixed-mode-assembly-is-built-against-version-v2-0-50727-error-using-net-4-development-web-server.aspx Of course it's for web server stuff, but I found this in my config file and added it. However, my problem now is that if I build in release mode I get a hard error in the error list telling me the same thing, even though it runs fine in debug and has the information in my app.config file. The really anoying part is that the error doesn't tell you WHICH assembly is the offending one. Anyone have any ideas?

VS 2008 Design Mode Hangs on Windows 2008 Server

 I have looked at all the posts I can find on this problem and tried everything I can think of, but still the problem persists. I am getting really sick of it. It was working fine for the last year until an update to MS Office 2007 caused a lot of problems (automatic update). After checking posts here, I removed it completely. No change. I then tried all the things I could find on other posts, also no change. Today, I removed VS and the Web Authoring Component and re-installed. Still no go. Does anyone have a fix for this problem. It seems that it has been around a long time, but is still giving problems. I even saw one suggestion to reformat the drive! You've got to be joking! Help please, I'm getting desparate.  

Windows 7 - Takes forever to wake up from sleep mode

I check the event viewer (under applications) and see this error message: The remote name could not be resolved: 'HTC-media'   at System.Net.HttpWebRequest.GetResponse()    at MSSConnectorService.MSSLongPoller.Poll()   I think this was from my HP media server, but I was getting the same slow wake up time before I got the server?  Could this be the cause?  I have a Gigabyte UD4P-55A motherboard running windows 7 64-bit, 8 GB RAM, and a ATI 5750 graphics card with the latest drivers installed.  Please advise.  Thanks.    

Windows Auth Web App extended to FBA, and only one web app at a time is allowing SSL

I had a farm with about 6 web applications, all using SSL. I just created another web app and extended it to use FBA. I attach a self-signed cert until its ready for prod (in IIS 6 using SelfSSL.exe), both web apps have dedicated IP's, which set under the WebSite tab in the site's properties, as well as "Multiple SSL identities for this Web Site" and the host header is listed above that in "Multiple identities for this web site" and both are listed as having the https:// protocol in Alternate Access Mapping in Central Admin. Everything is set to use port 443, both in Sharepoint and in IIS. But only one of these two web apps will allow an SSL connection at the same time, I can get SSL to work on either one individually, but as soon as I can hit the site with https:// protocol, the other site stops working with SSL, yet can be hit with the http:// protocol. what gives? Thanks

SQL Server 2008 Windows Authentication Mode fails for Database Engine, error 18456

I installed SQL Server 2008 Developer Edition (10.0.1600.22.080709-1414) on a Windows Vista 32-bit development machine with Windows Authentication Mode only (no SQL Server Authentication).   Since this is a development machine, I saw no need for Mixed Mode when I did the install.  The SQL Server Management Studio allows me to login to Analysis Services, Integration Services, Reporting Services, BUT NOT the Database Engine!Windows Authentication for the Database Engine gives the following error: EventID: 18456Login failed for user MYDOMAIN\MYLOGIN'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>]The 'fix' I have found online is to login as SA in SQL Server Authentication mode & add MYDOMAIN\MYLOGIN as a administrator for the Database Engine.  Unfortunately, I can't since I didn't install SQL Server Authentication mode (only Windows Authentication Mode).  It appears my only recourse is to uninstall, then reinstall in Mixed mode, then to login as SA in SQL Server Authentication mode & add MYDOMAIN\MYLOGIN as a administrator for the Database Engine. Before I do so, does anyone know of a better approach?Scott D Duncan

Does SQL Server in 32-bit mode installs and use 64-bit SLQNCLI on x64 Windows?

The answer to question "How to read a .dbf file on 64 bit sql server?"  states: "The basic issue is that 64 bit processes cannot load 32 bit dlls.  Many drivers only release in 32 bit mode.  I am not sure if there is an intent to add 64 bit drivers in the future.  There is a way to work around this issue, but it is sort of roundabout.  You can install SQL Express in 32 bit mode and double hop to the dbf file (or any other 32 bit only provider) through 64 bit SQLNCLI.  The 32 bit express instance can OPENROWSET using all the 32 bit drivers, and the 64 bit SQLNCLI provider can connect to the 32 bit express instance" Is it valid also for non-Express Editions of MS SQL Server? Can the same edition of MS SQL Server be installed both in 32-bit mode and in 64-bit mode - for the same services of different instances? - for different services of the same server setup?

Windows Auth - still showing login prompt in IE...

Hi, I'm trying to setup my IIS 7.0 MVC2 site but having problems. I want to use Integrated Security so that the app can obtain the user's credentials. We can then do a look-up of some AD groups to determine what they can do from that point onwards. The problem is - Every time we browse to the application, instead of navigating to our main page immediately, we get a login prompt provided by IE. I've read that we need to make sure that in the browser's Tools->Options->Advanced-> (Securiy-> ENable Windows Intagrated Security) must be checked - which it is on ALL 3 machines where I try this. The machines AND the server are all in the same domain. My config file states <authentication mode="Windows" /> and I've tried every combination for <identity...> and <authorization...> but to no avail. I can only get the "login" prompt to go away if I enable Anonymous Authentication - but then I can't detect the windows user or their group membership. What is causing the perpetual display of the login prompt - Its driving me mad ! Help...

what are valid client credentials in windows auth?

I just finished configuring a service to use net.tcp binding and use security mode of Transport with Windows creds.  Previously I had been using security mode none, but I'm trying to improve things. So this works for client computers that are members of my domain.  But when I try to launch the client on a computer using a local account login that is not a member of the domain, I get "The server has rejected the client credentials". In order for "Transport" mode "Windows" credentials to work, do all clients have to be run from domain authenticated workstations? How can I get my client to run from this non-domain computer?  Its on the same network, but not a member of the domain. -Ethan Nelson

Differentiate between Windows Auth and Forms Auth users when authenticating against same AD with Sha

I am currently working on a SharePoint 2010 project where the environment is setup with a SharePoint web application using claims based authentication. The web app is created on port 8081 using Windows Authentication for auth, and extended to port 80 using Forms Based Authentication.

The forms authentication provider is setup to use the same active directory as the windows auth based site, using the following entries in the application's web.config (the entries are in the central administration and security token service web.config files as well):

        <membership defaultProvider="i">
        <add name="i" type="Microsoft.SharePoint.Administration.Claims.SPClaimsAuthMembershipProvider, Microsoft.SharePoint, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />
        <add name="FBA_AD_MP" type="System.Web.Security.ActiveDirectoryMembershipProvider, System.Web, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="ADFBAConnectionString" enableSearchMethods="true" attributeMapUsername="userPrincipalName" />

Problem with Sharepoint 2010 - Claims Auth - Windows Auth and FBA. consistent redirects back to "cho


We have sharepoint 2010 foundation site that we can successfully login with via IE, Firefox, Chrome both on the domain and externally with Claims Authentication with only Windows Auth type selected (NTLM).

Once we add FBA and use the default signin page, we can still login (we select Windows Auth from the dropdown) BUT it only works on the domain. When we try to access externally, the only browser that works is FireFox. Both Chrome and IE just constantly redirect back to the Choose Authentication dropdown screen.

We have tried for the last 2 days to sort this out. Has anyone else experience this? It looks like the default sign in page somehow doesn't set the cookie for IE and Chrome and just bounces us back to the sign in page...

Thanks for any info...

To clarify, we are not even using the FBA yet. We are trying to login only with the windows auth and domain accounts...

hardcode windows auth- UN/PW


I know this is a poor idea, but it is meerly a starting point for me.

How can I hardcode  and pass the username / password information in an httpmodule (c#) for a windows based authentication app?

I.E i want to get to a site where i would normally need to enter username and password because authentication is set to windows, but i dont need to enter it because a httpmod is automatically passing the credentials along and i automatically get in.


MVC asp.net profile providor windows auth



 I have a MVC 2 application, that I setup with my SqlProfileProvider(setup with and already working with asp.net 2 apps)  for user profile.  I use Active Directory for my user makes with windows authentication but when I try to view the users profile setting I am getting "This property cannot be set for anonymous users."  My question is Why?   With MVC I call the command for 

httpContext.Current.User.Identity.Name and I get my domain/user name.  So I am not sure what step I am missing, is there something special i have to do for MVCX


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend