.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 server Report services integration with moss 2007 giving hard time.

Posted By:      Posted Date: September 02, 2010    Points: 0   Category :SharePoint
Hey guys, I have 2 servers  in seperate domain one for database and other for moss 2007. SERVER 1 :     AD,DNS,SMTP,SQL SERVER 2005 sp3 .... SERVER 2:    MOSS 2007 APPLICATION SERVER with sp2 and october cumilative updates applied. i have even installed NDP20-KB913384-X86.exe hot fix for .net framework 2.0 access voilation error. In CA my server 2 version is When i installed sql server 2005 on server 1 during installtion for report server i choosed install but do not configure. Now I decided to integrate the sql server report services into sharepoint and did some research and found some articles on msdn which says in order to integrate the report services into sharepoint i need to have a minimal install of moss 2007 on server hosting report services (correct me if i am wrong). since i have only 2 servers i decided to install the minimal installation of moss 2007 on my server 1 ( Web front end only ). Here are the steps i followed for it Installed .NET framework 3.0 Installed moss 2007 sp2 Installed october cumuilative update for wss then same for moss 2007. Installed .net framework 2.0 NDP20-KB913384-X86.exe hot fix. and then ran the psconfig from command line as psconfig -cmd configdb -connect -server <SQLServerName> -database SharePoint_Config_ <dbname> -user <domainusername> -password <passw

View Complete Post

More Related Resource Links

Moss 2007 integration with Exchange Server.

Hi All , I am planning to Use exchange server for sending and receiving emails via Sharepoint. can you guys provide me with links or material that can guide me as how i can achieve it Cheers, Friend.

SQL SERVER 2005 Analaysis Services -> KPI -> MOSS 2007. Connection Timed Out


I am using SharePoint 2007 and trying to set up some KPIs in Executive Dashboard.
I have an ODC uploaded to my document library which has been connected to analysis
services cube which also has some kpi's. When i use the ODC file to connect to analysis
services to retrieve the KPI they don't seem to appear under ALL KPI'S and i also get an

This data connection does not use encryption for the communication with the SQL Server
 2005 Analysis Services server. It is recommended to enable encryption for the SQL Server
2005 Analysis Services server to help prevent unauthorized users from viewing this information.

The connection either timed out or was lost.

The same works connection file works in Excel. 




Moss Deep Integration with Reporting Services Issue - 3rd time lucky!



Raised this on the SSRS Newsgroup, and even SharePoint WSS Newsgroups but they say needs to be put here instead -
HELP Please!

When I try to run a report that uses a Report Model, MOSS says it cannot be
found when it is there. A different report that use Data Source without
Report Model works ok. Any ideas anyone please.

Thing is when I use the Report Center template and do the same thing it
works fine!!!

What is MOSS doing, to not be able to find the Report Model please and how
can I fix it urgently....

SQL Server 2005: Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Services


Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.

Teo Lachev

MSDN Magazine October 2006

Data Points: Report Controls in SQL Server 2005 Reporting Services


Reporting has always been one of the dark arts of development. The tools typically seem to do just enough to get you to a certain point, then leave you to find workarounds to solve more complex issues.

John Papa

MSDN Magazine July 2006

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

Attempting to install a Reporting Services for MOSS 2007



I am tasked with writing reports for existing MOSS 2007, for that i am doing a test installation and test connection to a test moss server (copy of the main one)

So, i have a already set and running MOSS 2007. I am following theese tutorials



But in my case, i have only two machines - one with main site moss and one with reporting services and sql for reporting services.

So far, i have installed SQL server, installed moss and reporting services on the reporting services machine.

I joined my moss into the existing farm successfully.

I've set up reporting services according to the tutorial (Except i use an account provided by test server administrator, which has all rights granted, since we dont bother with least privellege here, not a very big company...)

But when i check the /reportingservices page i see an error (its in russian) that teh server is wrongly configured. rsServerConfigurationError is the kind of error. 

The tutorial said that i should see a blank page at this point. I will continue tutorial futher tomorrow (work day ends now

Interacting with the Excel Web Services API for SharePoint Server 2007

Get a quick start with the Excel Web Services API, which enables interaction with published Excel 2007 workbooks in SharePoint Server 2007 from a remote application. Learn considerations around session state, security, and performance.

Video: Coding a Long-Running Operation Page in SharePoint Server 2007 or Windows SharePoint Services

Watch this visual how-to video as you learn to write code to mimic the default long-running operations page (the "spinning wheel") in SharePoint Server 2007 or Windows SharePoint Services 3.0. (Length: 7:56)

Coding a Long-Running Operation Page in SharePoint Server 2007 or Windows SharePoint Services 3.0 (V

Watch the video and explore code as you learn how to write code to mimic the default long-running operations page (the "spinning wheel") in SharePoint Server 2007 or Windows SharePoint Services 3.0.

Best Practices for Content Types in SharePoint Server 2007 and Windows SharePoint Services 3.0

Learn best practices to develop, deploy, and manage custom content types, as well as scenarios for making updates to existing content types in lists.

Office 2003 integration with MOSS 2007



All my documents are opening as read-only when I open from SharePoint sites even when I click on "Edit in ..." option on some machines.

The users seem to have correct permissions on the site.



Office 2003 integration with MOSS 2007


Hi ,

All my files/docs in MOSS 2007 open as read-only with Office 2003 standard edition in some machines.

The user seems to have sufficient permissions to edit but still not able to do so.

Any suggestion?




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

The report server instance is not configured correctly. Please use the Reporting Services Configurat

Hello All, I am having problem in configuring report server in SharePoint 2010 Central Administration. The Scenario is explained below: We have farm with two Servers with following components installed: 1. APPSERVER : SharePoint 2010, SSRS(2008 R2) and Reporting Services Add in (installed using credentials    (domain/sharepointuser)) 2.  SQLSERVER: SQL SERVER 2008 R2, Report Server Database (installed using credentials    (domain/sqluser)) Steps followed: a. Configured Report Server on APPSERVER with database in SQL SERVER. We browsed the report server url (http://localhost/reportserver) successfully b. Installed Reporting Services Addin on APPSERVER c. In SharePoint Central Administration, Under Reporting Services Integration, we gave the report server web server url as http://localhost/reportserver , authentication as Windows Authentication and credentials which are used to install SQL SERVER (domain/sqluser) d. We also added a new group called WSS_WPG Error is given below: The report server instance is not configured correctly. Please use the Reporting Services Configuration tool to create a report server database in SharePoint integrated mode before setting integration options for this SharePoint Web application. Thanks in Advance  

How to set the IP addresses for teh report server on sql server 2008 reporting services

How to assign IP address to report server on 2008 version, i don't see nothing on IIS. I have installed sql server / report server 2008 on windows 2003 server. I don't see no info in IIS, can you please help, Also how to check the configuration files i remember in 2005 version i still have to open teh configuration file in notepad and do some modifiications with teh http://local to http://IPaddress etc. Thanky ou very much for the help ful info.  

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
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