MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Issue for installing sharepoint server 2007 in sql server 2008 and window server 2008

  Asked By: Urjita    Date: Oct 04    Category: MOSS    Views: 1736

In windows server 2008, sql server 2008 was installed which include reporting services. Then Office sharepoint server 2007 was installed.
1. Sharepoint client use local domain authentication, it is correct ?
when I open browser at: http://computername/
It ask me login. After I login administrator in local domain, I can see page and URL: http://computername/Pages/Default.aspx

Look like it is only for local user.
If for Internet users, do we need to custimize it to form authentication like sql server reporting service?

2. In Sharepoint, go through all function. Only report is not working.
In detail, when clicke Reports tab, it give me errors:

Server Error in '/Reports' Application.
The resource cannot be found.
Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly.

Requested URL: /Reports/Pages/Default.aspx

In order to make reports work, do I need to install WSS, Windows Sharepoint Service ?
It is not included in sharepoint server 2007 ?
or need some simple configuration or need to integrate it to sql server 2005 or sql server 2008 ?
how ?

3. In default, sharepoint server 2007 use sql server 2005 or 2005 express. Can I config it to use sql server 2008 ?
How ?

4. In my case, there are any conflicts between sharepoint reports and sql server reporting service ?
They use same one.



1 Answer Found

Answer #1    Answered By: Virendar Bahudur     Answered On: Oct 04

I would recommend changing your Reporting Services to a different port number than the default 80 since this is also leveraged by SharePoint as you have seen. Simply run the Reporting Services Configuration Manager, connect to the instance, go to the Web Service URL, and change the TCP port from the default 80 to a different value. Since you are currently using Native mode for SSRS 2008 you will then want to review the Report Manager URL settings and modify them accordingly.

You will now access the Report server  with the following URL --> http://servername:'port#'/reportserver

Just to let you know, SSRS 2008 no longer depends on IIS anymore. When you go to the Integrated Mode that will not resolve the port number issue.