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

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

Windows Authentication doesn't work after change of admin pass

Posted By:      Posted Date: September 27, 2010    Points: 0   Category :Sql Server


J have read many answers about

Login failed for user '. The user is not associated with a trusted SQL server connection

error, but I don't want to mess up in my sql server so I want to be sure that what I do is OK.

Environment description:

In my company, we have our own application wchich we use to connect to database. All users use SQL Server Auth except me. I can log using Windows Auth from server and from my second computer.

Now everything works fine.

- My comp is in our domain 'OurDomian'.

- On server in AD is admin account 'SqlAdmin'.

- In MSSMS in Security->Logins there is account: OurDomian\SqlAdmin

- on my comp account OurDomian\SqlAdmin is added

I can log to sql server from  my comp using 'Integrated Security' in application with no problem.

Problem description:

Problem starts when I change SqlAdmin password on server.

When I connect from my comp I get the above error. But when I connect from server there is no problem.

I searcher application code and I don't think that I have to change somthing in it. Probably I have to change something with account and permissions.

1. Will it bee enough to delete and add again 'OurDomian\SqlAdmi

View Complete Post

More Related Resource Links

Windows Authentication Doesn't work properly



I've implemented Windows Authentication with kerberos protocol.

Each time user visit site they have to hit Sign in button and then they get logged in. IE doesn't recognized automatically user and signed in.

Thanks, Sam

MVC 3.0 Beta Bug: Windows Authentication doesn't work


Windows authentication doesn't works for me.

Here are steps to reproduce:

  1. Open VS2010
  2. Create an "ASP.NET MVC 3.0 Web Application" with the Empty template
  3. Add a HomeController controller.
  4. Change the authentication element in web.config to: <authentication mode="Windows" />
  5. Under project Properties > Web enable NTLM Authentication
  6. Add a break point inside HomeController.Index().
  7. Start debugging.

When the breakpoint is hit, I get:

User.Identity.AuthenticationType = ""
User.Identity.IsAuthenticated = false
User.Identity.Name = ""

When I follow the above steps with an "ASP.NET MVC 2.0 Empty Web Application" project, I get:

User.Identity.AuthenticationType = "NTLM"
User.Identity.IsAuthenticated = true
User.Identity.Name = "<My Username>"

which is correct.

logoff doesn't work through windows service

Dear Friends, I am facing this problem on Windows 2003 and 2008 Server. On XP it works fine. I have written and Windows Service that takes receives the command and executes tasks such as Logoff, Shutdown, etc. All the commands except Logoff works fine. I tried following ways to perform the Logoff. However it didnt work. Try 1:                 Process.Start("shutdown", "-l"); Try 2:     [DllImport("user32.dll")]     public static extern int ExitWindowsEx(int uFlags, int dwReason);     ExitWindowsEx(0, 0); Try 3:     Process _currentProcess = new Process();                _currentProcess.StartInfo = new ProcessStartInfo("shutdown", "-l -f");                _currentProcess.StartInfo.UseShellExecute = false;                 _currentProcess.Start(); Try 4:     Process.Start("logoff.exe", null); If I write a simple C# based applicatin (not Service) it works fine for all the tries that I have made. I am facing this problem only when I put this code

Change from Forms Authentication to Windows Authentication

What do I need to do in order to change an application from Forms Authentication to windows authentication?

Windows explorer view doesn't work on Windows 7

We are running Office SharePoint 2007 with SP2 on windows 2003 server. All windows 7 with IE 8 gets this message: " Please wait while Explorer View is loaded. If Explorer View does not appear, your browser may not support it". when click Windows Explorer in View. All Vista and XP work fine. I have tried these: 1. Added the SharePoint site on a Trusted Site. 2. Web Client is set to Automatically start, and that it is started. 3. We have Office 2003 installed on all computers. 4. We also tried to enable Comtability View. Is there a fix?Bob Lin, MS-MVP Networking, Internet, Routing, VPN Troubleshooting on http://www.ChicagoTech.net How to Setup Windows, Network, VPN & Remote Access on http://www.howtonetworking.com

how to change the web application Database connection form Windows authentication to SQL Server acco

Hi, I have a web application created and Database connection authentication was given as Windows authentication. how can i change it to a SQL server account in MOSS 2007. Thanks in advance.

.NET Assembly with COM interface doesn't work in 64-bit windows



I've created a simple test DLL, written in C#, with a COM interface.

using System;
using System.Collections.Generic;
using System.Text;
using System.Runtime.InteropServices;

namespace ComInterfaceTester
  public interface IMyClass1
    string GetAString(int aiNumber);

  public class MyClass1 : IMyClass1
    public MyClass1()



Pass DataGrid SelectedCells as CommandParameter doesn't work



I'm using the DataGrid control, and I want to have a command work on several cells the user selected:

<MenuItem Header="Replace with NOP"
          Command="{Binding ReplaceWithNOPCommand}"
          CommandParameter="{Binding ElementName=m_grid, Path=SelectedCells, Converter={StaticResource cellsToMemoryRangeConverter}}">

