Connect to internal SharePoint database from web site.

Hello,
There's information on my Internal SharePoint DataBase that I want to access. How can I do this? Could you help me or at least point me in the right direction.

The information I am requesting is just text.

Thank you,
Mark

Hi Mark,

I don't think so that kind of info is available. The table structure and relationships are quite messy. It's not recommended to access those tables directly, not to say it's prohibited.

I have done a lot of Sharepoint customizations, and what I did was accessing the Sharepoint internal object with it's object model. You can download the WSS SDK (both 2.0 and 3.0), and install it. The help file in the SDK has alot of sample code that we can use.

Happy coding :)

|||

Hi Mark,

I don't think so that kind of info is available. The table structure and relationships are quite messy. It's not recommended to access those tables directly, not to say it's prohibited.

I have done a lot of Sharepoint customizations, and what I did was access the Sharepoint internal object with it's object model. You can download the WSS SDK (both 2.0 and 3.0) are available. There are alot of sample code that we can use.

Happy coding :)

|||

Hi Mark,

I don't think so that kind of info is available. The table structure and relationships are quite messy. It's not recommended to access those tables directly, not to say it's prohibited.

I have done a lot of Sharepoint customizations, and what I did was accessing the Sharepoint internal object with it's object model. You can download the WSS SDK (both 2.0 and 3.0), and install it. The help file in the SDK has alot of sample code that we can use.

Happy coding :)

|||

I am starting to see this now. Thank you for your response.

Configure Report Server - SharePoint Integration

Hello,

I'm trying to set up SharePoint Integration for our report server. The setup we have is: 1. SQL server hosting the SharePoint databases and the Reporting Server, 2. SharePoint web front end hosting all SharePoint services. I've installed the reporting services SP2 on the SQL server and the reporting services add-in on the SharePoint server.

I configured the report server following the directions here: http://download.microsoft.com/download/f/d/c/fdcb3a53-0cb1-4e67-a1b6-45b89b3c59cf/readme_rsaddin.htm and here: http://www.sharepointblogs.com/helloitsliam/archive/2007/02/21/19801.aspx

Everything seems to be set up correctly, but when I open the Reporting Services Configuration Manager, the SharePoint Integration option shows the error, "The report server cannot access setting in the SharePoint configuration database. Most likely, the Windows SharePoint Services object model...."

I do have WSS 3.0 installed on the report server.

When I look in the logs on the report server it says the login failed for the account I have set as the Windows Service Identity however, when I look at the logs on the SharePoint server it shows that it is granting the account read and write access to each of the SPWebApplications I have set up.

Any suggestions?

Thanks,

Cynthia

I just figured it out. It always happens that after days of unsuccessful attempts, I figure out the problem as soon as I post to a forum.

In case anyone else has the same problem:

In the Reporting Services Configuration Manager, under Windows Service Identity, I re-entered the name and password of the account and this caused a new dialog box to open prompting me to create an encryption key back-up. I provided a password and file location and then it worked. I'm not sure why I didn't get that dialog box initially, but everything works fine now.

Thanks,

Cynthia

|||

Hi

Can you people please confirm me that

Is that SQL Reporting Services 2005 can only be integrated with MOSS but not WSS 3.0

I am using wss3.0 (Not MOSS) and SQL reporting services 2005.

Configuration steps completed but i am not able to see the Reporting Services section in Application management

of Central Administration.

I installed SQL SP2 and Reporting Services Add ins and everything is on one system, i mean SQL2005 and wss3.0 on one system

I could use SQL Report configuration tool and set all the properties but not able to find Reporting Services section in Application management

of Central Administration.

Please Advice

Thanks,

Tiger

|||

Yes i got the solution for this

We need to Activate the Reporting services in the Central Administration this can be done by the following steps

1. Go to Site settings

2.In the Site collection Administration navigate to Site collection Features

3. Enable the Settings for Reporting Sevices

This will dispay the Reporting Section in the Application Management of Central Administration

Hope this will be help full.

Many Thanks,

Tiger

Configure Report Server - SharePoint Integration

Hello,

I'm trying to set up SharePoint Integration for our report server. The setup we have is: 1. SQL server hosting the SharePoint databases and the Reporting Server, 2. SharePoint web front end hosting all SharePoint services. I've installed the reporting services SP2 on the SQL server and the reporting services add-in on the SharePoint server.

I configured the report server following the directions here: http://download.microsoft.com/download/f/d/c/fdcb3a53-0cb1-4e67-a1b6-45b89b3c59cf/readme_rsaddin.htm and here: http://www.sharepointblogs.com/helloitsliam/archive/2007/02/21/19801.aspx

Everything seems to be set up correctly, but when I open the Reporting Services Configuration Manager, the SharePoint Integration option shows the error, "The report server cannot access setting in the SharePoint configuration database. Most likely, the Windows SharePoint Services object model...."

I do have WSS 3.0 installed on the report server.

When I look in the logs on the report server it says the login failed for the account I have set as the Windows Service Identity however, when I look at the logs on the SharePoint server it shows that it is granting the account read and write access to each of the SPWebApplications I have set up.

Any suggestions?

Thanks,

Cynthia

I just figured it out. It always happens that after days of unsuccessful attempts, I figure out the problem as soon as I post to a forum.

In case anyone else has the same problem:

In the Reporting Services Configuration Manager, under Windows Service Identity, I re-entered the name and password of the account and this caused a new dialog box to open prompting me to create an encryption key back-up. I provided a password and file location and then it worked. I'm not sure why I didn't get that dialog box initially, but everything works fine now.

Thanks,

Cynthia

|||

Hi

Can you people please confirm me that

Is that SQL Reporting Services 2005 can only be integrated with MOSS but not WSS 3.0

I am using wss3.0 (Not MOSS) and SQL reporting services 2005.

Configuration steps completed but i am not able to see the Reporting Services section in Application management

of Central Administration.

I installed SQL SP2 and Reporting Services Add ins and everything is on one system, i mean SQL2005 and wss3.0 on one system

I could use SQL Report configuration tool and set all the properties but not able to find Reporting Services section in Application management

of Central Administration.

Please Advice

Thanks,

Tiger

|||

Yes i got the solution for this

We need to Activate the Reporting services in the Central Administration this can be done by the following steps

1. Go to Site settings

2.In the Site collection Administration navigate to Site collection Features

3. Enable the Settings for Reporting Sevices

This will dispay the Reporting Section in the Application Management of Central Administration

Hope this will be help full.

Many Thanks,

Tiger