.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SQL 2008 servers and MOSS 2007 with SSRS

Posted By:      Posted Date: August 26, 2010    Points: 0   Category :SharePoint

I need help figuring out the limitations in a multi-database server environment and MOSS 2007 installation with SSRS.  Here is the run down:

  • I currently have MOSS 2007 server with backend on SQL 2005, which also acts as the SSRS server.  In addition I have another SQL 2005 server where business data resides and against which most of the SSRS reports run.
  • Future plan (over which I don't really have a say) is MOSS 2007 with backend on SQL 2008, which will remain to be the SSRS server.  The second SQL server with business data will be migrated to SQL 2008 R2.

Questions: does this architecture requires SSRS 2008 add-in or SSRS 2008 R2 add-in (integrated mode)?  Will there be an issue of building SSRS 2008 reports that go after SQL 2008 R2 and SQL 2008 data mix?

View Complete Post

More Related Resource Links

SSRS 2008 R2 Reportbuilder 3.0 and MOSS 2007


Hi all After installing integrating SSRS 2008 R2 with Sharepoint 2007 we are trying to implement the click once functionality for Report Builder 3.0 so that clients can download Reportbuilder. However I keep getting the following error: -

The remote server returned an error: (401) Unauthorized.

Reading through various articles most notably: http://msdn.microsoft.com/en-us/library/ms365173(v=SQL.105).aspx and http://msdn.microsoft.com/en-us/library/cc281309.aspx It seems the problem lies in the fact that the computers lie in different domains and the account being passed is that of the local client machine.

I have tried to implement the anonymous access as per the second article but this still fails with the same error, and the article is really only for native mode installs. Does anyone know a way around this when using Sharepoint Integration?

My clients will be accessing from the web so having then in the same domain is not an option and neither is anonymous access for the entire site as it is required that they authenticate.  This used to work with SQL 2005 SSRS and Reportbuilder but not for SQL 2008 R2 it seems.

Thanks for any help

Issue with toolbar when loading the RDL (upgraded to ssrs 2008 R2) via report viewer in MOSS 2007 se

Our front end server is Office SharePoint Server 2007 and the RS is SSRS 2008 R2 (native mode).

The toolbar is different when loading the same RDL (upgraded to SSRS 2008 R2) through report viewer and report manager. In report manager, the toolbar is color blue while when displayed through report viewer the color of the toolbar is light brown/yellow. Color blue indicates it is using the latest version of SSRS while the other color for previos version. Aside from that, the font of several texts in a table has increased to one point when viewed via report viewer compare to when viewed via report manager.  Is there an existing fix for this?

SSRS 2008 R2 and sharepoint 2007 report builder problems


I upgraded our enterprise sql server 2008 to sql server 2008 r2 last weekend.  Along with this i installed the report builder 3.0 on the servers as well and the updated ssrs add in for sharepoint.  The upgrade went fine, no errors that i could find.  The problem is now when i go to a library that has the report builder content type enabled and click report builder report under new it does not load report builder 3.0.

I updated the custom report builder url in central administration from /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application to /_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application

however when i do click the new report builder report it kicks me over to http://company.com/ReportServer_MossEnt  which itemizes out each individual sharepoint site in the farm.

Is the integration of ssrs 2008 r2, sharepoint 2007 and report builder 3.0 work?  did i install the wrong version of the report builder add in?  The above is the only problem i am having now.

all servers are server 2008, 64 bit and moss 2007 enterprise with sp2 & april 2010 cu

VS Studio WorkFlow Failed on Start in MOSS 2007 ON Windows Server 2008 64 Bit


I have created a sequential sharepoint workflow in WSP Builder in my Sharepoint Server and Deployed it.

But the workflows says Failed on start and retrying ans stops there forever says couldn't start the workflow.

I repaired .NET Framework 3.5sp1 installed

 tried this

 1. I tried again, in C Prompt:  Lodctr "c:\Windows\Microsoft.Net\Framework\v3.0\Windows Workflow Foundation\perfcounters.ini"  it says initiation file cannot be found

2   i again tried this C prompt Lodctr /R "c:\Windows\Microsoft.Net\Framework\v3.0\Windows Workflow Foundation\perfcounters.ini"

it says reloaded  from the system restored

i am still getting the same error.

When i manually go to my  C:\Windows\Microsoft.NET\Framework\v3.0\Windows Workflow Foundation i can see a folder for SQL that's it nothing more than that..

I dont know what is happening i am trying it from 2 days and still no solution.

any ideas would be real great help for me.

My system is 64 bit , Window server 2008, MOSS SP2, Visual Studio 2008 Version 9.0.30729.

.Net Framework 3.5 sp1

and WSP builder the one from Codeplex for 64 bit machines

Does MOSS 2007 Support SQL Server 2008 R2 RTM version?

Hi, We have MOSS 2007 SP1 databases in SQL Server 2005 EE x64 with SP3. Now, we want to upgrade the SQL Server 2005 to SQL server 2008 R2 EE x64 RTM version. Does MOSS 2007 Support SQL Server 2008 R2 RTM version? If yes, please take me to the MS link where I can find this information. Thanks

WebPart Deployment in windows 2008 R2 with Moss 2007

Hello, I have build one employee directory webpart that gets necessary information of user from sharepoint site. i have deployed in my testing server "Windows Server 2003 and Moss2007" and it's work fine. When i tried to deploy on my production server "Windows Server 2008 R2 with Moss2007". It give me security error. Request for the permission of type 'Microsoft.SharePoint.Security.SharePointPermission, Microsoft.SharePoint.Security, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c' failed." I have also created security policy file and added reference to web.config. Still i getting same error please help on this. i am stuck here and not able to find any way to get out of this.

SQL Server 2008/MOSS 2007 Reporting Nightmares

I am having issues of the Reporting services kind...I have 2 issues in regards to executing rdl report files (excel reports work fine) when they're read through sharepoint reporting.I'll give you a rundown of the components and layout I'm using first of all. I'm going to put in as much information as I can find, so if you see things that are irrelevant it's just because I want to dump as much as I can incase it tweaks someones brain. FYI I have rebooted the computers and IIS many, many times.Servers:Both of the machines below are VMs on Xenserver. We run on a /23 network for these servers. The domain functional level is Windows 2000 mixed (yeah, I know). Devsp40: devsp40 is a Windows Server 2003 R2 SP2 Enterprise edition x64 server (winver 5.2 R2 Build 3790.srv03_sp2_rtm.070216-1710 : Service Pack 2) running MOSS 2007 Enterprise SP2 and WSS 3.0 sp2 (it recommended I install that) x64. I extracted the install files and put the updates in the update folder for installation. The IP is It's probably worth noting that I am using a trial key for MOSS at the moment until our MSDN license comes through.Devsql40: devsql40 is a Windows Server 2008 R2 Enterprise edition x64 (winver 6.1 build 7600) running SQL Server 2008 R2 SP1 x64. The file version for sqlservr.exe is 2009.100.1352.12. The SQL instance name is default.Devsql40 also has SQL Reporting services installe

MOSS 2007 Standard installation with SQL Server 2008 EXPRESS Edition server

Hello I have installed MOSS 2007 with SQL Server 2008 Express edition. Can anyone tell me what all features will be missing when compared this setup to MOSS 2007 Stanadard with SQL server 2008 lisenced editon? Specifically will I not be getting forms services with "MOSS 2007 with SQL Server 2008 EXPRESS edition"? Thanks in advance.

Problem configuring SSRS 2008 with sharepoint 2007 on Windows server 2008

Hi All - I am unable to integrate SSRS 2008 with sharepoint 2007. I am new to this part please correct em if am wrong. I have 2 servers one for SQL and one for MOSS MOSS server. Windows server 2008 MOSS 2007 .Net 2008 with basic sql 2005 which comes default WSP builder Everything is working fine SQL server: Windows Server 2008 SQl server 2008 and configured SSRS BIDS. When I am trying to install SSRS plugin for MOSS it is not accepting on both the machines. Please help me if am missing something here. I configured sucessfully on one server but havent done on multi server environment. please help me.   Thanks Saritha    saritha k

MOSS 2007 Standard installation with SQL Server 2008 EXPRESS Edition server

Hello I have installed MOSS 2007 with SQL Server 2008 Express edition. Can anyone tell me what all features will be missing when compared this setup to MOSS 2007 Stanadard with SQL server 2008 lisenced editon? Specifically will I not be getting forms services with "MOSS 2007 with SQL Server 2008 EXPRESS edition"? Thanks in advance.

Moss 2007 and Server 2008 R2 Forest



I am not sure if this should go to the AD forums but I wanted to verify the compatibility of MOSS 2007 with a Server 2008 R2 forest and domain funtional level. We are looking to upgrade our AD environment to Server 2008 R2.

Any inisght would be greatly appreciated.


Moving to Active Directory to 2008 R2 - any issues with MOSS 2007?


Moving to Active Directory to 2008 R2 - any issues with MOSS 2007?

Anybody else running that combination? Any considerations.

Cannot connect new Servers to existing MOSS 2007 SP2 farm


We have Single Server MOSS 2007 SP2 farm with DBA managed database server. We have different web applications running and deployed several solutions (SharePoint Learning Kit, Facet Search, workflow extensions, new themes) in the farm.

Recently we wanted to scale out our farm by adding one WFE and one indexing server. I have installed MOSS 2007 SP2 slipstream in the C drive (default location) of both the new servers. Then before running the SharePoint Product & Technology Configuration Wizard I uninstalled MOSS, restated the servers and reinstalled MOSS 2007 SP2 slipstream in D drive.

I didn't add farm administrators group to the local administrator group of the new servers but I added my own account which is a member of farm administrator group to local administrator group. I didn't add Central Admin Webapp pool identity account (which is a service account) to the local administrator group either. But this service account as well as farm administrators group account has dbcreator & securityadmin privileges in the sql server, both t

Moving MOSS 2007 from 2x Dedicated servers to 1x VM - Migration Tutorials?


Greetings all,

We're recently phased out our MOSS 2007 environment (after migrating to MOSS 2010), and need to reclaim the servers from our 2007 install. However, we need to provide access to the old 2007 environment for 9-12 months more.

So, my plan is to migrate the Content DB and FE from their split-environment (two server) solution into a single VM that we can power up when needed.

Knowing that there are a great number of quality tutorials in existence for MOSS 2007, I wonder if someone might recommend tutorials/posts they've found useful for migrating the Content DB and/or FE (this is similar to a disaster-recovery situation in which the FE and DB are rebuilt, no?), beyond the TechNet articles on the matter.

Thanks for your help!


Workflow with instantiation form in VS 2008 for MOSS 2007


Guys. I have a MOSS 2007 install, using VS 2008.

I am trying to create a workflow in VS that simply does the following:

On Start, goes to an instantiation form. This collects one field of data. When this is submitted, the workflow updates a couple of fields, then finished. Sounds easy huh.... It sure is in SPD, but in VS it isn't so easy. I am also following Robert Shelton's blogs on this (if you have seen them).

So I have my workflow project, and for the pages, am putting them in their own folder  in the LAYOUTS within 12 hive.

I am getting an error of

Object reference not set to an instance of an object. at InstantiationForm_InstantiationForm.serializeInstantiationFormDataToXML() , but I can't debug it (even when attaching to W3WP.exe).

My aspx page code:

<%@ Page Language="C#" AutoEventWireup="true" 

Upgrading servers in a MOSS 2007 farm from Windows 2003 SP2 to Windows 2003 R2

Are they any particular pitfalls to watch out for here?  We have two front ends in a load balance with an index server, andtwo SQL servers forming a failover cluster.

Utilizing Entity Framework 4.0 in MOSS 2007 with Visual Studio 2008



I am trying to create a webpart using VSeWSS 1.3 in VS 2008 and utilize Entity Framework 4.0 .

I am able to do it in .NET 3.5 but i am unable to create a 4.0 solution in VS 2008 to replicate steps for 4.0 .

Can this be done, if yes then how?

Your help will be really appreciated.


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend