Help Please. Sharepoint+Access Db + Infopath
Jun 10, 2007
Hi guys. Im having alot of trouble with this. I have created a simple access database, uploaded to a doc library on a sharepoint site. Then I made a infopath form based on this by using the url: //207.245.47.37/sites/Safety_and_Training/ai/db2.mdb
I succeeded in creating the form. I then published it onto the sharepoint site. Now, when I try to fill out the form so the database can be filled in, I hit submit and it opens up a ADO warning telling me that the website is using my identity to connect to the datasource, I hit ok and then I get another window saying "Please enter MS JET OLE DB Initialization." In the fields it has 1) Datasource is \207.245.47.37sitesSafety_and_Trainingaidb2.mdb, the 2)username is Admin, 3)password is blank, 4)provider string is blank and the 5)open mode is on DB_Mode_Readwrite.
1. One thing I tried is in the username and password I give my administrator login as CorpdynatecRGill, and then the password I always use to login onto the site. It then gives me:
InfoPath cannot connect to the data source.
Not a valid account name or password.
2. Next thing I try is just leaving the username as admin and password blank but then I get the message:
InfoPath cannot connect to the data source.
The Microsoft Jet database engine cannot open the file '\207.245.47.37sitesSafety_and_Trainingaidb2.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
I think it might have something to do with the permissions, but nothing has been working yet. Please help me.
View 2 Replies
ADVERTISEMENT
Dec 19, 2006
Hello,
Anyone have any solid solutions for using Reporting Services 2005 to report against a SharePoint List and/or InfoPath Forms Document Library?
This seems to be a popular one for reporting against the SharePoint List, but it looks like there are some issues with it, such as getting it to work with Subscriptions...
http://www.teuntostring.net/blog/2005/09/reporting-over-sharepoint-lists-with.html
TIA!!
View 1 Replies
View Related
Nov 28, 2007
I posted this in the Sharepoint Designer forum, but did'nt get an answer...so trying here...Below is my soap endpoint in sql2005...works fine for InfoPath to consume the service...but when SharePoint Designer attempts to retieve data I get
"The server returned a non-specific error when trying to get data from the data source."
In SPD I can connect to the service and see the methods and parameters...but never get any data returned...wondering if it's in my endpoint setup. BTW-using Windows security by default in SQL2005...I've tried different types of logins without success...
/****** Object: Endpoint [getSCMADataEndpoint] Script Date: 11/28/2007 10:38:43 ******/
CREATE ENDPOINT [getSCMADataEndpoint]
AUTHORIZATION [SCMAadministrator]
STATE=STARTED
AS HTTP (PATH=N'/getscmadatawebservice', PORTS = (CLEAR), AUTHENTICATION = (), SITE=N'scmasvr01', CLEAR_PORT = 80, COMPRESSION=DISABLED)
FOR SOAP (
WEBMETHOD 'GetCourseInfo'( NAME=N'[SCMA].[dbo].[prGetCourseInfo]'
, SCHEMA=DEFAULT
, FORMAT=ROWSETS_ONLY),
WEBMETHOD 'GetCourseLectures'( NAME=N'[SCMA].[dbo].[prGetCourseLectures]'
, SCHEMA=DEFAULT
, FORMAT=ROWSETS_ONLY),
WEBMETHOD 'GetCourseLecturesInstr'( NAME=N'[SCMA].[dbo].[prGetCourseLecturesInstr]'
, SCHEMA=DEFAULT
, FORMAT=ROWSETS_ONLY),
WEBMETHOD 'GetCourseObjectives'( NAME=N'[SCMA].[dbo].[prGetCourseObjectives]'
, SCHEMA=DEFAULT
, FORMAT=ROWSETS_ONLY),
WEBMETHOD 'GetCourseRosterInfo'( NAME=N'[SCMA].[dbo].[prGetCourseRosterInfo]'
, SCHEMA=DEFAULT
, FORMAT=ROWSETS_ONLY),
WEBMETHOD 'GetSCMAAccounts'( NAME=N'[SCMA].[dbo].[prLookupSCMA_accounts]'
, SCHEMA=DEFAULT
, FORMAT=ROWSETS_ONLY),
WEBMETHOD 'GetSCMAAccounts_FieldNames'( NAME=N'[SCMA].[dbo].[prLookupSCMA_Accounts_FieldNames]'
, SCHEMA=DEFAULT
, FORMAT=ROWSETS_ONLY), BATCHES=DISABLED, WSDL=N'[master].[sys].[sp_http_generate_wsdl_defaultcomplexorsimple]', SESSIONS=DISABLED, SESSION_TIMEOUT=60, DATABASE=N'SCMA', NAMESPACE=N'http://tempuri.org', SCHEMA=STANDARD, CHARACTER_SET=XML)
View 4 Replies
View Related
Mar 2, 2007
I get the following error when I try to navigate to a report/model/data source, stored in a Sharepoint Document Library using a Sharepoint URL based on an Extranet or Intranet zone - but it works OK using the url for the Default zone:
System.Web.Services.Protocols.SoapException: The specified path refers to a SharePoint zone that is not supported. The default zone path must be used. ---> Microsoft.ReportingServices.Diagnostics.Utilities.SecurityZoneNotSupportedException: The specified path refers to a SharePoint zone that is not supported. The default zone path must be used.
Is this a limitation of the SQLRS-WSS3 integration or is there a workaround?
Many thanks to anyone who can help!
View 22 Replies
View Related
Jul 25, 2007
hi,
I am not sure whether this is the place for this post.
I am developing a Vb.net search functionality which is accessing data from the SQL SERVER sharepoint portal database.
I have troubles in connecting to the particular server and retrieving each table from the database.I have succes in importing tables into Access.
I want to query the portal sql database itself and need to provide a connection string which will made the access easier.
Any suggestion or help to do would be much apprecited.
thanks in Advance.
Barti
View 6 Replies
View Related
Sep 11, 2007
I am trying to run a Reporting services report and pass a parameter using url access and SP Integrated mode.
I have managed to come up with the following: http://DashBrdRptSite/reportserver?http://npvmdashbrd1:2764/Reports/dashbrdrptstore/real%20time%20running/test.rdl&rs:Command=Render&Year=2006&Year=2007&Month=1
This works perfect as long as I run it from the actual server that has Sharepoint and reporting services installed.
If I try to run it from my desktop, I get prompted for a user name and password. And now matter how many times I enter my user/pass... it does not work.
If I just run the sharepoint link that appears on the report when I run it from within sharepoint... such as
http://npvmdashbrd1:2764/Reports/DashBrdRptStore/_layouts/ReportServer/RSViewerPage.aspx?RelativeReportUrl=%2fReports%2fDashBrdRptStore%2fReal+Time+Running%2ftest.rdl&Source=http%3a%2f%2fnpvmdashbrd1%3a2764%2fReports%2fDashBrdRptStore%2fReal%2520Time%2520Running%2fForms%2fAllItems.aspx&DefaultItemOpen=0
That runs no problem no matter where I run it from (my desktop or the Sharepoint Server), but it looks like I cannot pass it parameters. I guess becuase it is useing RSViewerPage.aspx.
Can someone please help me out?
Thanks
View 5 Replies
View Related
Jun 21, 2006
I have about 20 Ms Access Databases to need to be upload onto a SQL Server2005.Currently the are on a network/server residing on a specific drive. The goalis to keep the user face the same (ms access) and put all of the tables ontoa SQL Server 2005 BE, and yet make those databases accessible to open/viewthrough Ms Sharepoint.What is the simple (properties) way to grab all of those db's = 20 and uploadto server?With out having to write code.Pull all db's over to SQL then store the Ms Access databases on Sharepointwhere the user face remains the same and the tables are on the server and thedb's are accessible now through the company Intranet.--Message posted via http://www.sqlmonster.com
View 2 Replies
View Related
Jun 29, 2007
I want to create some links in Sharepoint that will take me directly to a report, display it within the SharePoint full page report viewer and set some parameter values along the way.
I've tried:
http://<sharepoint server>/<portal name>/<report library>/<report name>.rdl?Param=value
No luck.
Anyone have suggestions? Workarounds?
View 4 Replies
View Related
Jan 29, 2008
I built a form in infopath 2003 ...now I want that the information
will be send to the SQL server....
Is there a place here (in this site) I can Study this....
I know that I need to drag the Fileds from the form to the Sql tables....
my form has 100 fields...lots of check boxes.....
Where can I study this in this site.... ? from the begining !!!
Thank you again.....Hope you will help me
View 1 Replies
View Related
Jan 29, 2008
I built a form in infopath 2003 ...now I want that the information will be send to the SQL server....
Is there a place here (in this site) I can Study this....
I know that I need to drag the Fileds from the form to the Sql tables....
my form has 100 fields...lots of check boxes.....
Where can I study this in this site.... ? from the begining !!!
Thank you again.....Hope you will help me
View 1 Replies
View Related
Jan 31, 2007
Hi,
I installed IE7 recently and it is giving me problems when I open Infopath forms to edit documents. I have a sharepoint website which contain links to these forms, when I click on the link it opens the infopath form. It was working absolutely fine when I used IE6. But now when I open the infopath form it gives me an error saying that
A Runtime error has occured
Line: 38
Error: Object Expected
When I open it in the debugger it shows me an error at <body onLoad="onLoad()">. Could someone please advice!
I appreciate a quick response.
Thanks
View 2 Replies
View Related
Apr 11, 2008
Hi
In my current project we are dealing with a lot if Infopath forms of all sizes and complexities. currently they are being saved in Forms library of sharepoint.
We need to build a warehouse for SSRS which receives data either from content database or from infopath forms submit with minimum latency.
I thought of few alternatives, but, not sure which is most robust and economical.
1. Built c# classes to parse XML of infopath forms and then push data to SQL using ADO.net and SQL stored procedure while item is being added (ItemAdding) to Forms Library.
2. Use CAML queries to extract XML from forms library and then continue with C#/ADO/SQL..
3. Use SSIS APIs and webservices to massage XML and put it to SQL at ItemAdding event
4. Use CAML queries to generate XML files and stage it to FTP and rest will be done on SSIS.
I am currently looking for feseability information based of Besy Known Practise. Please feel free to suggest a totally new approach, if available.
Thanks
View 3 Replies
View Related
Jan 9, 2007
Hello,
I created an InfoPath 2003 form, with a datasource from SqlServer 2000. When I try to insert a new record the follow error occurs:
"InfoPath cannot connect to the data source.
Safety settings on this computer prohibit accessing a data source on another domain."
I checked Enabled -"Access data source accross domains" from Security Settings->Miscellaneous, but the error still appears.
Have anyone any idea about this error?
Thanks.
View 1 Replies
View Related
Feb 2, 2007
Does anyone know the location of Microsoft.ReportingServices.SharePoint.UI.WebParts.dll after you install the web part? I am wondering if I can inherit from this web part to wrap some other functionality into it. I know that i see it in the GAC buyt can't seem to find it so I can look at the assembly using reflector.
Also, how easy is it to pass in parameters to the Report Viewer?
Thanks!
Erik
View 6 Replies
View Related
Jan 17, 2008
Since I wasn't getting any replies with answers or suggestions to my initial posting, I figured I would continue to list the problems and solutions I've encountered while trying to setup and utilize SharePoint integration mode, and read data from SharePoint with SSRS reports (developed in VS2005). Hopefully this is helpful to anyone that is also trying to learn all this stuff and figure it out.
(Single server - W2K3R2_SP2 as: DC / SQL2005 Standard / MOSS2007 Enterprise - see the bottom of this posting for the steps I took to set that up)
Note: After I get this to work, I intend to post my experiences for setting up SharePoint Integration with SQL and SP on separate boxes.
1. In the new reporting section under SharePoint application management in the Central Admin Console, the Grant database AND Set Server Defaults work when using the domain admin account, but not when using the SQLSPS service account I used to setup both SQL and SharePoint. Why can't I use the service account? Is the domain admin account now going to be used as a service account for accessing the sharepoint database?
This question remains unanswered as of yet.
2. Reporting Services configuration tool shows Sharepoint integration as red x when I create a new database in integration mode. (the service account SQLSPS and the Server object are members of the group WSS_WPG). If I switch back to native mode (the original reportserver database), the red x goes to a blue exclamation instead. Using Service Credentials or Windows credentials (as either the service account SQLSPS or as domain admin) doesn't change anything.
RESOLVED by using a domain user account for the ReportServer WebApp. Even though everything is installed on the same machine, it seems using the default of NETWORK SERVICE wasn't acceptable. Possibly because SharePoint is configured to allow additional machines in the farm?
3. http://servername:8080/reportserver will display Report Server information as it did before the integration on port 80, but http://servername/reportserver doesn't display anything through SharePoint.
Resolved. I needed to define a repository before I could view it (go figure). When I created a sharepoint site based on a report center template, created a data connection library and report library, and then referenced that by http://servername/sites/myReportCenterSite/myReportLibrary, I was able to see the equivalent of http://servername/reports (which is now disabled due to integration mode).
4. Unable to deploy to new report center sharepoint site I mention above using Visual Studio. I kept getting "A connection could not be made to the report server http://servername/sites/ReportCenter. Server was unable to process request. The request failed with HTTP status 503: Service unavailable (System.Web.Services). In Visual Studio, the project properties were: TargetDataSourceFolder = http://servername/sites/myReportCenterSite/myDataConnectionLibrary, TargetReportFolder = http://servername/sites/myReportCenterSite/myReportLibrary, TargetServerURL = http://servername/sites/myReportCenterSite/
Found these errors in the event logs on the server.
Event Type: Warning
Event Source: W3SVC
Event ID: 1021
Description:
The identity of application pool, 'ReportServer' is invalid. If it remains invalid when the first request for the application pool is processed, the application pool will be disabled. The data field contains the error number.
Event Type: Warning
Event Source: W3SVC
Event ID: 1057
Description:
The identity of application pool 'ReportServer' is invalid, so the World Wide Web Publishing Service can not create a worker process to serve the application pool. Therefore, the application pool has been disabled.
Event Type: Error
Event Source: W3SVC
Event ID: 1059
Description:
A failure was encountered while launching the process serving application pool 'ReportServer'. The application pool has been disabled.
RESOLVED the issue by changing the Application Pool used by reporting services from ReportServer to DefaultAppPool and changing the account DefaultAppPool used from NETWORK SERVICE to my service account SQLSPS. I have no idea why ReportServer is invalid, it was set to use the service account SQLSPS the same as DefaultAppPool is. Perhaps the reporting services add-on makes a change to invalidate this?
5. Attempting to read a SharePoint list using a SSRS report. This should be fun.
First, created a new custom list in the ReportCenter SharePoint sites I've been using and called it myCustomList. I added one item with a title of myCustomListItem1. I don't know if I need to do more than that for a simple test of reporting or not yet.
Second, configured new shared data source. Name = myCustomList1DataSource, type=XML, Connection String = http://servername/_vti_bin/lists.asmx (this URL is viewable in IE), Using Windows authenticaion.
Third, in VS2005 on a workstation in the domain, create new report item (report1.rdl). New dataset for report; Name=Report1DataSet, Data Source=myCustomList1DataSource (Shared), Command type = text, Query String = [See Queries and associated errors below]:
Initial query obtained from: Connecting SQL Reporting Services to a SharePoint List (David Wise)
http://www.sharepointblogs.com/dwise/archive/2007/11/28/connecting-sql-reporting-services-to-a-sharepoint-list-redux.aspx
Note: Queries when executing the dataset (which errors out) and when executing a query in CAML Viewer for the same information (which does work just fine) both initially return 401.1 and 401.2 errors (as viewed in Fiddler). Since the CAML query works, I have not tracked this down yet.
A. Original format from posting
<Query>
<Method Namespace=http://schemas.microsoft.com/sharepoint/soap/ Name="GetListItems"/>
<SoapAction>
http://schemas.microsoft.com/sharepoint/soap/GetListItems
</SoapAction>
</Query>
Parameter; Name => listName, Value => =myCustomList
Was NOT prompted to define the query parameters
- Gets this error: "An error occurred while setting the command text property of the data extension command. The XmlDP query is invalid. (Microsoft.ReportingServices.DataExtensions)."
- Advanced information from the error => 'http' is an unexpected token. The expected token is '"' or '''. Line 2, position 19. (System.Xml)
B. Changed: Placed the namespace URL in quotes (also tried with and without / in namespace after /soap)
<Query>
<Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems"/>
<SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems
</SoapAction>
</Query>
Parameter; Name => listName, Value => =myCustomList (also tried Value => myCustomList) (no equal sign)
Clicked "!" to execute, and got prompted to define the query parameters
Entered Name => listName, Value => myCustomList
- Gets this error: "failed to execute web request for the specified URL (Microsoft.ReportingServices.DataExtensions)."
- Advanced information: <faultstring>Server did not recognize the value of HTTP Header SOAPAction: http://schemas.microsoft.com/sharepoint/soap/GetListItems/.</faultstring>
C. Try the query string that seems to work for Stramit CAML Viewer to read myCustomList
Stramit CAML query:
<Query xmlns="http://schemas.microsoft.com/sharepoint/soap/">
<OrderBy>
<FieldRef Name="ID" />
</OrderBy>
</Query>
Also tried
<Query xmlns="http://schemas.microsoft.com/sharepoint/soap/">
</Query>
And tried entering no query...
Parameter; Name => listName, Value => =myCustomList (also tried Value => myCustomList) (no equal sign)
Clicked "!" to execute, and got prompted to define the query parameters
Entered Name => listName, Value => myCustomList
- Gets this error: "failed to execute web request for the specified URL (Microsoft.ReportingServices.DataExtensions)."
- Advanced information: <soap:Fault><soap:Code><soap:Value>soap:Receiver</soap:Value></soap:Code><soap:Reason><soap:Text xml:lang="en">Server was unable to process request. ---> Data at the root level is invalid. Line 1, position 1.</soap:Text></soap:Reason><soap: Detail /></soap:Fault>
RESOLVED. Went back to the query used in B above, and mysteriously it works now. This could be the "funny things happen" symptom I've been reading about. We'll see if it continues to function.
Here's what I've learned so far on Issue #5:
1. XML is confusing. XmlDP is even more confusing...whatever that is. Apparently it's new to/with Reporting Services in SharePoint integration mode?
2. There is far too little documentation regarding XmlDP and querying SharePoint lists from SQL Reporting Services.
3. According to http://msdn2.microsoft.com/en-us/library/ms159741.aspx: You must use the generic query designer to create the query. The query is not analyzed to identify parameters; therefore you must create parameters through the Parameter tab on the Dataset dialog box.
Tried this query:
<Query>
<SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction>
<Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems" />
<Parameters>
<Parameter Name="listName">
<DefaultValue>myCustomReport2</DefaultValue>
</Parameter>
<OrderBy>
<FieldRef name="ows_Date" />
</OrderBy>
</Parameters>
</Query>
I was still prompted for the listName and the list returned with ows_Date still out of order. So maybe that proves this statement is true?
<translation: why make it convenient when it's already [somewhat] functional?>
4. When building the dataset, anything I place in the "Query string" box has to be enclosed in <query></query> tags or it errors out. I am trying to understand how to translate the CAML viewer query (which does work but isn't wrapped in query tags) into something that fits between query tags, and it hasn't gone well so far.
<translation: To be at one with your reports Grasshopper, you must understand xml>
5. According to http://srv1/sites/ReportCenter/_vti_bin/lists.asmx, "GetListItems" operation is supported
<translation: you're getting warmer...>
6. According to the soap output of my site http://srv1/sites/ReportCenter/_vti_bin/lists.asmx?op=GetListItems, I am only allowed to specify the following parameters: listName, viewName, query, viewFields, rowLimit, queryOptions and webID.
<translation: that and $3.00 will get you a cup of coffee>
7. According to http://www.sharepointblogs.com/dwise/archive/2007/11/28/connecting-sql-reporting-services-to-a-sharepoint-list-redux.aspx, only listName, viewName and rowLimit parameters are usable(?) (query and queryOptions may not be working properly with SSRS).
<translation: that kind of sucks>
8. When this started mysteriously working again, I tested using the "/" at the end of the namespace (wouldn't work without) and the "=" sign in front of the parameter value as defined on the parameter tab of the dataset (turns out to be optional).
As long as I can query SharePoint and get my list information back, I'm going to consider this issue closed and move on to actually using this information in a report. I'm sure that won't work right either, but why stop now?!
6. Ok, now that I can read SharePoint list data with SSRS, I need to try and actually do something with it.
A. Begin by setting up new data to report on
1. Create a new custom list (myCustomList2) and add a test record. This list will simulate the data we intend to submit to SharePoint using InfoPath, so it has a number of custom/created columns in it
2. Modify the working information from #5 above; add a new shared data source (myCustomList2DataSource), tell the dataset to use the new shared data source, change the information set in the parameter tab (Name => listName, Value => =myCustomList2) and test the dataset. Lucky me, it actually returned the record I entered on the first try.
B. Begin to build the report with the dataset returned
1. So, as I'm feeling good that it's actually reading the list in Step A without me threatening to destroy the machine, I look to the left in the Dataset results navigation pane in VS2005 and realize there are NO fields for me to choose to report on.
2. At this point, I have no clue what to do about getting this XML data into a report. Not that I have a large clue about SSRS otherwise, but I have at least been able to build SSRS reports when using a SQL database as the datasource. Fyi, http://msdn2.microsoft.com/en-us/library/ms159741.aspx states: "Reports can use data from XML documents and Web services, or embed XML in the query. There is no built-in support for retrieving XML documents from a SQL Server database.", in case anyone is trying to do that....
RESOLVED. Since the fields were not appearing automatically, I had started to add new fields to the dataset manually (if it doesn't work, beat it with a hammer, right?). I entered half a dozen or so fields, each one with the exact name as displayed in the query results, and then decided it would be fun to hit the refresh fields icon. As soon as I did that, all the fields shown in the query immediately appeared in the dataset and I was able to add them to a report. I don't know if I hit the refresh fields when working in issue #5, so I can't say if they are there now because of that, or because of adding some fields manually first, a combination of the two, or if it's just one of those mystery items I'm reading about with sharepoint reporting.
7. Rows are being returned even though they have NULL values (so far anyway), and most data is returning nicely for the bulk of the columns I created in the list I'm reporting on. Here are the current issues:
A. I have one column in my SharePoint list that is multi-lined text. If the text type is either rich text or enhanced rich text, the value returned in the query is formatted like this: "<div class=ExternalClassyadayada<div>My notes display here". If I set the column to be plain text, this doesn't happen. I will need to figure out how to filter that for my report.
RESOLVED. David Wise had some code listed at http://www.sharepointblogs.com/dwise/archive/2007/11/28/connecting-sql-reporting-services-to-a-sharepoint-list-redux.aspx that addressed this issue somewhat. I modified it to match my circumstances. Disclaimer: I'm not a programmer, so use this at your own risk.
function ExtractMultiLineText(myField as string) as string
dim strBegin as string
dim strEnd as string
dim myBegin as integer
dim myEnd as integer
dim myTextLength as integer
strBegin = "<div>"
strEnd = "</div>"
if myField = nothing then return ""
if myField = "" then return ""
myBegin = Instr(myField, strBegin) + Len(strBegin)
myEnd = Instr(myField, strEnd)
myTextLength = myEnd - myBegin
if myBegin < 1 then return myField
return mid(myField, myBegin, myTextLength)
end function
B. I have two columns in the SharePoint list that are set as number values with 0 decimal places. When I query those however in SSRS, they return with the number plus like 12 zeroes behind the decimal. Not a major issue, but I'll put it on the list anyway.
RESOLVED. Used the Int() function; =Int(Fields!ows_myProblemNumber)
C. If I go to "/_vti_bin/lists.asmx?op=GetListItems", it appears from the sample soap output that I am allowed to ask GetListItems for is: listName, viewName, query, viewFields, rowLimit, queryOptions and webID. As I mentioned in issue #5, according to http://www.sharepointblogs.com/dwise/archive/2007/11/28/connecting-sql-reporting-services-to-a-sharepoint-list-redux.aspx, only listName, viewName and rowLimit parameters are usable(?) and query and queryOptions may not be working properly with SSRS.
So, if I can't put anything other than this in my query string;
<Query>
<Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems"/>
<SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction>
</Query>
and I only have a couple parameters to pass on top of that, then it appears to me that my options for filtering the amount of data returned from the SharePoint list is to figure out a way to do it with expressions in the parameters or in the report itself. Am I missing something? Is this really all I get to work with out-of-the-box?
More to come...
==================================
Installation steps taken to build the server VM:
==================================
(Using VirtualPC 2007)
1. Build OS (2003R2SP2) and promote to DC
1a. Create domain user service account SQLSPS
2. Prep for SQL
2a. Install ASP.NET, IIS (www) and .NET 2.0
3. Install SQL/SSRS 2005 Std
3a. Verify SSRS works
3b. RS config tool shows SP integration as blue exclamation
3c. Use service account SQLSPS for anything requiring Windows credentials
4. Install SQL2005 SP2
4a. Verify SSRS works
4b. RS config tool shows SP integration as blue exclamation
5. Prep for SharePoint
5a. Install .NET 3.0
6. Install MOSS2007 Enterprise and configure
6a. Webapps, SSP and anything else use svc acct SQLSPS
6b. Move Default website to port 8080 and re-activate (SharePoint stopped the site)
6c. Verify SSRS works on 8080
7. Install Reporting Services Add-in
8. Create new RS database in integration mode (with service credentials)
8a. RS config tool shows SP integration as red x
9. SP central admin /application management / manage integration settings
9a. reports server = http://srv1:8080/reportserver (since default port has been moved to 8080)
10. SP central admin /application management/grant database access
10a. using the FQDN, confirm servername and default instance - click OK
10b. Prompted for an account to use to retrieve information; svc acct SQLSPS did not work, domain admin did though
11. SP central admin / application management/set server defaults
11a. Accepted all defaults
12. Verify reportserver answers at http://srv1:8080/reportserver (via reportserver AppPool and DefaultAppPool)
13. Changed the application pool identity for the ReportServer AppPool from Network Service to the domain user service account I used for all SQL and SharePoint configurations (SQLSPS) and rebooted. The red x for sharepoint integration in the RS configuration tool is now a green checkmark.
View 7 Replies
View Related
Nov 9, 2006
InfoPath 2003
I have an Infopath form to edit the values in the NotifyMembers table. I want to list the email addresses alphabetically when the query returns data to the form. Unfortunately, I use EmailAddressID as an int in the table, so I need to join? the NotifyMember table with the EMailAddress table, which has a column EMail which is the address. Both have EmailAddressID as common fields.
I can't get the Shape command (edit SQL in the Datasource) to be happy with any syntax that I have tried.
For (non-working) example:
select "GroupCode","EmailAddressID","DelBit" from "dbo"."NotifyMembers" as "NotifyMembers" Join "dbo"."NotifyMembers"."EmailAddressID" On "dbo"."EmailAddress"."EmailAddressID" = "dbo"."NotifyMembers"."EmailAddressID" order by "dbo"."EmailAddress"."Email"
Any help appreciated..
View 1 Replies
View Related
Feb 12, 2007
I created a HelloWorld like example using InforPath 2007 and endpoint with SQL Server 2005. Very simple example.
I created a stored procedure that took in one parameter, a datetime field. This parameter is then inserted into a db table that has two columns, an id column and a datetime column.
I took the store procedure just discribed to create an endpoint. Cool. The WSDL is showing, I'm feeling good.
I go to InfoPath and make it so that submit a datetime to the webmethod associated with the endpoint. The data table shows one more row has been added and it is the datetime I sent from InfoPath. YEA!! I go to the Event View and see that I have an error message. The message is HTTP authenticaiton failed. [CLIENT: 10.8.2.26]. Bummer!!
This does not make sense to me. I am able to update the targeted database table but I get an exception. I do not like exceptions nor warnings without an explanation. Does anyone have an idea why this is happening?
The endpoint code looks like: <code snippet>
CREATE ENDPOINT [GeraldTesting_endpoint]
AUTHORIZATION
STATE=STARTED
AS HTTP (PATH=N'/testEndPoint',
PORTS = (CLEAR),
AUTHENTICATION = (INTEGRATED),
SITE=N'*',
CLEAR_PORT = 8080,
COMPRESSION=DISABLED)
FOR SOAP (
WEBMETHOD 'testEndPoint'
( NAME=N'[geraldstest].[dbo].[Gerald_Test_Proc]'
, SCHEMA=STANDARD,
FORMAT=ALL_RESULTS),
BATCHES=ENABLED, WSDL=N'[master].[sys].[sp_http_generate_wsdl_defaultcomplexorsimple]',
SESSIONS=DISABLED, SESSION_TIMEOUT=60,
DATABASE=N'geraldstest', NAMESPACE=N'http://tempuri.org', SCHEMA=STANDARD, CHARACTER_SET=XML)
</code snippet>
I had to give up for the project I am currently working because of time constraints. But in the future, for out-of-the-box functionality for proof-of-concept/prototyping, I would like to use endpoints.
View 3 Replies
View Related
Aug 15, 2007
Anyone ever heard of or use this, and how does it talk to sql server?
View 14 Replies
View Related
Jun 16, 2006
Hi all, we have a SQL 2000 database which is for recording job information. we are trying to do a sharepoint page that will show all outstanding jobs with conditionl formating to hilight overdue jobs red. we have managed to do this by date with no problem but we are unable to do this by time.
We have created a view that sharepoint looks at for the needed fields. the job due time field only has the time entered in which means the default date of 01/01/1900 gets entered by the system.
we need away that the only the time is outputted in the sharepoint view and a way to apply conditional formatting to this field in sharepoint and a way to compare the this time to the current system time.
I hope this makes sense, as we are complete novices when it comes to SQL. Please ask if you need any more information.
Any help or a point in the right direction would be deeply appriciated.
View 1 Replies
View Related
Jan 22, 2007
Sharepoint Server Portal 2007, MSSQL 2005, Reporting Services
When I try to integrate Reporting Services in Adminitsrator, for url of RS I write this: http://servername/ReportServer/ and click OK.
But when I try to go to 'Set Server defaults' or 'Managed Shared Shedules' I get this:
Server was unable to process request. ---> Client found response content type of '', but expected 'text/xml'. The request failed with an empty responseWhat should I Do ?
View 1 Replies
View Related
Dec 11, 2006
Hi,
I had already setup a SharePoint 2007 Server with a SQL Server 2005 in the same machine.
I cloned the full computer and now my SharePoint clone is pointed to use the old SQL
Server.
How I change my cloned SharePoint to use my cloned SQL Server?
The old configuration diagram
OLD_COMPUTER - SharePont 2007 --> (pointed to) OLD_COMPUTER SQL Server
OLD_COMPUTER - SQL Server
The actual configuration diagram
NEW_COMPUTER - SharePont 2007 --> (now pointed to) OLD_COMPUTER SQL Server
NEW_COMPUTER - SQL Server
The desired configuration diagram
NEW_COMPUTER - SharePont 2007 --> (pointed to) NEW_COMPUTER SQL Server
NEW_COMPUTER - SQL Server
View 1 Replies
View Related
Feb 7, 2007
I originally installed SQL Server 2005 and configured Reporting Services to run on a different port and website and all worked fine. I can access it via localhost:15540/reportserver and also use BI Development Studio to creat and publish reports.
I updated to SQL Server 2005 SP2, selected SQL Server integration on Reporting Services Configurator, created a new Report servcies database. Now when I go to localhost:15540/reportserver, the reports I had previously had available do not show... that may be ok?
However, I go to Sharepoint 3.0 Central Admin, no entry for Reporting Services show under App Management. Should it?
I also notice that link localhost:15540/reports no longer work... Where should I be able to go to get access to the same functionality.
I guess I am a little confused as to what the integrated mode should do for me. All I really wanted the capability to do was use the report viewer from inside sharepoint.
Thanks so much for any help
View 5 Replies
View Related
Aug 30, 2007
hey guys, have a problem with installing the sharepoint 2007 add in for Reporting services.
It goes through the install and ends with that the install was interrupted. The error is
SSRSCustomActionError: SharePoint is installed, but not configured.
I have looked this up on the net, but havn't found any answers. I have made sure the site collection admin is the same as the user trying to install the add-in, but it just keeps failing.
I have reporting services on 1 machine and moss 2007 on a different server,
it is a clean install of moss 2007 and is fully configured and operational.
the inetpub directory is on the D: instead of the C:.. dont think this would be an issue
does anyone have any ideas on why this is happening and what i can do to fix it.
many many thanks to anyone who can help me.
Scotty
View 3 Replies
View Related
Sep 12, 2006
I have been trying to install SRS to a machine that has Sharepoint already installed on it. I have gone through this article:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_9fdy.asp
I used the rsactivate tool and it said the command completed successfully. I tried to verify that everything was setup by going to the site http://localhost/reportserver and I get this error:
Server Error in '/ReportServer' Application.
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: File or assembly name Microsoft.BusinessFramework, or one of its dependencies, was not found.
Source Error:
Line 73: <add name="WindowsAuthentication" type="System.Web.Security.WindowsAuthenticationModule" />
Line 74: <!--<add name="Session" type="System.Web.SessionState.SessionStateModule"/>-->
Line 75: <add name="EnterpriseInitializationModule" type="Microsoft.BusinessFramework.Security.EnterpriseInitializationModule,Microsoft.BusinessFramework" />
Line 76: <add name="Session" type="System.Web.SessionState.SessionStateModule" />
Line 77: </httpModules>
Source File: c:inetpubwwwrootweb.config Line: 75
Assembly Load Trace: The following information can be helpful to determine why the assembly 'Microsoft.BusinessFramework' could not be loaded.
=== Pre-bind state information ===
LOG: DisplayName = Microsoft.BusinessFramework
(Partial)
LOG: Appbase = file:///D:/Program Files/SRS/MSSQL/Reporting Services/ReportServer
LOG: Initial PrivatePath = bin
Calling assembly : (Unknown).
===
LOG: Policy not being applied to reference at this time (private, custom, partial, or location-based assembly bind).
LOG: Post-policy reference: Microsoft.BusinessFramework
LOG: Attempting download of new URL file:///c:/windows/microsoft.net/framework/v1.1.4322/Temporary ASP.NET Files/reportserver/00b4b1a7/c716c103/Microsoft.BusinessFramework.DLL.
LOG: Attempting download of new URL file:///c:/windows/microsoft.net/framework/v1.1.4322/Temporary ASP.NET Files/reportserver/00b4b1a7/c716c103/Microsoft.BusinessFramework/Microsoft.BusinessFramework.DLL.
LOG: Attempting download of new URL file:///D:/Program Files/SRS/MSSQL/Reporting Services/ReportServer/bin/Microsoft.BusinessFramework.DLL.
LOG: Attempting download of new URL file:///D:/Program Files/SRS/MSSQL/Reporting Services/ReportServer/bin/Microsoft.BusinessFramework/Microsoft.BusinessFramework.DLL.
LOG: Attempting download of new URL file:///c:/windows/microsoft.net/framework/v1.1.4322/Temporary ASP.NET Files/reportserver/00b4b1a7/c716c103/Microsoft.BusinessFramework.EXE.
LOG: Attempting download of new URL file:///c:/windows/microsoft.net/framework/v1.1.4322/Temporary ASP.NET Files/reportserver/00b4b1a7/c716c103/Microsoft.BusinessFramework/Microsoft.BusinessFramework.EXE.
LOG: Attempting download of new URL file:///D:/Program Files/SRS/MSSQL/Reporting Services/ReportServer/bin/Microsoft.BusinessFramework.EXE.
LOG: Attempting download of new URL file:///D:/Program Files/SRS/MSSQL/Reporting Services/ReportServer/bin/Microsoft.BusinessFramework/Microsoft.BusinessFramework.EXE.
Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300
So, I added the dll to the bin directory inside ReportServer...I get this error:
Server Error in '/ReportServer' Application.
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Required permissions cannot be acquired.
Source Error:
Line 73: <add name="WindowsAuthentication" type="System.Web.Security.WindowsAuthenticationModule" />
Line 74: <add name="Session" type="System.Web.SessionState.SessionStateModule"/>
Line 75: <add name="EnterpriseInitializationModule" type="Microsoft.BusinessFramework.Security.EnterpriseInitializationModule,Microsoft.BusinessFramework" />
Line 76: </httpModules>
Line 77: <globalization fileEncoding="utf-8" />
Source File: c:inetpubwwwrootweb.config Line: 75
Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300
So, I added code groups to the .Net 1.1 security configuration...the same error is displayed. If I comment out the offending http module in the sharepoint web.config, it all runs. However, this is not acceptable because it seems to affect my Business Portal site.
Anyone know how to solve this?
Thanks,
Tom
View 2 Replies
View Related
Mar 1, 2007
Hi all,
I've tried 3 times to integrate RS in Sharepoint and I always have the same result. I can't see the new section in sharepoint central administration under application management. I didn't get any errors while installing any of the components.
RS and Sharepoint are on the same machine and I carefully followed the step to integrate RS in Sharepoint
Can someone help me on this?
thx
Fred
View 11 Replies
View Related
Apr 14, 2008
It looks like I'll be assigned with development and database management utilizing Microsoft Office Sharepoint Services and saw that there are some issues as it can become quite unwieldy.
I was wondering what difficulties to expect from MOSS and/or Sharepoint in terms of managing and backing up. Any tips or suggestions?
View 2 Replies
View Related
Jun 12, 2008
I know this is not SQL server related. Do anyone know good Third-party tools to backup sharepoint 2007? I have looked at www.avepoint.com and ideras tools but didn't find price listings. I am looking which has reasonable price and efficient.
Only xpurt ownly
View 4 Replies
View Related
Dec 22, 2005
Hi, I'm new to the forum and also to SQL Server.
Has anybody implemented SharePoint Windows Services on top of SQL Express? I'm trying just that, but i'm encountering some problems when trying to enable Full-Text search. The configuration page for this option says that the database i'm running on does not support full-text search.
Thanks in advance,
Ulises
View 4 Replies
View Related
Jan 9, 2008
I found out the battery in my UPS isn't working anymore. My server down a couple of times with power outages before I figured out it wasn't doing its job.
I make backups of my Sharepoint databases using the gui interface in Sharepoint, so I have backups and have used them for a couple of the outages.
What I was wondering (I'm a newb to SQL), if I do a checkdb and get no errors when the databases (sharepoint_config and sharepoint_data) are marked suspect, is there an easy way to get them back online without using the backups. The only reason I ask, there is data entered in the 23hrs (daily backups) since the last backup that I wouldn't mind keeping.
Also, I seem to have gotten (from reading some of the posts here) my sharepoint_config stuck in emergency mode and can't find a post on how to get it back to normal/online mode ;)
-Sony
View 1 Replies
View Related
Mar 28, 2008
Hi All,
i have written so many queries in sql 2000/2005 and now i have to integrate them into sharepoint which i have never done..can anyone guide me how it can be done? or where i have to post this question?
the correct forum?
any help would be appreciated.
thanks
View 1 Replies
View Related
Feb 6, 2007
Hello,
Sorry for the newbie question...
Is there a way to "serve" up reports in a SharePoint-like way without using SharePoint?
I am part of a team of ASP.NET developers that are writing our own pages, but I haven't been able to find information about Reporting Services 2005 in ASP.NET and/or using Web Parts on our own pages.
Any information about this would be greatly appreciated.
Thank you.
-Gumbatman
View 3 Replies
View Related
May 15, 2006
Hi,
I'm trying to get data from WSS lists by web services. I think there are two ways:
- using SSIS standard components (Web Service Task) and
- creating a custom source adapter.
My problem with the Web Service Task is, that the WSS method GetListItems has some non-standard parameters (see part from wsdl-file below). Thus, after selecting the method in the editor an clicking on "Ok", I get the error message "The selected Web method contains unsupported arguments". I think the problem is the missing type-attribute.
<s:element name="GetListItems">
<s:complexType>
<s:sequence>
<s:element minOccurs="0" maxOccurs="1" name="listName" type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="viewName" type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="query">
<s:complexType mixed="true">
<s:sequence>
<s:any />
</s:sequence>
</s:complexType>
</s:element>
...
My question: Is there a way to extend the Task to handle such parameters?
View 1 Replies
View Related
Feb 20, 2007
Hi,
I'm having troubles connecting the webparts on SharePoint 2007. I installed the RSWebParts package from SQL Server 2005 Reporting Services on my MOSS 2007 box. The installation went smoothly and I can add both Report Explorer and Report Viewer on a page. But when I try to connect RE to RV I get the following error:
An unexpected error has occurred.
Web Parts Maintenance Page: If you have permission, you can use this page to temporarily close Web Parts or remove personal settings. For more information, contact your site administrator.
So I have to go to the maintenance page and remove the web parts.
Have anyone managed to bypass this and make them work together?
Thanks,
View 1 Replies
View Related
