.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

Logon failure for user DOMAIN\servername$. [Client xxx.xxx.xxx.xxx]

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :
My SQL Server 2005 is logging repeated EventID 18456 Category 4, Severity 14 State 11.  This would indicate that the login is valid but server access failed.  A trace showed that the failure is occuring on an attempted login to the Master database.  According to the error message the login attempt is not coming from a database user, it is coming from the server itself, as servername$.  That is, say the server is named Paris on domain MYDOMAIN.  The user login that is failing would be MYDOMAIN\Paris$.  The client IP address is the IP address for the server named Paris.  I don't know what it means and I don't know what to do about it.  The Paris server does host an application that uses a database on the SQL Server but that application is running fine.
Terry Smith

View Complete Post

More Related Resource Links

'IIS' & 'Kerberos' + SQL Login Failure for user 'NT AUTHORITY\ANONYMOUS LOGON'


Hi all,

Have spent hours and hours trying to work out what is goin on with this issue and i still cant figure it out.

Hopefully someone here will be able to help.

A few details to start with...

Win Server 2003 x64

SQL Server 2008

SQL RS 2008


Server A

SQL Server

Reporting Services


Server B

Reporting Services


Server B is scaled out and joined to reportserver DB of Server A.

ASP on both servers. Some apps only run on server B

Server B IIS workgroup ID is running under a domain account.


Kerberos Authentication is enabled.


I am showing intermittant errors in the RS logs stating that a connection cannot be made to a particular database, using login 'NT AUTHORITY\ANONYMOUS LOGON' even though anonymous logons are disabled in IIS.


SQL Server logs state this error as....

Date        19/05/2011 11:11:36
Log        SQL Server (Current - 19/05/2011 11:11:00)

Source        Logon

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access

How to authenticate local user usin ldap or non domain authentication



I created one application, and I need to authenticate local user. This user is the user who is login to his/her Personal Computer.. Main thing his that he/she does not in any DOMAIN... I want NON-DOMAIN authentication.. any how.... please help...

Unablke to logon on Sharepoint 2007 front-end with remote IE8 client


We are having problems to logon on the sharepoint front-end server from a client pc, within the same network. The Sharepoint 2007 servers are running on WIndows 2008 Datacenter (2 Front ends, 1 index, 1 SQL database 2008 server).

When we try to logon the server creates an event with id 4625, status: 6d, sub-status: 6a. When we use the same account from IE 8.0 on one of the servers within the farm, then it works.

The same configuration is installed within another environment where evereything works.

Is there somebody that solved this issue??

Failed to generate a user instance of SQL Server due to failure in retrieving the user's local appl

Hi ,From the last few days I am struggling with the error "Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed."I hav created an asp.net web application with membership shcema. It works fine an my developement machine but when I published it on my web server. It is giving me above error for which I searched but not found any help.Can anyone help me with this.

C# - Creating web client for automating user activity on a HTTPS site

I've been wracking my brain for a couple of weeks on this.  I need to create a web client (I don't want to use the webBrowser control because I need this to be as lightweight as possible) to log in to a secure web site, and then effectively click links and fill in fields to get the data that would normally be displayed in the web browser.  I'm then going to parse the data and perform other actions with it. I have been working with HttpWebRequest and HttpWebResponse and many permutations of suggestions I have found while Googling my issue, but I can't get rid of my problem:  Sometimes when I effictively click the ultimate link that I need to click to get to my data, I get what I am looking for.  However, MOST of the timel, I get a response page that tells me my connection timed out and that I need to log in again.  I have tried messing with cookies and such, but to no avail. I know it's good form to post my code, but it is so sloppy and screwed up right now from tweaking this and trying that, that I'd rather not take the approach of fixing what's there, rather I'd like to start with solid, clean code to begin with. Your help will be greatly appreciated. Thanks, ALo

Failed to generate a user instance of SQL Server due to failure in retrieving the user's local appl

Hi,I spend two days looking for an anwser to this problem but no luck. I have a simple ASP.NET 2.0 application which run correctly on my local machine. But After uploading all files including web.config file on a Windows 2003 Server with SQLEXPRESS installed. I have this error. Please Help!!!!!! Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed. 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: Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed.

Failed to generate a user instance of SQL Server due to failure in starting the Process for the User

Could someone help with this please? I'm using VWD 2010 to build a new web site - I tried to add a new database file but it won't do it. I started by clicking on the folder 'App_Data', then right clicking and selecting 'Add new item' - after that I tried to add an SQL Server Database but received this message...  'Failed to generate a user instance of SQL Server due to failure in starting the Process for the User Instance' What does this mean? How do I start the 'Process for the User Instance'?  I imagined all that was done for me at the install stage, when I installed VWD2010, but it appears not.  Thank you for any help at all.    Regards

Changing user domain

Hi, We have our sharepoint 2007 entreprise farm importing users from two different AD. Let's say 'potato' and 'orange'. We have mysite creation activated in our farm. We have to change one user from potato to orange. The user domain is not in the mysite url of the user. We have http:\\...\personal\fLastName. Questions: 1- How can I change potato\fLastName to orange\fLastName?    We wante to disable potato\fLastName AD account and then create orange\fLastName.     Does it impact profile AND mysite? 2- What are the impact on document history?   Will I still be able to see what potato\fLastName changed or it will show orange\fLastName? Thanks.

Failed to generate a user instance of SQL Server due to failure in retrieving the user's local appl

Hello everybody.I am working on Login control and I am new in ASP.NET. So far what I did is :1. In Website->ASP.NET Configuration I change the form authentication to internet.2. I created a user profile3. This gave me a ASPNETDB.mdf database.4. I added this code :<connectionStrings> <remove name="LocalSqlServer" /> <add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient"/> </connectionStrings> in web.config file.4. I added login control to my login page :<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Login.aspx.cs" Inherits="Login" Title="Untitled Page" %><asp:Content ID="MainContent" ContentPlaceHolderID="MainContentPlaceHolder" Runat="Server"> <h1>Please Login</h1> <asp:Login ID="LoginAuth" runat="server" > </asp:Login></asp:Content> 5. And the login.aspx.cs file has :using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.W

Cannot create user: server cannot determine if it is member of a domain

Hi, An instance of our 2008 SP1 SQL Server is running on a computer that was removed from it's domain and then re-added. Now, when I want to create a new login in Management Studio via the nodes Security/Logins, selecting "New Login", entering DOMAIN_NAME\USER_NAME as login name and then click "Search", I get an error message (in German) "Das Programm kann das erforderliche Dialogfeld nicht öffnen, da nicht ermittelt werden kann, ob Computer "COMPUTER_NAME" einer Domäne zugeordnet ist. Schließen Sie dieses Dialogfeld, und wiederholen Sie den Vorgang". Translation: "The program cannot open the required dialog, as it cannot be determined if computer "COMPUTER_NAME" is assigned to a domain. Close this dialog, and repeat the process." But closing the dialog and repeating as suggested does not help. Even restarting the SQL Server service and re-connecting in Management Studio did not help. I keep getting this message. I found, however, that just entering the domain and user name and then clicking Ok seems to add the user. Anyway, it is irritating to get this error message when clicking "Search". How can I tell the engine that the computer is really member of the domain again? Frank

Get current logon user id with SPContext.Current.Web.CurrentUser.LoginName

Hi all,I've been trying to search for the method to display the currently logon user id. So far, most sites I've visited used SPContext.Current.Web.CurrentUser.LoginName.I've tried this in my SharePoint custom application page. Everything works great.I have a test account, when logged in, was displayed as xxx\testacc.For some reasons, I changed the id in AD to xxx\test and did a full import to MOSS.I logged in to the custom application with the changed id, i.e. xxx\test, BUT the value of SPContext.Current.Web.CurrentUser.LoginName still displayed as xxx\testacc!How do I get the latest id? Has anyone encountered this before?Thank you.Kelvin

People Picker gets error when selecting user from a trusted domain(one way forest trust)

  Hello all,   Our current setup is SharePoint 2010 Foundation server in one external forest(Trusting forest), and trying to have users in a separate internal forest(Trusted forest) access the site. The external forest's DC and SharePoint server are in a DMZ separated by a firewall with the internal forest's DC and users. A one way transitive forest trust was successfully created and has been validated. On SharePoint, we're ran the sts commands to set the setapppassword as well as the peoplepicker-searchadforests adding the domain that the SharePoint server is in, as well as the trusted forest. An iisreset was issued after running these commands. In SharePoint, we can then search for users from the trusted domain, and select the users in the Select People page, but when hitting the final Ok, an error is received: An unexpected error has occurred in which a correlation ID is provided. Reviewing the SharePoint logs we find the following: <!-- /* Font Definitions */ @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-520092929 1073786111 9 0 415 0;} @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-520081665 -1073717157 41 0 66047 0;} /* Style Defin