However, the converter's Convert function is called only once! at the beginning.

If I change the code to :

<MenuItem Header="Replace with NOP"
          Command="{Binding ReplaceWithNOPCommand}"
          CommandParameter="{Binding ElementName=m_grid, Path=CurrentCell, Converter={StaticResource cellsToMemoryRangeConverter}}">

Then the converter gets called each time I invoke the command... and it works ok. But it's not enough since I wanted all the selected cells.

Why is that?
Is there a difference between CurrentCell and Selected cells?

I'm using the PRISM's composite WPF and the MVVM pattern.
I know many ways to workaround this, but I would really like to

Change Password for Windows Authentication


Hello all,

I do not seem to be able to find even a yes no answer on this...

Using windows Authentication... is it possible to progrematically change a password?


I tried using several ways to do this. I tried using the ChangePassword  control. This tells me that minimun characters is 7 even though I have more then 7 characters... I also tried using this method:

            if (u.ChangePassword(TextBox2.Text, TextBox3.Text))
                LabelError.Text = "Password changed.";
                LabelError.Text = "Password change failed. Please re-enter your values and try again.";
        catch (Exception ex)
            LabelError.Text = "An exception occurred: " + Server.HtmlEncode(ex.Message) + "<BE>" + ex.ToString() + ". Please re-enter your values and try again.";


The user is always null... and I am assuming this is because this object is indended to use with Forms authentication.


All I want to do is have an option for users to change passwords. Is this possible with Windows Authentication?

Why doesn't the Windows authentication working?


I'm trying to write a simple ASP.NET 4.0 app, using Windows authentication to login.  This is on my peer-to-peer home network.  When I click to login, it instantly shows my Windows identity, so it looks as though I don't even need to login, as it's already done that for me.  However when I then go to any other page in the app, it looks as though I'm not logged in.

Why is that and how do I fix it? 

PageData weirdness, works, then doesn not work. Change the 'index' name and it works again


I'm facing a weird issue. I have a page "add.cshtml" in wich I create a PageData object like this:


PageData["myObject"] = new { Message = "some msg", ID = 1, Name = "some name" }

In that same page, I pass the object to a RenderPage:



@RenderPage("form.cshtml", PageData["myObject"])


In "form.cshml", I simply call values like this:


<br />

When I call "add.cshtml", it works, then for some reason, at some point, I get an error stating: "object" does not contain a definition for Message, if I comment the @PageData["myObject"].Message, error occurs on next property.

When this happens, I change "myObject" to another value in both files, and no more compilation error.

Why does this happen?



How to Localize Windows Forms and Change the Language at Runtime

Localization is the process of customizing your application to a particular language, culture or locale. Visual Studio provides support for localizing Windows Forms with much ease. In this article, we will see how to localize windows forms and give the user the ability to change to his preferred language at runtime.
When you run a localized application, the appearance is determined by two culture values. The UICulture property is used to specify which resource files will be loaded for the form. The Culture property, on the other hand, determines how strings such as dates, numerals, and currency amounts are formatted.
Let us see the steps required to create a localized form. You can then expand this example and adopt the same approach for the rest of the forms in your project

Web Matrix + Windows Authentication


I'm curious if its possible to get windows auth working with asp.net webpages/webmatrix.

I've got it published to IIS with windows auth turned on and anonymous/forms/basic turned off.

I'm guessing the WebSecurity Helper probably won't work here but can you access User.Identity.Name etc?

Sorry for the newbie questions, I've only just started working with asp.net ^^,

Windows Authentication for IIS in Windows 7 Home Premium Edition - for ASP Websites.


How to create a virtual directory and get benefit of the IIS. Is there a workaround to accomplish this without the Windows Authentication for Windows 7 Home Premium Edition?

Thanks in advance, 

Using windows authentication to access SQL when using ASP.NET 4.0 via COM+


I am using SQL Server 2008 under windows authentication, front end is ASP.NET which uses COM+ to access database.

COM+ components are configured to run as domain user.

When looking through the logs (SQL Profiler), I can see the login name as the configured identity instead of windows indentity.

I have got Website running under "Intergrated Windows Authentication" and database is running locally on webserver.

Web configure contains entry for <identity impersonate="true"/>.

My connection string is

connectionString="data source=db01\test01;initial catalog=test; integrated security=SSPI;persist security info=False; Trusted_Connection=Yes"

Any ideas?




When I use 'publish', site doesn't work when i post data


Arrgghh, I am so tired of dealing with stuff like this

I've got a project, when I put up on another server I point two sites in IIS6 to it

i have

http://www.main.com  pointing to the folder the files are in


http://www.anotherofoursites.com/main pointing to that same folder in it's own "Virtual Application" or whatever IIS calls it when you put a folder into it's own 

If I just "Build" and push all the files up.. both work without issue and as expected...  but when I use "Publish" to precompile, the site works until I post, and then i get nailed with:

Server Error in '/' Application.
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
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