Login   Register 
Receive news via our XML/RSS feed
Home | Book | Contents | Preview | Articles | Tools | Newsletters | Premium | Ask | About

Home

Book

Contents

Preview

Articles

Tools

Newsletters

Premium

Ask

About

Most Popular Articles
  • Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
    Creating an SSL Certificate to ensure your confidential reports remain confidential


  •  
    Boost Data Ltd.
     
     
    SQL Reporting Services - Answers to your questions
     
    Author Thread: Report Service Web service has not generated a public key
    disgoseek

    Report Service Web service has not generated a public key
    Posted: Tuesday, June 01, 2004 4:00 PM (GST)

    Hi,

     

    I've been trying to install Reporting Services for some time now with no success.  My organization is considering moving from Crystal to RS so they asked me to install an evaluation version to try out.  I'm trying to install the eval version of RS on a Windows 2003 server with the eval version of SQL Server 2000 and eval version of VS .net.  Both SQL Server and VS seemed to have installed properly but when I try to install RS the last screen of the installation gives me the error "Setup could not initialize the report server..."

    I tried activating the report server through the command prompt by using "rsactive -c<path> -t" but it just gave me the error "Report Server Web service has not generated a public key".  When I try to go to http://<server>/reportserver I receive a 404 page cannot be found.  I am not using SSL.

    At this point I'm pretty desperate to get it to work.  Any help would be greatly appreciated.

     

    - Raymond

     

    Comments:  

    Author Thread:
    geoffcollishaw
    Report Service Web service has not generated a public key
    Posted: Friday, June 11, 2004 12:12 AM (GST)

    Raymond

     

    I've had this problem because the Reporting Services Manager wouldn't fire at all.

     

    The issue on my machine was caused by having both the .Net Framework 1.0 and 1.1 on the machine.  To overcome this I ran the following batch file:

     

    c> "%windir%\Microsoft.NET\Framework\v1.0.375\aspnet_regiis.exe" -i
    regsvr32 %windir%\Microsoft.NET\Framework\v1.0.3705\aspnet_isapi.dll

    I trust this helps you.

     

    Regards

     

    Geoff Collishaw

    Melbourne Australia

    RSBCTrumpet
    Report Service Web service has not generated a public key
    Posted: Saturday, July 10, 2004 7:09 PM (GST)

    Did you ever get this to work?

    I'm getting the same error.

    ~bg

    Roy
    Report Service Web service has not generated a public key
    Posted: Monday, July 12, 2004 1:47 PM (GST)

    Raymond,

    This is not an answer but, a question.

    My company is seriously considering going to Crystal Reports. I have expressed concern and presented valid reasons not to go to Crystal.

    Would you mind sharing the reasoning why your company is leaving Crystal? I might could use your reasoning to prevent us from going to Crystal.

    Thanks,

    Roy

     

    nandini15
    Report Service Web service has not generated a public key
    Posted: Tuesday, July 20, 2004 5:19 PM (GST)

    I am having exactly the same problem. I tried to fix it by executing the rskeymgmt utility and set the public key for the Report Server, but then after that when i try rsactivate utility, I get the same error.

    I am pretty frustrated with this and I am pretty desperate to get this working ASAP.  

    Somebody please help!!!!!

     

    -Nandini

    surfdork
    Report Service Web service has not generated a public key
    Posted: Wednesday, July 21, 2004 12:03 AM (GST)

    I am having the same problem as well and have not found a solution.

     

    I've uninstalled SQL and RS, reinstalled, still get the problem.

     

    geoffcollishaw
    Report Service Web service has not generated a public key
    Posted: Wednesday, July 21, 2004 12:08 AM (GST)

    I attempted to install onto a live server (after successful installs on test boxes) and had hell with it.

    The same 404 error as everyone else is mentioning.

     

    My manager solved it.  We needed Distributed Transaction Co-ordinator running (not that I've seen that anywhere in the setup documentation).

     

    Hope it helps.

    Peter
    Report Service Web service has not generated a public key
    Posted: Wednesday, July 21, 2004 7:33 AM (GST)

     In the RSSetup.CHM help file - DTC is listed under "Software Requirements for Reporting Services"  ... as a "General Prerequisites"   - but you have to go digging for it...

     

    Peter

    nandini15
    Report Service Web service has not generated a public key
    Posted: Wednesday, July 21, 2004 2:20 PM (GST)

    It works now. There were some internal domain and security issues that was causing he problem. I installed Reporting Service again on a different machine and it works beautifully!

     

    I would suggest installing it on a machine, which is within your domain and to uncheck SSL security during setup. Thats what i did and it worked!!

     

    Hope this helps.

     

    -Nandini

    Peter
    Report Service Web service has not generated a public key
    Posted: Wednesday, July 21, 2004 2:23 PM (GST)

    The only probelm with unchecking SSL - is that it is possible to compromise a Report Server that is installed without SSL and compromise the domain to which it belongs.  Its a real bad idea not to have SSL ... like real bad.

     

    Peter

    surfdork
    Report Service Web service has not generated a public key
    Posted: Thursday, July 22, 2004 1:30 AM (GST)

    Still need help

     

    I still get the  "The report server web service has not generated a public key. The service may nothave started successfully. Check the log filed for more information"

     

    OK, what to do?

    Peter
    Report Service Web service has not generated a public key
    Posted: Thursday, July 22, 2004 10:12 AM (GST)

    What does the installation log file say?

     

    Peter

    Hans
    Report Service Web service has not generated a public key
    Posted: Thursday, July 22, 2004 12:26 PM (GST)

    Hi, I've been watching you guys with interest. You guesed it, I seem to have the same problem. After installation of reporting services the thing tells me to fire her up manually. I've tried all the command line goodies (Starts to look like Oracle) and nothing worked. I get the next lines in my log file :

     

    aspnet_wp!crypto!660!7/22/2004-12:01:28:: i INFO: Initializing crypto as user: SCHADEASO02\ASPNET

    aspnet_wp!crypto!660!7/22/2004-12:01:28:: i INFO: Exporting public key

    aspnet_wp!library!660!7/22/2004-12:01:28:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Error getting running jobs;

    Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.IO.FileNotFoundException: The system cannot find the file specified.

     

    Is there nobody out there the has the answer to this ???

    I met all the requirements and I'm installing sql server and reporting services and .NET on the same machine, just to try it out.

    Hans
    Report Service Web service has not generated a public key
    Posted: Thursday, July 22, 2004 1:33 PM (GST)

    DIY

     

    I've got it, though not sure why.

     

    What I did was :

     

    Install sp1

     

    rskeymgmt -d (Which resets iis also, it didn't before sp1)

     

    rsactivate -c"D:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config" (I installed on D:\)

     

    No error nothing, happy happy joy joy !!

     

    Finally after two days I can have a look at what it does.

     

     

     

     

    surfdork
    Report Service Web service has not generated a public key
    Posted: Thursday, July 22, 2004 7:23 PM (GST)

    Hans,

     

    Tried your steps, still get the "the report server web service has not generated a public key"

     

    Regarding install logs, where are they?

     

    Getting VERY frustrated am about to call MSDN tech support.  I'll post the solution once I get it.

    surfdork
    Report Service Web service has not generated a public key
    Posted: Thursday, July 22, 2004 7:39 PM (GST)

    Tried the following:

    If your report server uses SSL, you need to put the full domain name of the  
      server in the report project's TargetServerURL property

     

    Bounced service, STILL getting the web svc not generating public key msg.

    surfdork
    Report Service Web service has not generated a public key
    Posted: Thursday, July 22, 2004 8:31 PM (GST)

    FIXED:

     

    What was wrong?

     

    The root of the problem was that I was pointing to the wrong DNS server in my isolated test enviornment.

     

    The root cause of almost all AD problems is DNS.  AD/DNS and cert services are tightly wound.

     

    The DNS failure in not readily evident inthat you are able to logon to the member server.

     

    I checed the event viewer and voila I fount the usernv error could not determine computer name.

     

    So I disjoined and rejoined the server, which was successful.

     

    However in reality it was not successful.  I knew next to check the DNS server address in TCPIP properties.

     

    Sure enough I was pointed to the wrong server.

     

    This is a Windows server gotch in that the reason for the failure is not obvious.

     

    You are able to login, join and disjoin the domain.

     

    However all along the member server is not able to have it's name determined by the DC.

     

    Thanks for all of the tips folks.

    jgraffio
    Report Service Web service has not generated a public key
    Posted: Friday, August 20, 2004 3:45 AM (GST)
    I've tried every suggestion in this forum and still nothing has worked. I'm running SBS 2000 with sp4 and SRS with sp1. I give up. I have to go back to Crystal Reports.
    angelo34jj
    Report Service Web service has not generated a public key
    Posted: Wednesday, September 01, 2004 1:07 AM (GST)
    I have solved this problem by giving read and execute permissions to Everyone for global.asax file in both Reports and ReportServer folder and then execute rsactivate. try this....
    smgarner
    Report Service Web service has not generated a public key
    Posted: Wednesday, September 01, 2004 10:10 PM (GST)

    We experienced the same problem.  Thanks to the various posts to this and other sites, we were able to activate RS as follows:

     

    Steps taken to get Reporting Services activated when doing a split install between an IIS and an SQL box - both running Windows Server 2000 Service Pack 4:

    1. On the SQL box: Make sure there is no instance of the REPORTSERVER and the REPORTSERVERTEMPDB databases.

    2. On the IIS box:

    a. Change the Default web site to other than port 80 - I used 90.

    b. IWAM_<servername> must have IMPERSONATE privileges.

    c. Deinstall Framework.Net version 1.0x if installed. (NOTE: You must have Framework.Net version 1.1x installed.)

    d. From the <windows directory>\Microsoft.Net\Framework\v1.1.xxxx (x being whatever version you have installed - ours is 4322) run aspnet_rediss -c

    e. Reboot

    f. From \Program Files\Microsoft SQL Server\80\Tools\Binn run: RSActivate -c "f:\RS\MSSQL\Reporting Services\ReportServer\RSReportServer.config"

    (NOTE: Substitute your installation path in lieu of "f:\RS…\ReportServer\")

    This resulted in a successful activation.

    smgarner
    Report Service Web service has not generated a public key
    Posted: Sunday, September 05, 2004 6:42 AM (GST)

    Typo correction - my appologies:

     

    d. ...  aspnet_rediss -c should be aspnet_regiss -c ...

    jes
    Report Service Web service has not generated a public key
    Posted: Friday, September 10, 2004 3:17 PM (GST)

    I have tried everything in this chain of suggestions and still can't get this public key generated. The error log says this:

     

    System.IO.FileNotFoundException: The system cannot find the file specified.

     

    Among other things..

     

    Does anyone have any more ideas ?

     

    Thanks in advance.

    Peter
    Report Service Web service has not generated a public key
    Posted: Friday, September 10, 2004 9:04 PM (GST)

    Hi Jes,

    Is there anymore detail from the installation log on which file has not been found?
    btw: are you looking at the installation logs or the service logs? The installation logs are located in the cab file in "\Program Files\Microsoft SQL Server\80\RS Setup Bootstrap\Log."  

    Peter

    jagzuk
    Report Service Web service has not generated a public key
    Posted: Wednesday, September 15, 2004 4:48 PM (GST)
    Do you have Sharepoint Team Services on the same server?
    jsteward
    Report Service Web service has not generated a public key
    Posted: Tuesday, October 19, 2004 11:45 PM (GST)

    Check the application pool that Report Server is using and make sure the user context the application pool is running under has appropriate permissions to the ReportServer and ReportManager directories.

     

    I ran into this after installing Sharepoint Team services on the same server - there are other settings you will have to change to get that to work as well.

     

    -Jeff

    andre
    Report Service Web service has not generated a public key
    Posted: Monday, October 25, 2004 10:56 PM (GST)

    I was struggling with this for a while. None of the above worked for me.

    Solution was to add the ASP.NET Machine Account to the local administrators group on the local machine.
    This allowed the webservice to create a tree structure under
    C:\Documents and Settings\<machine name>
    which is where the file not found error came from.

    After adding to local administrators use:
    rskeymgmt -d (Which resets iis also, it didn't before sp1)
    and
    rsactivate -c"D:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config" (I installed on D:\)

     

    Hope this helps.

     

    Andre

    blaflin
    Report Service Web service has not generated a public key
    Posted: Tuesday, November 02, 2004 3:30 PM (GST)
    I had the same problem. It turned out the problem was because the machine I was installing on was also a domain controller. There are procedures for installing on a domain controller in the Reporting Services Books Online in the "Preparing To Install" section. I followed the procedure and it worked like a champ.
    Peter
    Report Service Web service has not generated a public key
    Posted: Wednesday, November 03, 2004 1:43 AM (GST)
    Yes, the steps you need to take on a Domain Controller are outlined on page 42 of the book and also in KB824308 and KB265357

    Peter
    stan4th
    Report Service Web service has not generated a public key
    Posted: Friday, November 05, 2004 2:37 PM (GST)
    I'm sure I reas you can install on an IIS box which doesn't have SQL installed and refer to a separate SQL box to hold the databases - but I cannot get RS to start - same error message as above. Is this the case?
    stan4th
    Report Service Web service has not generated a public key
    Posted: Friday, November 05, 2004 3:32 PM (GST)

    The event log reports:

    1. Report Server

    Report Server has not been granted access to the catalog content.

    2. Report Manager

    Report Manager cannot connect to the Report Server Service.

     

    Does this mean anything to anyone?

    Peter
    Report Service Web service has not generated a public key
    Posted: Sunday, November 07, 2004 1:12 AM (GST)
    Hello John,

    Ok which account have you configured the report server to access the database with? This will need to be a domain account, and you will need to make that account a member of the RSEXEC role in the ReportServer database and the ReportServerTembDB database too.  To reconfigure the domain account and connection string that is used by the Report Server to talk to the database you use rsconfig.exe. 

    Did you follow the setup directions in Chapter 2?  The DVD should also help show you the necessary checks to run on the SQL Server.

    Peter
    stan4th
    Report Service Web service has not generated a public key
    Posted: Monday, November 08, 2004 12:27 PM (GST)
    I've noticed that it's created the Reports and ReportServer vitual dirs under another site which isn't the default one for that server, despite choosing the default. This has a separate IP assigned as well.
    kwong
    Report Service Web service has not generated a public key
    Posted: Monday, November 15, 2004 11:27 PM (GST)

    I'm getting the "Report Service Web Service has not generated a public key" error still after trying (I think) all of the above.

    I've also tried a few ideas mentioned on other sites such as disabling terminal services and reinstalling, reinstalling SQL Server Developer Edition (yikes).


    I'm on XP Pro, trying to install the developer edition of SQL Reporting Services.

     

    Also, I noticed that running rsactivate by itself doesn't generate any log entries detailing what went wrong in C:\Program Files\Microsoft SQL Server\80\RS Setup Bootstrap\Log, but you guys seem to have more info than I do. Am I looking at the right log ?

     

    I don't suppose MS has posted an updated installer for SQL Reporting Services on microsoft.com ? Or a fix utility ?

     

    kwong
    Report Service Web service has not generated a public key
    Posted: Tuesday, November 16, 2004 1:14 AM (GST)
    Problems solved. Disabled the McAffee Desktop Firewall Service and reinstalled.
    renuka_atul
    Report Service Web service has not generated a public key
    Posted: Friday, December 10, 2004 8:09 PM (GST)
    Andre's post helped me. I aaded the ASPNET account to local administrator and it voila !! it worked. Thanks Andre for taking the trouble to post your resolution.
    jacklaasen
    Report Service Web service has not generated a public key
    Posted: Thursday, January 27, 2005 11:49 PM (GST)

    Hi,

     

    I get simular error:

     

    aspnet_wp!crypto!860!01/27/2005-17:09:26:: i INFO: Exporting public key
    aspnet_wp!webserver!860!01/27/2005-17:09:26:: e ERROR: Internal error: System.Runtime.InteropServices.COMException (0x8009000B):
    Key not valid for use in specified state.
    at RSManagedCrypto.RSCrypto.ExportPublicKey()
       at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
       at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()

     

    Summary of setup:

    - report server database is on different machine.

    - using SSL

    - using a security extention to enable form authentication.

     

    This setup worked for weeks. Not sure if the network dude did something to break it. I tried all the suggestions I could find on the net.

     

    Any help appreciated, will post any progress on my end.

     

    O its so nice to be back in the microsoft world, unix was too predictable.

     

     - Johannes

     

     

    stefanp
    Report Service Web service has not generated a public key
    Posted: Friday, January 28, 2005 4:44 PM (GST)

    Hi,

     

    In my case, the "Key not valid for use in specified state." problem seemed to be linked with the installation of the .NET Framework 1.1 SP1 Hotfix KB867460 i.e. everything was working fine until after I installed the hotfix. I contacted Microsoft support and here's what happened....

     

    After running the rsactivate and rskeymgmt utilities to no avail, I ended up just uninstalling and reinstalling. Note, I had tried uninstalling and reinstalling Reporting Services before and I still got the same "Key not valid for use in specified state" error. The difference this time, was that before reinstalling, I went into administrative tools -> then Component Services. Expand Component Services -> Computers -> My Computer -> COM+ Applications. Right click on IIS--{Default Web Site//Root/ReportServer} and choose properties, and then the advanced tab. Uncheck the "Disable deletion" check box. Click OK. Now, you can right click on IIS--{...ReportServer} and delete. You should also do this for IIS--{...Reports} too. Next, go to "C:\Documents and Settings\<machine_name>\ASPNET\Application Data\Microsoft\Crypto\RSA Then underneath a directory titled something like this "\S-1-5-21-823518204-436374069-854245398-1006" look for the system file that begins with this "1aedd7b5699f3d6a8..." and delete that file. Now you should be able to reinstall RS (make sure you've gotten rid of the "old" "ReportServer" and the "ResportServerTempDB" databases). I just had to re-deploy the reports, and was good to go.  Please note that I'm not sure of all of the ramifications of deleting the system file...maybe someone more knowledgable can comment?  Hope this helps.

    jacklaasen
    Report Service Web service has not generated a public key
    Posted: Friday, January 28, 2005 6:03 PM (GST)

    Thanks Stefan.

     

    I tried all sorts of things till am hours last night.. Uninstalled everything, moved reporting service database to the same machine as reporting services, rsconfig, rskeymgmt,rsactivate .....no luck.

     

    What made the pain go away was the  following:
    Im running on a windows 2003 and IIS6. IIS was running on "Run WWW service in IIS 5.0 isolation mode" After I unselected this option and made sure that the application pool run under "Network Service" identity ..no more pain..not 100% sure why though.

     

    Here is how I did it:

    - In IIS, right click on web sites , on web sites properties dialog  select the service tab.

    - Un-check the "run WW Service in IIS5.0 isolation mode" option, click ok.

    - Expand Application Pools in iis and right click on DefaultAppPool, select properties

    -click on identity tab and select Network Service as identity.

     

    Also see:

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_0ijm.asp

     

    flatsheep
    Report Service Web service has not generated a public key
    Posted: Thursday, March 24, 2005 10:56 PM (GST)

    Hi,

     

    This posting was very informative to get my mind into the sort of problems that were going on with my reporting services.

     

    I'm running Reporting Services Developer using SQL Server 2000 Developer on an XP Prof SP2 box.

     

    After installing Reporting Services (RS) it failed to activate during the installation.  When I tried to activate a failure would occur.  Visual Studio.NET would fire up the "Just-In-Time" debugger with the exception System.ExecutionEngineException.

     

    To cut a long story short:  I tracked it down to a bug in .NET 1.1 framework. But Microsoft are "aware" of the problem and will be releasing a fix in the yet to come .NET 1.1 SP1 role out.  Fortunately my company has a universal licence with MS, so I downloaded the latest .NET 1.1 SP1 from the msdn subscribers website.  Loaded it on; ran the activation, and like magic it worked.  All is sweet with the server.  The services work, the reports are generating.

     

    Hope this can help someone save the day I've had scratching my head!

     

    DF

    constantine
    Report Service Web service has not generated a public key
    Posted: Monday, March 28, 2005 3:00 PM (GST)
    I wish i could exorcise the deamons of this error!! I am on a XP pro, .NET 1.1 the Installation fails to intialize the reportserver I am using a remote SQL DB Manual Initialization.... 1. rskeymgmt -d 2. rsconfig.exe -c -s blrkec21227 -d ReportServer -a Windows -u "domain\username" -p "######" 3. C:\>rsactivate -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Service s\ReportServer\RSReportServer.config" Failure starting the web service: The Report Server Web service has not generated a public key. The service may n ot have started successfully. Check the log files for more information. LogFile: aspnet_wp!crypto!f3c!03/28/2005-18:57:06:: i INFO: Initializing crypto as user: BLRKECAPAC06\ASPNET aspnet_wp!crypto!f3c!03/28/2005-18:57:06:: i INFO: Exporting public key aspnet_wp!webserver!f3c!03/28/2005-18:57:06:: e ERROR: Internal error: System.IO.FileNotFoundException: The system cannot find the file specified. at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32 errorCode, IntPtr errorInfo) at RSManagedCrypto.RSCrypto.ExportPublicKey() The user accounts have enough priviledges........ I have followed following steps suggested by microsoft support 1. Make sure you are logged as one member of local administrator 2. Start -> Run-> "regedit.exe" 3. Go into HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application 4. Giving FULL permissions to IWAM, IUSR, and ASPNET accounts on the following key, and then reinstalling SQL Reporting Services(Right click the Event, Select Permissions) 5. Restart the Server and try to reinstall SQL Server 2000 Reporting Services
    constantine
    Report Service Web service has not generated a public key
    Posted: Thursday, March 31, 2005 9:44 AM (GST)

    Problem was fixed.

     

    I was tryin 2 install report server on a remote SQL server.

    This does not work

     

    So when i shifted to a machine with a local SQL server n istalled the REPORTSERVER here.

    now for a remote machine i used a Web-Farm setup n installed only the client components.

    The services r cool!!

    Actually I was under the impression that REPORTSERVER could be installed on a remote SQL server

     

    (P.S. my previous post was all messed up, coz this page works weird with netscape!!)

    stan4th
    Report Service Web service has not generated a public key
    Posted: Thursday, March 31, 2005 12:51 PM (GST)

    Hi,

    how can I detect whether one of our servers has SP1 on it?

    Thanks.

    Peter
    Report Service Web service has not generated a public key
    Posted: Thursday, March 31, 2005 1:02 PM (GST)
    The RTM version is 8.00.0743.00   so if you have a version beyond that you have a service pack installed.  See Here
    ConnieP
    Report Service Web service has not generated a public key
    Posted: Tuesday, April 12, 2005 5:10 PM (GST)

    Hi Peter and John,

     

    We have the same kind of issue happening here.

     

    Error on page stating "The report server installation is not initialized. Check the documentation for more information. (rsReportServerNotActivated)"

     

    And event log entry of: "Report Server has not been granted access to the catalog content"

     

    We've had our DBA's make the account member changes listed in the last post from Peter.  And then rsconfig -c -s(sqlservername) -dReportSErver -u(userid) -p(password) -t

     

    However we do not have the DVD.....is there somewhere else we can find some checks to run on the SQL server?

     

    And would you by chance have any other ideas for us to try?  This is our DEV box, and we had to wipe it and reinstall.  Production is working fine and we've double checked with Windiff to make sure the files are the same, changing various information to point to DEV vs Production databases, etc.

     

    Thanks so much for this thread .... it's been very useful to us so far.

     

    -- Connie

    ConnieP
    Report Service Web service has not generated a public key
    Posted: Tuesday, April 12, 2005 6:51 PM (GST)

    Hello,

     

    More information that might help in anyone providing us an assist:

     

    We manually deleted the keys in SQL server and....

    1)   Started NT Service - Report Services
    This created a row with Client =1 and symmetrickey information as well as publickey information.

     

    2)  Browsed over to localhost report server

    This created a row with Client =0 and no symmetrickey information - it says NULL instead.  Public key infor is listed ok.

     

    Why won't / how can we get the right symmetrickey to get created?

     

    Thanks,

     

    Connie

    Mannie
    Report Service Web service has not generated a public key
    Posted: Friday, April 22, 2005 6:44 PM (GST)

    If this is still an issue for any one see the following article:

     

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconhostingremoteobjectsininternetinformationservicesiis.asp

     

    It basically says in

    C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Config\machine.config

    Change

    <servicePointManager checkCertificateName="true" checkCertificateRevocationList="false" />

    to

    <servicePointManager checkCertificateName="false"
    checkCertificateRevocationList="false" />

    I've tested this on a local environment here and

    spectrablue
    Report Service Web service has not generated a public key
    Posted: Thursday, June 02, 2005 7:23 PM (GST)
    Perhaps the easiest way to deal with the "Setup could not initialize the report server.." error is to add the Network Service account to local administrator after removing everything for a fresh install. Probably a good idea to take back the local admin rights to network service after patching up to SP2. MSFT should figure out why we have to give Network Service local admin for setup to work and either add this to documentation or fix it so you don't need to do this drastic security step to make it work. Thanks. Good Luck.
    MatthewMartin
    Report Service Web service has not generated a public key
    Posted: Monday, June 13, 2005 11:18 PM (GST)
    I have slight twist at http://<server>/reportserver I get internal error, path not found. Reinstall: doesn't work. Granting admin rights to ASPNET account: doesn't work. Aspnet_regiis: doesn't work. Check for .Net 1.1 SP1: already have it Rsactivate: over & over, doesn't work ("Report Server Web service has not generated a public key") Granting rights to global.asax: doesn't work I can't recommend my organization to use this product, it is uninstallable.
    real1
    Report Service Web service has not generated a public key
    Posted: Tuesday, June 14, 2005 10:39 PM (GST)

    hi jeff.

     

    i have sharepoint running on same machine as reporting services. can u tel me exact steps that you did to make it work. i,d really appreciate

     

    thanks

    ali

    spectrablue
    Report Service Web service has not generated a public key
    Posted: Thursday, June 16, 2005 3:20 PM (GST)

    Matthew are you on IIS6?

    If so try granting Network Service (instead of ASPNET account) to the local admin group during the install. IIS 6 likes Network Service NOT ASPNET.

    Good luck.

    tniles
    Report Service Web service has not generated a public key
    Posted: Tuesday, August 09, 2005 2:06 AM (GST)
    I have been working on this same problem with a newly configured server for three days. The change with the certificatename attribute change finally solved the problem. THANK YOU SOOOOOOOO MUCH!!!!!
    yuvageetha
    Report Service Web service has not generated a public key
    Posted: Tuesday, November 15, 2005 8:18 AM (GST)

    I tried the above steps while executing RsActivate-c i got the following error:

    Failure Starting the webservices:

    Local NT service is not activated 0x800a0bcd

     

    Frank2005
    Report Service Web service has not generated a public key
    Posted: Thursday, November 24, 2005 8:16 PM (GST)

    Trying to install Report Server on Win2k3 with SQL Database on another Win2k3. Get "Setup could not initialize the report server. You must manually..." error on install.  Installed sp1, have tried all previous suggestions in previous postings & after rskeymgmt, rsconfig & rsactivate get error in log "INFO: Exporting public key w3wp!webserver!e84!11/24/2005-17:30:09:: e ERROR: Internal error: System.IO.FileNotFoundException: The system cannot find the file specified."

    Any ideas greatly appreciated...

    jack2000
    Report Service Web service has not generated a public key
    Posted: Monday, December 12, 2005 1:59 AM (GST)

    I have installed numerous(at least 10) SQL RS installs and this is the first time with this error.  After following all the suggestions from above the error <no generated public key> still occurs.

     

    I was given a laptop (XP with SP2) becos the Sys admins had no luck going.  I was given a domain account to log in with.   The laptop was connected to the domain to setup the computername and standard office suite. 

     

    For all the SQL applications the laptop was taken off the network but still using the domain account as the profile is loaded. 

    I un-installed, rebooted and re-installed RS.   As expected I too got the same error.  Took a whole day reinstalling, rebooting and rechecking the installation.  Error did not go away. 

     

    I then created a local PC account.  Uninstalled RS, rebooted and logged in with new local account.  Installed RS with no errors and worked first time.  I then decided to uninstall RS, reboot, connected PC to the domain and logged in with domain account.  Installed RS and as expected it worked!

     

    In short - when installing using a domain account, make sure you connected to the domain.  If not connected then use a local account.

     

     

     

     

     

    mvee
    Report Service Web service has not generated a public key
    Posted: Friday, December 30, 2005 10:16 PM (GST)

    Just wanted to say thanks for all the posts! Obviously, there isn't just one thing causing this error.

     

    I upgraded to RS SP2.

    Then ran:

    rskeymgmt -d
    rsactivate -c"C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config"

     

    Batta Bing.

    Finally.

    Thanks for the help.

     

    Lina79
    Report Service Web service has not generated a public key
    Posted: Saturday, December 31, 2005 10:27 AM (GST)

    I m facing a problem with reporting service..Previously it was working fine..until I installed Apache web server..I disbaled the server & still it's not working..I unistalled the sql server + reporting services & it's not working..I followed these steps

    I upgraded to RS SP2.

    Then ran:

    rskeymgmt -d
    rsactivate -c"C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config"

    & get an error when trying to run rsactivate: Error: Failure starting the web service:

    the report server web service has not generated a public key..the service may not have started successfully. check the log files for more information..

    What shall I do..I tried each and every step mentioned here..& nothing is working..

    Lina

     

    chennairaj
    Report Service Web service has not generated a public key
    Posted: Monday, February 13, 2006 3:02 PM (GST)

    I m facing a problem with reporting service as above. In another system which has the same domain, i have no issues. But in my system it shows "report server web service has not generated a public key" error.

     

    OS - Windows XP SP2

    SQL Server - 2k SP3

    RS - SP2

     

    Am i missing anything?

     

    Raj

     

    chennairaj
    Report Service Web service has not generated a public key
    Posted: Wednesday, February 15, 2006 10:16 AM (GST)

    My Solution :

     

    Edit in the file "machine.config" of the .NET framework the attribute "userName" of the element "processModel" to "System". At any point of time you can change the "userName" followed by rskeymgmt -d and rsActivate commands.

    in machine.config

    <processModel enable="true" timeout="Infinite" idleTimeout="Infinite" shutdownTimeout="0:00:05" requestLimit="Infinite" requestQueueLimit="5000" restartQueueLimit="10" memoryLimit="60" webGarden="false" cpuMask="0xffffffff" userName="System" password="AutoGenerate" logLevel="Errors" clientConnectedCheck="0:00:05" comAuthenticationLevel="Connect" comImpersonationLevel="Impersonate" responseDeadlockInterval="00:03:00" maxWorkerThreads="20" maxIoThreads="20"/>

    c:\>rskeymgmt -d

    c:\>rsactivate -c"D:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config"

    and then try.

    Best of LuCk

    Raj

     

    chennairaj
    Report Service Web service has not generated a public key
    Posted: Wednesday, February 15, 2006 10:25 AM (GST)

    The same applies to W2K SP4. But, before executing rsactivate they have to configure the RS.

     

    c:\>rsconfig -c -m D1053 -sD1053 -dReportServer -aSQL -usa -padmin -t

     

    if not executed above command  it would get "Report Server Web service has not generated a public key" or "The local NT Service is not activated" error. Mention about machine name in -m <Machinename>, else it would generate "System.Management.ManagementException: Provider load failure" error.

     

    1. c:\>rskeymgmt -d

    2. c:\>rsconfig -c -m D1053 -sD1053 -dReportServer -aSQL -usa -padmin -t

    3. c:\>rsactivate -c"D:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config"

     

     

    skip
    Report Service Web service has not generated a public key
    Posted: Tuesday, March 28, 2006 7:29 AM (GST)
    • It still doesn't work for me. Is it because I didn't install VS .NET?
    • I am really frustrated, any help will be greatly appreciated.
    mahendra
    Report Service Web service has not generated a public key
    Posted: Thursday, June 15, 2006 3:03 PM (GST)

    i am using reporting service of sql on

    Configure Report Server page i am unable to set

    web service identity

     

    i am using following software

    SqlServer 2005

    iis 5.0

    OS 2000 server

     

     

    could anybody help me because i am struggling from last two days and unable to handle the problem.

    if there is any solution plz help me.

     

    awaiting for answer

     

    Mahendra Singh

    mahendra
    Report Service Web service has not generated a public key
    Posted: Thursday, June 15, 2006 3:16 PM (GST)

    i am using reporting service of sql on

    Configure Report Server page i am unable to set

    web service identity

     

    i am using following software

    SqlServer 2005

    iis 5.0

    OS 2000 server

     

     

    could anybody help me because i am struggling from last two days and unable to handle the problem.

    if there is any solution plz help me.

     

    awaiting for answer

     

    Mahendra Singh

    mahendra
    Report Service Web service has not generated a public key
    Posted: Friday, June 16, 2006 7:52 AM (GST)

    i am using reporting service of sql

     

     On Configure Report Server page i am unable to set

    web service identity

     

    i am using following software

    SqlServer 2005

    iis 5.0

    OS 2000 server

     

     

    could anybody help me because i am struggling from last two days and unable to handle the problem.

    if there is any solution plz help me.

     

    awaiting for answer

     

    freedom1029
    Report Service Web service has not generated a public key
    Posted: Wednesday, July 19, 2006 9:23 PM (GST)

    if your OS is 2000 server then the Web Identity can not be set.  By default is use the ASPNet.


    Hope this helps,

    Eric

     
     
     
     
     
    Home | Book | Contents | Preview | Articles | Tools | Newsletters | Premium | Ask | About