Import user profile from another domain active directory

Hi, I have SharePoint 2010 running on DomainB andwe have corporate users on DomainA. i need to import users from both domainA and DomainB. I am able to import users from domainB and not able to import users from DomainA. I made a successful connection to both Domain A Ad and DomainB AD in SharePoint 2010 user profile synchronize connections. I am able to sync users only from DomainB (SharePoint 2010 running on domainB) and not able to synchronize profiles from DomainA (outside domain). Is there any additional configuration I need to do. Please help me on this issue. Thanks, Ratna

User Profiles Error - Failure trying to synch web application... No User Profile Application availab

Hello, everyone, I've got an issue I can't seem to figure out. every since I set up my farn and configured the User Profile Service Application, I've been getting the following error every morning at 6:11 AM: Log Name:      Application Source:        Microsoft-SharePoint Products-SharePoint Portal Server Date:          9/3/2010 6:11:23 AM Event ID:      5555 Task Category: User Profiles Level:         Critical Keywords:      User:          NS\spfarm Computer:      jxnpvsp01.NetworkStreaming.local Description: Failure trying to synch web application 3f3f96cc-8bbd-439c-ae80-1ed633c6ec1d, ContentDB 6ef952b5-3312-46a2-b3e1-1b5218b5d209  Exception message was Microsoft.Office.Server.UserProfiles.UserProfileApplicationNotAvailableException: No User Profile Application available to service the request. Contact your farm administrator.    at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.get_ApplicationProperties()    at Microsoft.Office.Server.Administration.UserProfileApplicationProxy.get_PerfmonInstanceHandle()    at Microsoft.Office.Server.UserProfiles.ContentDBS

The specified user account "domain\username" is a local account. Local accounts should only be used

HI Im getting this error when trying to set a new Service account for my performance point services. SharePoint is installed in a single server enviroment. I can´t get a new service account configured and I think this is causing my server to run slowly. Any help would be highly appreciated thanks

User Profile Service - "The specified user or domain group was not found"

Hi there, I had configured the User Profile Service and all was working well (Syncing with AD etc.). However, something has gone wrong. The services still appear to be running; both Forefront Identity Manager services are running, and the services show as 'Started' in Central Administration. The 'My Profile' and 'My Site' options have disappeared though, and browsing to the My Sites page results in an error (Could not load user profile). To make matters much worse, it seems to have also broken the Central Administration site. If I try and go to 'Manage Service Applications' I get another error (The specified user or domain group was not found). This error seems to come up on around half of the pages on the Central Administration site. Looking up the error (abb6b174-0f71-413a-a27a-41cdc87b66d0) in the logs I find this: 09/06/2010 15:35:45.44  w3wp.exe (0x0868)                        0x06A0 SharePoint Portal Server       User Profiles                  cm6y High     User Profile Application Proxy failed to retrieve partitions from User Profile Application: Microsoft.Office.Server.UserProfiles.UserProfileA

Hyphens in domain names get trimmed from account names in user profiles

We've been trying to launch an internal deployment of SharePoint 2010 MySites but we've run in to a problem with the user profile import. We've reviewed all of the relevant guidance and have been able to complete an import successfully, but all of the characters before a hyphen in our domain name are getting truncated from the imported username. To illustrate:   PREFIX-BLAH\tristan.watkins becomes BLAH\tristan.watkins after it is imported. When I log in, a new user profile is created for PREFIX-BLAH\tristan.watkins and all of the imported profile data is useless, since it is associated with a non-existent BLAH\tristan.watkins.   I'm assuming this is an issue with the beta version of Forefront Identity Manager 2010 that shipped with SharePoint 2010 beta, but I can't find any information suggesting this is a known issue and for all I know it may actually be a SharePoint issue rather than a problem with FIM. For what it's worth, this was not a problem in SharePoint 2007. Can anyone help?
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