Report Server Windows Service login failed

Report Server Windows Service login failed

• DVDMIAMI

  I had the same issue and the easiest way to figure out why it cannot be created is to connect to the data tier on the business tier using the SQL Server Management Studio and then manually create a test database. In my case this issue was caused because I had changed the location of the logfiles to another drive but the path I specified did not exist yet on that drive.
  
  

• Rolandkline

  You don't want to use Report Server Configuration tool to config your report server because it should be configured by the install. But it can be used to check the health of your configuration. Execution account is optional.

  From what you described, I think your report server is Ok now. The problem you are seeing is with WSS (Windows Sharepoint Service). In the install steps you mentioned for AT, I don't see you installed WSS which is required. Did you miss that

  Bo

  
  

• BetaStar

  Sorry that you are running into issues with the installation.

  A couple of questions:

  1. Is the user running setup a member of the local administrators group on both the AT and the DT machines

  2. What account is Report Server running under (it should be running under Network Service)

  3. Was Report Server ever installed on Machine #1 at any previous time

  Thanks,

  
  
  

• KWU

  Dan,

  Yes unfortunatelly I still have the problems with Sharepoint. I never had so many problems with installing software. I am almost at the point to give up. I followed installation guide word for word and read so many posts on forums and still no luck.

  I did install it in server farm.

  Thank you for your time.

  
  

• sigmasoft

  couple more questions:

  1) When you run //localhost/reports on your AT machine, do you get a valid page displayed

  2) Go to start button\All Programs\MS SQL server 2005\configration tools\report services configuration. After you connect to the instance, do you get anything that may indicate error in the left pane

  Bo

  
  

• Talinu

  Thank you both for trying to help me and for your time.

  What I did now is I uninstalled everything on both boxes and tried installation again.

  Steps I took:

  Installed sql2k5 according to Visual Studio Team Foundation Installation Guide

  TFSInstall-v60208.chm

  DT Box

  - Installed SQL2K5 using account domain\TFSSetup (member of admin group)
  - SQL SERVER (MSSQLSERVE) Service is runing under domain\TFSSetup
  - Installed hotfix KB912838
  - Enabled TCP/IP under Protocols for MSSQLServer
  - Verified that each service is runing in SQL Server Configuration Manager
  - Installed TFS Databases and verified that they were in Object Explorer in MSSQL Server Management Studio

  AT Box

  - Installed IIS and enabled ASP.NET
  - Installed MSSQL Reporting Service where I specified name of the SQL box (DT Box) 
  - Reporting Service is runing under NT AUTHORITY\NetworkService account
  - Installed hotfix as suggested in installation guide for .NET Framework 2.0
  

  Tried installing TFS Application TIer and half way through got new error message. (please see image at the link below)

  http://i15.photobucket.com/albums/a357/ezdell/error32000.gif

  When I restart the Reporting Service I am not getting cannot connect error message anymore which is a good sign I hope. Before I was getting that message in event viewer all the time.

  Also to mention Reporting Services Confiiguration Tool. I did use it in previous installation attempts and was unable to initialize. Everything else I was able to set it to green but this time I didn't use it as it was suggested in installation guide to not to.

  Once again thank you all for your time and patience.

  Forgot to mention:

  http://localhost/Reports/ work fine and http://localhost/ReportServer gives generic page with localhost/ReportServer - /

   

  UPDATE

  Used Report Server Configuration Tool and everything is in green except email settings and execution account. Do I need to specify Execution Account

  
  

• Ricardo Jesus

  We tried to install SP1 for SQL SERVER 2005.

  But, in SP1's Hotfix log, we got message "Failed to receive sysadmin status for RS instance: MSSQLSERVER".

  We understaned that SP1 couldn't connect to the Report Server database, but we can't solve the problem.

  Help us, please !

  
  

• Mercenary4

  If you already installed Report Server and configured it previously (under another account) the Report Server databases might already be there.

  Can you check

  If they are there, go ahead and drop the 2 report server dbs (ReportServer and ReportServerTemp) and retry TFS installation

  Please ensure that Report Server is running under the Network Service account, and that this is changed using the Report Server Configuration Tool that Bo mentions above.

  Thanks,

  
  
  

• vaidas

  Are you still having problems with Sharepoint

  Did you install it in server farm configuration

  Thanks,

  
  
  

• Indiana Bob

  Genti,

  Can you post the MSI log from the failed AT install please   The install log contains a lot more information which should help us understand why things are going wrong.

  You should be able to find this in %temp% folder (or in its parent folder) and the file is called VSMSI*.txt.

  Thanks,

  
  
  

• Blue Eyes

  Bo thank you again,

  I did install WSS 2.0. Sorry forgot to mention that in my previous post.

  
  

• Mr. Trevisan Andrea

  Dan,

  thank you for your reply. Here are the answers to your questions.

  1. Yes, user running setup is a member of local administrators group on both machines.

  2. It was runinng under an account I made for sql with the right permissions but after your questions I tried running it under Network Service but is still giving me same error. Cannot connect to Report Server.

  3. It was installed once but that was when I uninstalled it to try installation again.

  Once again thank you very much for your time.

  
  

• Thibaud

  Update:

  These are the 2 errors I get while trying to install TFS AT.

  Error #1: http://i15.photobucket.com/albums/a357/ezdell/error32000_2.jpg

  Error number 1 comes at the begining of installation I'd say at about 10% then after clicking retry few times it goes away then the second error comes at about 98% and it stays there.

  Errolr #2: http://i15.photobucket.com/albums/a357/ezdell/error32000.gif

  P.S.

  I did remove reports and reportstemp db's from DT prior to installing again.

  Thanks again.

  
  

• sly_i

  Dear friends,

  I switched from dual server to single server and the thing installed just fine with no errors. I will play with this type of install for a couple of days to see how it goes. I wanted to thank you for your time and help.

  Thanks again.

  
  
• Report Server Windows Service login failed