All replies

• 

  

  0

  Sign in to vote

  From your URL it seems that both reporting services and CRM are on the same website. Is that correct? Check for the right location of reporting services e.g http://localhost:80/reportserver.

  ---

  Blog: http://mscrm4ever.blogspot.com/ * Website: http://gicrm.upsite.co.il/

  Friday, May 8, 2009 6:19 PM
• 

  

  0

  Sign in to vote

  Hello Adi,
  
  yes im trying to install crm on the report server.
  I have created the ReportServer virtual directory under the website with 5555 port number. Weird that its not visible when i open inetmgr (iis7) . I have created the virtual directory using script and it didnt throw any error.here is the script...
  
  '***************************************************
  'Creating Virtual Directory ReportServer
  '***************************************************

  Set objInParam = objShare.Methods_("SetVirtualDirectory").inParameters.SpawnInstance_()

  
  objInParam.Properties_.Item("Application") =  "ReportServerWebService"
  objInParam.Properties_.Item("Lcid") =1033
  objInParam.Properties_.Item("VirtualDirectory") =  "ReportServer"

  Set objOutParams = objWMIService.ExecMethod("MSReportServer_ConfigurationSetting.InstanceName='MSSQLSERVER'", "SetVirtualDirectory", objInParam)

  WriteLog " Creating the virtual directory for with the name 'ReportServer' ....."

  If HRESULT <>0 Then
  WriteLog  "ERROR in creating Report Server Web Service Virtual Directory ReportServer"
  Else
  WriteLog  "Vitrual Directory has been created successfully ReportServer"
  End if

  Set objInparam=Nothing
  Set objoutparams=Nothing

  
  '***************************************************
  'Creating Virtual Directory ReportManager
  '***************************************************

  Set objInParam = objShare.Methods_("SetVirtualDirectory").inParameters.SpawnInstance_()

  objInParam.Properties_.Item("Application") =  "ReportManager"
  objInParam.Properties_.Item("Lcid") =  1033
  objInParam.Properties_.Item("VirtualDirectory") =  "Reports"

  Set objOutParams = objWMIService.ExecMethod("MSReportServer_ConfigurationSetting.InstanceName='MSSQLSERVER'", "SetVirtualDirectory", objInParam)

  WriteLog " Creating the virtual directory for with the name 'Reports' ....."

  If HRESULT <>0 Then
  WriteLog  "ERROR in creating Report Manager Virtual Directory : Reports"
  Else
  WriteLog  "Vitrual Directory has been created successfully : Reports"
  End if

  Set objInparam=Nothing
  Set objoutparams=Nothing
  
  **************************************************
  
  this is the error when im opening the report server url http://myserver:5555/reportserver

  Reporting Services Error

  ---

  • The configuration parameter SharePointIntegrated is set to True but Share Point Object Model cannot be loaded. The error was: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified. File name: 'Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' at Microsoft.ReportingServices.SharePoint.Server.SharePointServiceHelper..ctor() WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog]. --- End of inner exception stack trace --- at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck) at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache) at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache) at System.Activator.CreateInstance(Type type, Boolean nonPublic) at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) at Microsoft.ReportingServices.Diagnostics.Globals.<>c__DisplayClassf.<CreateInstance>b__e() at Microsoft.ReportingServices.Diagnostics.RevertImpersonationContext.<>c__DisplayClass1.<Run>b__0(Object state) at System.Security.SecurityContext.runTryCode(Object userData) at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData) at System.Security.SecurityContext.Run(SecurityContext securityContext, ContextCallback callback, Object state) at Microsoft.ReportingServices.Diagnostics.RevertImpersonationContext.Run(ContextBody callback) at Microsoft.ReportingServices.Diagnostics.Globals.CreateInstance(String assemblyName, String typeName) at Microsoft.ReportingServices.Diagnostics.Globals.get_SharePointServicingObject(). (rsSharePointObjectModelNotInstalled)

  
  Thanks,
  Nav

  • Marked as answer by NavSQL Monday, May 11, 2009 11:23 AM

  Monday, May 11, 2009 5:23 AM
• 

  

  0

  Sign in to vote

  Hi
     It seems that you have SRS configured to use SharePoint. Have you installed SharePoint on same server as SRS 2008? Here are requirements that you must pass http://msdn.microsoft.com/en-us/library/bb283190.aspx .

  ---

  everything is a matter of probability...

  Monday, May 11, 2009 7:48 AM
• 

  

  0

  Sign in to vote

  Hi Pen,
  
   I had to create my report server database in sharepoint mode as i couldnt get my report server initialized when the database is in native mode.
  
  I dont need any sharepoint services as such in my test environment .Since SRS is configures in sharepoint mode and  CRM4 is throwing this error, I will try to give it another shot by creatig the DB in native mode and then initialize the server.
  
  Thanks,
  nav

  Monday, May 11, 2009 10:58 AM
• 

  

  0

  Sign in to vote

  its resolved now. Had to reinstall and configure RS again. Thanks, Nav

  Monday, May 11, 2009 11:23 AM
• 

  

  0

  Sign in to vote

  Could you tell me the steps as to what you did? I am getting the same error.
  

  • Proposed as answer by JoeyFreyre Thursday, February 18, 2010 9:26 AM

  Thursday, September 10, 2009 9:08 PM
• 

  

  0

  Sign in to vote

  Don't know if you're still looking for and answer to this BUT here goes...
  
  sounds like when you installed SQL Srv 2008 you chose to deploy the reporting server instance and chose it to use a "Share-point Integrated" database type.... but since you probably don't have any share-point technologies installed on your Sql box voila... dumb error.. instead of blowing anything out like the gentleman that had the issue originally did all you have to do is reconfigure Sql Srv RS to use a "native" database instead of the Share-point integrated one that was chosen... no biggie... here' is how:
  
  1)Go to start\all programs\sql 2008\configuration tools\Reporting Server configuration Tool
  2) You'll get a prompt to connect and all that good stuff... obviously make sure you are connected to the correct SQL box if you are running the tool remotely....
  3) Once the tool comes up on the left will be a bunch of options.. choose"database"
  4) on the right you'll see all the current config information... what database the RS instance is using , bla bla..
  5) click on the "Change Database" button...
  6) Follow the wizard (make sure when it asks you what type of DB to create you select "Native" not "Share-point integrated" LOL)
  7) let it run... and viola!
  
  Now if you are really picky about your SQL box you'll wanna go back and clean out that old DB that will just sit there if you dont... now whats interesting is im not really sure if having the RS instance running on the SQL box itself is a best a practive or not.. i'll have to defer to the experts on that one... im thinking that i would wanna install the Reporting server instance on whatever the reporting server is running for.. what do I mean?
  
  okay lets say you wanna use reporting server for your sharepoint enviorment... well dont put RS on the sql box cause you'll have to install Share-point components on the sql box which more than likely isn't just there for share-point...its probably serving out DB's to half you're apps right? So just use the sql box for the actual Database Engine services... grab one of you share-point Portal servers or some other box and through RS on it... then just point it to the SQL box and have it create its database on it... remember one instance of RS can only use one database... so its sort of a per app thing... it you have CRM for instance installed well it to uses Reporting services.... but you sure as heck wouldn't want it using the same RS instance and your share-point stuff.. so you would typically install RS somewhere else(at least i would I'm not even sure if that's correct but just me talking here) and then point it to the SQL box for the Database services... so all my DB's are living on my sql box as they should.. im okay with that.. i don't mind a bunch of RS instances all over the place... but i do mind a bunch of SQL instances all over the place.. and of course i don't wanna install anything unnecessary on my SQL box... make sense?

  ---

  JoeyFreyre

  Thursday, February 18, 2010 9:44 AM