Error Logon Failed - SSRS Service User Account Rights
Jun 12, 2006
I am facing a problem which is based on the restrictions on the domain of the customer. After deplyoing the report on the server we are getting the following error message in the report manager after executing (clicking) a report link:
Logon failed.
Logon failure: the user has not been granted the requested logon type at this computer. (Exception from HRESULT: 0x80070569)
I googled for that and it seems to be an authentication issue where some user / account is not granted to log on as service / locally, but the problems is better described than the solutions. Did anyone faced that problem so far ? Which account has to be granted what priviledges or permissions in Windows. We are using a SQL Server 2005 / Reporting Services 2005 running on the same machine whereas the virtual directories Reports and Reportserver are running in a separate Application Pool
I have come across this error message in ssrs and cannot seem to locate the error. Report manager lets me logon-- I can navigate to the folder but once I click on the actual report I get this error
Hi, I have a service using SQL 2005 Express database, the service is started automatically on system startup, most of the times it can logon to the database successfully, however, sometimes, I got the following error:
"Error: 18456, Severity: 14, State: 16"
Any suggestions?
Thanks in advance!
Yuxi
2006-11-22 11:09:49.90 Server Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2006-11-22 11:09:49.92 Server (c) 2005 Microsoft Corporation. 2006-11-22 11:09:49.92 Server All rights reserved. 2006-11-22 11:09:49.93 Server Server process ID is 1956. 2006-11-22 11:09:49.93 Server Logging SQL Server messages in file 'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'. 2006-11-22 11:09:49.93 Server This instance of SQL Server last reported using a process ID of 1952 at 11/22/2006 11:08:07 AM (local) 11/22/2006 7:08:07 PM (UTC). This is an informational message only; no user action is required. 2006-11-22 11:09:49.95 Server Registry startup parameters: 2006-11-22 11:09:49.95 Server -d c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf 2006-11-22 11:09:49.95 Server -e c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG 2006-11-22 11:09:49.95 Server -l c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf 2006-11-22 11:09:49.98 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required. 2006-11-22 11:09:50.00 Server Detected 4 CPUs. This is an informational message; no user action is required. 2006-11-22 11:09:50.95 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required. 2006-11-22 11:09:50.96 Server Database mirroring has been enabled on this instance of SQL Server. 2006-11-22 11:09:50.96 spid4s Starting up database 'master'. 2006-11-22 11:09:51.06 spid4s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required. 2006-11-22 11:09:51.18 spid4s SQL Trace ID 1 was started by login "sa". 2006-11-22 11:09:51.23 spid4s Starting up database 'mssqlsystemresource'. 2006-11-22 11:09:51.25 spid4s The resource database build version is 9.00.2047. This is an informational message only. No user action is required. 2006-11-22 11:09:51.59 spid8s Starting up database 'model'. 2006-11-22 11:09:51.60 spid4s Server name is 'TestMachineTestSQLServer'. This is an informational message only. No user action is required. 2006-11-22 11:09:51.60 spid4s Starting up database 'msdb'. 2006-11-22 11:09:51.93 Server A self-generated certificate was successfully loaded for encryption. 2006-11-22 11:09:51.93 Server Server local connection provider is ready to accept connection on [ \.pipeSQLLocalTestSQLServer ]. 2006-11-22 11:09:51.93 Server Server local connection provider is ready to accept connection on [ \.pipeMSSQL$TestSQLServersqlquery ]. 2006-11-22 11:09:51.93 Server Dedicated administrator connection support was not started because it is not available on this edition of SQL Server. This is an informational message only. No user action is required. 2006-11-22 11:09:51.95 Server SQL Server is now ready for client connections. This is an informational message; no user action is required. 2006-11-22 11:09:52.12 spid8s Clearing tempdb database. 2006-11-22 11:09:53.12 spid8s Starting up database 'tempdb'. 2006-11-22 11:09:53.21 Logon Error: 18456, Severity: 14, State: 16. 2006-11-22 11:09:53.21 Logon Login failed for user 'sa'. [CLIENT: <local machine>] 2006-11-22 11:09:53.70 spid4s Recovery is complete. This is an informational message only. No user action is required. 2006-11-22 11:09:53.70 spid11s The Service Broker protocol transport is disabled or not configured. 2006-11-22 11:09:53.70 spid11s The Database Mirroring protocol transport is disabled or not configured. 2006-11-22 11:09:54.09 spid11s Service Broker manager has started. 2006-11-22 11:10:19.26 spid51 Starting up database 'TestDatabase'. 2006-11-22 11:10:19.42 spid51 Recovery is writing a checkpoint in database 'TestDatabase' (5). This is an informational message only. No user action is required. 2006-11-22 11:18:08.92 spid51 Starting up database 'TestDatabase'.
I need help. The security principal is the correct DomainUser, but the error message says I am not authenticated. So here is my error Message: Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. Me.User.Identity.Name=CompanyDomainRyan; System.Security.Principal.WindowsIdentity.GetCurrent=CompanyDomainRyan; HttpContext.Current.User.Identity.Name=CompanyRyan Generated by: Dim secPrinc As System.Security.Principal.WindowsIdentity = System.Security.Principal.WindowsIdentity.GetCurrent Me.lblError.Text = ex.Message & vbCrLf & vbCrLf & "Me.User.Identity.Name=" & Me.User.Identity.Name & "; System.Security.Principal.WindowsIdentity.GetCurrent=" & secPrinc.Name & "; HttpContext.Current.User.Identity.Name=" & HttpContext.Current.User.Identity.Name Here is the Connection String: Private ConnString As String = "Server=10.144.162.111;Database=DNS;Trusted_Connection=True"
IIS has 4 websites hosted on it. The parent level allows anonymous with windows auth off, but the website level has anonymous off with widnows auth and digest. In IIS, is there a problem with having the parent level anonymous and website level windows auth?
My Report Server works find but after apply SQL Server 2005 Service Pack2. I can't connect to ReportServer Database. When Trying to connect from SQL Server Management Studio i get following Page.
TITLE: Connect to Server ------------------------------
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <html> <head> <title> SQL Server Reporting Services </title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.3054.00" /> <meta name="HTTP Status" content="500" /> <meta name="ProductLocaleID" content="9" /> <meta name="CountryLocaleID" content="1033" /> <style> BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black} H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt} LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline} .ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray} A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR3366CC; TEXT-DECORATION:none} A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLORFF3300; TEXT-DECORATION:underline} A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR3366CC; TEXT-DECORATION:none} A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; colorFF3300; TEXT-DECORATION:underline}
</style> </head><body bgcolor="white"> <h1> Reporting Services Error<hr width="100%" size="1" color="silver" /> </h1><ul> <li>The report server cannot open a connection to the report server database. The logon failed. (rsReportServerDatabaseLogonFailed) <a href="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsReportServerDatabaseLogonFailed&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.3054.00" target="_blank">Get Online Help</a></li><ul> <li>For more information about this error navigate to the report server on the local server machine, or enable remote errors</li> </ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span> </ul> </body> --. (Microsoft.SqlServer.Management.UI.RSClient)
------------------------------ BUTTONS:
OK ------------------------------
Colud anyone help me to resolve this issue please???
I just upgraded to Vista and can not run the website anymore. Getting: Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. error I added that user to all databases as db_owner, but that did not help..
I am receiving the above error when using a workstation to connect to my webfiles.
I am using windows authentication (whcih I have selected as my only option on the IIS). Impersonate is set to true in the webconfig file, with authentication set to Windows.
My connection string is: SQLConnection1 = "initial catalog=SIMS;data source=spacesql;integrated security=SSPI"
It runs no problem when I use the localhost. It allows me to use other aspx pages that do not connect to the SQL server. It only gives me this error when I am using a page that tries to connect to the SQL server.
The SQL files reside on a separate server to the IIS and I would like it to remain this way.
i'm a software devoloper , i writed a web application and use with this application sql server 2005
my application work very good but if i try to open the application using domanuser the application failed and write this error : Logon,Unknown,Login failed for user 'EPSDOMAINabeel'. [CLIENT: 192.168.0.132]
i know that i have a problem with permmison at the database, how can i solve this problem.
i'm a software devoloper , i writed a web application and use with this application sql server 2005
my application work very good but if i try to open the application using domanuser the application failed and write this error : Logon,Unknown,Login failed for user 'EPSDOMAINabeel'. [CLIENT: 192.168.0.132]
i know that i have a problem with permmison at the database, how can i solve this problem.
I get the following error message when I select a report:
An error has occurred during report processing.
Cannot create a connection to data source 'PSS5'.
Login failed for user 'NT AUTHORITYANONYMOUS LOGON'.
My Data source is set to Windows Integrated Security when I get this error message. If I change my data source to be "Credential supplied by the user running the report", the report generates fine. I am running SQL 2005 SP2. I have SQL reporting services installed on different server than my database services. Both servers are W2K3 R2 x64.
My IIS website and virtual directories are set up for Integrated Windows Authentication. My IIS application pool is set up to use an AD service account. I have followed the step/procedures outlined at: http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/security/tkerbdel.mspx
I'm trying to connect to a Sql Server 2005 database from my local development machine, which is running IIS 5.1 (Windows XP Pro). The web application is not using impersonation and has anonymous access enabled. In my system's machine.config file, I've set the processModel section to look like:
This has been working fine for us connecting to SQL Server 2000 databases (running on Windows 2003). When we connect, I access Sql 2000 databases under the context of "OurDomainMyMachineName$". However, we've recently installed Sql Server 2005 on a new Windows 2003 server & when I connect to that server, I receive the error:
System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITYANONYMOUS LOGON'
when trying to call the SqlConnection.Open() method. Our connection string is very basic:
Data Source=sql-dev2; Initial Catalog=TestDatabase; Integrated Security=True; Application Name=PrototypeWebservice;
In the Sql Server logins, we've granted the computer account "OurDomainMyMachineName$" db_owner access to every database (in both Sql Server 2000 & 2005).
I am able to connect to the Sql Server 2005 databases if I change my section in machine.config to <processModel userName="OurDominamyPersonalAccount" password="myPersonalPwd"/>, or if I move the application to an IIS6 server & set the application pool identity to NETWORK SERVICE, but we'd like to continue accessing our Sql Server 2005 databases (from our development machines running IIS5.1) as we currently access our Sql Server 2000 databases; under the context of "OurDomainMyMachineName$".
Would anyone have any ideas why this would be happening or how to resolve? Thanks in advance.
I have two machines that i want to use for merge replication :
Laptop ( Publisher + Distributor )
VPS90 ( Subscriber )
Both connected via the internet
NO DOMAIN
Need to implement merge replication ,after initializing the snapshot I get the following error on both machines :
Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: 192.168.1.1]
I created a new user "Repuser" (admin)with the same password on both machines and configured the Agent proccess to run under that account ,now i get this error : Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 192.168.1.1]
Please note that :
· Mixed mode authentication IS ENABLED ON BOTH MACHINES · BOTH MACHINES CAN PING AND ACCESS EACH OTHER ,BOTH COMPLEETELY VISIBLE. · CONFIGURED ALIASES ON BOTH MACHINES. · Both configured to use Sa account . * I have NO DOMAIN
what does this mean?
It simply means that the SQL Server Agent process account is the one that€™s being authenticated to connect to the other machine and NOT the Sa account ,WHY?
Fairly new to SSIS.I have created a package in BIDS, and am trying to execute it so i can test/debug the flow and view the data in the data viewers. I continually get a logon failed for user... its the user id i am using to connect to my SourceConnection OLEDB. I have been struggling with this for a while now, and getting frustrated. I tried Windows Authentication also, still i get an error message logon failed for user......
I have tried all of the security settings, from Do not save sensitive to Encrypt all with password, entered the password, and then try to Execute Package from the solution explorer and still get error message. Thanks for your help!
Here is the error message
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Login failed for user 'UserName'.".
We seem to be being plagued by the error below by our SQL Server agent. This happens almost everytime we restart the server that has been running for a day or two.
Our SQL Server Agent uses a none expiring domain credential. I understand that this problem only happens when the profile being used by the SQL Servr Agent has changed (password change). What puzzles me is that the login is A ok and no changes has been made to it's password.
We always resolve this problem by changing the login used in the SQL Server Agent to local and after that, returning it back to it's original domain login. Unfortunately, we cant always do this everytime something goes wrong.
Can anyone please help us shed a light on this? We're using SQL2k with SP3a. Thanks!
Error:
An error 1069 - )The service did not start due to logon failure) occurred while performing this service operation on the SQLServerAgent service.
Hi, Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITYLOCAL SERVICE'. my applicaton working on other machine perfect with the same code but when i upload on web server showing me above error.
I need help with a problem: When trying to process a analysis services project, I receive the following error message -
OLE DB error: OLE DB or ODBC error: Login failed for user 'NT AUTHORITYLOCAL SERVICE'.; 28000; Cannot open database "DocumentDB" requested by the login. The login failed.; 42000.
I am using the service account for impersonation for the datasource. One suggestion I received from the data-access forum was to grant privileges to the local service for the database. I am not clear about the procedure to do that. Can someone please guide me through this? I am posting this question in this forum since this is a authentication/privilege issue.
We have a SQL 2000 Active/Passive cluster running on Windows 2000. On one node, everything logs in fine (second node is powered off). I can use local authentication fine in OSQL (-E) and even see my connection in SQLEM current activity as [DomainUser] for the NT account which I am logged in as. Then I bring the second node online and initiate a failover. SQL Server starts but Cluster Admin cannot connect and starts throwing this Anonymous Logon error. I open a command prompt and try the same OSQL (-E) local login and sure enough it is also giving the Anonymous Logon connection user. I do not understand why the failover to a second node is causing the Trusted Connection Local authentication to switch to Anonymous instead of the [DomainUser] which I am using. Any help is appreciated. John.
Hi all, I do understand that it is highly recomended to have aserprate user (perfered a domain user account) for each of the SQL Server service and SQL Agent service. What is the reason behind that? (Someone told me to not run the service with an account that has a powerul privilegs! - I don't undrstanmd this point can you explain it please?) What is the diffrent between: 1- Local System account 2 -Network Service account
I get this error when trying to alter a stored procedure that has an insert statement referencing a new linked server I created:
INSERT INTO [servername].databasename.dbo.DirectReport ...
Msg 18456, Level 14, State 1, Procedure Get_Direct_Pay_Move_Data, Line 17 Login failed for user 'NT AUTHORITYANONYMOUS LOGON'.
I added Administrators and my logon to the permissions of my linked server but still get this error when it tries to save my stored proc...the one which has that insert.
Okay now this is weird, today the Reporting Services was not running and here are the entries in the event log:
Event Type: Error Event Source: Service Control Manager Event Category: None Event ID: 7041 Date: 12/12/2007 Time: 9:47:22 User: N/A Computer: TFS Description: The ReportServer service was unable to log on as DOMAINTFSREPORTS with the currently configured password due to the following error: Logon failure: the user has not been granted the requested logon type at this computer.
Service: ReportServer Domain and account: DOMAINTFSREPORTS
This service account does not have the necessary user right "Log on as a service."
User Action
Assign "Log on as a service" to the service account on this computer. You can use Local Security Settings (Secpol.msc) to do this. If this computer is a node in a cluster, check that this user right is assigned to the Cluster service account on all nodes in the cluster.
If you have already assigned this user right to the service account, and the user right appears to be removed, a Group Policy object associated with this node might be removing the right. Check with your domain administrator to find out if this is happening. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp
I am the administrator of the machines and I can assure you that no domain policy has changed for a couple of weeks. What should I look for?
i connect to remote Integration Service. i configure server for remote connection( on component services and DCOM config , ... ) .and now i can connect to Integration Service remotely and correctly.
but when i expand Stored Package and then click to expand MSDB this error will hapen:
login failed for user ... .(microsoft sql native client )
When try to run report, I receive this message:€śLogon failed.
For more information about this error navigate to the report server on the local server machine, or enable remote errors We just have Reporting Services server (2005) up and running, my roles are browser, Content Manager, My Reports, Publisher, Report Builder. I was able to deployed the report and set up data source. Connect using credentials supplied by suer running the report, and use as Windows credentails when connecting to the data source checked. Did a search on but can't find any messages that related to this problem. Please advise.
The local sql server that was working fine earlier does not start now. I have already created tables and accessed them using stored procedures.
I get an error 1069: The service did not start due to logon problems. I have only changed my domain password. I do not remember what authentication I chose for log on.
Cannot open user default database. Login failed.Login failed for user 'NT AUTHORITYNETWORK SERVICE'. 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: Cannot open user default database. Login failed.Login failed for user 'NT AUTHORITYNETWORK SERVICE'. I have This Error When i try to log into My online web site, i have no idea how to fix it,one day it was working and the next it wasnt, is there any way to find out what database the default is and if it's either incorrect or not present change the web.config in a way that will make my system work. i have the NT Authority/Network Service in my Server Properties Permissions, its given the type login and is granted Connect SQL by sa i have 3 colder copies of the web site on my server my question is, how would i use of of these to restore the original site configuration is there a way to restore the original configuration to undo whatever it is i've done to break the system ChrisStressed
i'm using the Enterpirse library logger to write logs into a database. When choosing connection string i choose the database i want in the "connection properties" dialog box and push 'Test connection' button. everything goes well.
then i open the SQL Server Management studio express and connect to the databse to check some things, from that point on , when i push the 'Test Connection' button in the Enterprise library i get the error:
"cannot open user default database. Login failed. login failed for user My'server/MyuserName'"
even when i close the sql server manager , it is still stuck - the connection test doesn't work anymore.... it only work when i restart the computer.
During install of SQL Server 2005, we can of course use a domain account or the built-in system account for running the services. I lean toward domain for obvious reaons but would like to know a +/- to each option and why I'd choose one over the other and what consequences or limitations one may encounter if I choose one over the other.
I'm trying to execute a SSIS package via proxy user but I keep getting the following error message regardless of I have tried to do to fix it, I have done the following so far:-
1. Recreated the proxy user 2. Retyped the password, under credentials
Message : Unable to start execution of step 1 (reason: Error authenticating proxy "proxyname", system error: Logon failure: unknown user name or bad password.). The step failed.