Problem with Reporting Service when installing SQL Server 2005 on Windows Server 2008 Small Bussiness Standard x64
Hi, I have a problem during SQL Server 2005 installation. I am using Microsoft Windows Server 2008 Small Bussiness Standard 64 bit. First of all, I installed Windows SBS 2008 64 bit to a Dell Power Edge T310 computer. After the installation, I logged in to the domain I created during Windows installation as the account that also created during Windows Installation. Then, I enabled 32 bit application in 64 bit Windows from command prompt using this script: cd c:\inetpub\adminscripts cscript adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1 I turned off Windows Firewall and began the SQL Server 2005 Installation. During the installation, I got this error message: SQL Server Setup could not validate the service accounts. Either SQL Server 2005 cannot run the service account as a Local Service account or Network Service account on a domain controller or this edition of SQL Server 2005 cannot run the service account as a Local Service account or Network Service. For more information, see Setting Up Window Service Accounts in SQL Server Books Online. The logon account cannot be validated for the service Reporting Services. Can anybody help me to solve this problem? Thank you.
June 15th, 2011 10:55am

Sorry, I forgot to mention 1 thing.. I have another problem during the same SQL Server 2005 installation. The error message was: SQL Server Setup failed to modify security permissions on registry key SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2\MSSQLServer\SuperSocketNetLib for user Administrator. To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL Server Setup has administrator privileges, and that the registry key exists on the destination drive. I have solved this problem by modifying the registry in HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Microsoft SQL Server/90/Machines/OriginalMachineName. I changed the value from "WIN-EUGSo7LO7PY" to my computer name. This modification can solve the SuperSocketNetLib problem. But the reporting service problem still accour. When I tried the installation in a WORKGROUP (still using WINDOWS SBS 2008). The error about reporting service isn't came out, but the SuperSocketNetLib problem occur although I have changed the registry. Please help me.. I have spent days solving this problem.. I just need the SQL Server 2005 with reporting service installed in the computer, either in a domain or in a workgroup. Thank you very much..
Free Windows Admin Tool Kit Click here and download it now
June 15th, 2011 11:37pm

Hi b3nn, In a SBS domain environment, usually, the SBS server would become a domain controller. So, when install the SQL server to SBS server, it is recommended to customize the service account for SQL Server service and other related services rather than using Local System or System account. Moreover, there are two different screens where it asks for credentials. The first is to authenticate you to the server. This account should be a domain account that has local admin privileges on the database server. The second screen is where it asks for the service information. Usually, we would use domain accounts with local admin privileges here for the service account. Let me know if that works. Thanks, Eileen
June 19th, 2011 12:05pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics