Mirroring With MOSS 2007

Oct 31, 2007





Is anyone attempting or has anyone successfully deployed MOSS2007 with a SQL 2005 Database Mirror on the backend? We are doing it in our lab with the automatic failover (principal, mirror & witness) and the SQL portion works great. The only issue is we have is that we have to manually switch MOSS over (via Sharepoint 3.0 Central Admin or stsadm) to the new content database on the other server. Thank you


We have reviewed the White Paper that Microsoft offered with no help to our issue.

View 1 Replies


ADVERTISEMENT

Deploying Reports To MOSS 2007

Dec 22, 2006

Hello,

I wonder if anyone can help me save the few remaining hairs on my head? I am trying to deploy reports created in SQL Server Business Intelligence Development Studio to SharePoint running SQL Server 2005 Reporting Services in SharePoint integrated mode. Whenever I try to deploy a report, the Reporting Services Login window pops up no matter which user/password I provide it won't accept any. I have the Reporting Services database set up to use Windows credentials and my Domain adminstrator account so I presume that this is user that I should be providing when prompted when deploying.

Can anyone give me any clues?

Thanks,

Michael

View 3 Replies View Related

Reporting From MOSS 2007 List Returning 1;#

Apr 22, 2008



Hi,

We are reporting from a custom list in MOSS 2007 using SSRS. When we try to report on a set of data from the list we receive 1;# in front of the returned data in SQL. How do i get rid of this or stop it from showing?


Thanks in advance.

View 1 Replies View Related

Cannot View Reports With Moss 2007 Installed On Same Site

Dec 10, 2007



hello when i try to view reports in reports manage i get the following error

The type Microsoft.SharePoint.Portal.Analytics.UI.ReportViewerMessages, Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c does not implement IReportViewerMessages or could not be found
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Microsoft.Reporting.WebForms.InvalidConfigFileTypeException: The type Microsoft.SharePoint.Portal.Analytics.UI.ReportViewerMessages, Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c does not implement IReportViewerMessages or could not be found

Source Error:





The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:

1. Add a "Debug=true" directive at the top of the file that generated the error. Example:

<%@ Page Language="C#" Debug="true" %>

or:

2) Add the following section to the configuration file of your application:

<configuration>
<system.web>
<compilation debug="true"/>
</system.web>
</configuration>

Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.

Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.
Stack Trace:





[InvalidConfigFileTypeException: The type Microsoft.SharePoint.Portal.Analytics.UI.ReportViewerMessages, Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c does not implement IReportViewerMessages or could not be found]
Microsoft.Reporting.WebForms.ConfigFilePropertyInterface`1.EnsurePropertyLoaded() +212
Microsoft.Reporting.WebForms.ConfigFilePropertyInterface`1.GetInstance() +17
Microsoft.Reporting.WebForms.LocalizationHelper.Microsoft.Reporting.WebForms.IReportViewerMessages.get_ProgressText() +42
Microsoft.Reporting.WebForms.WaitControl.CreateChildControls() +210
System.Web.UI.Control.EnsureChildControls() +87
System.Web.UI.Control.PreRenderRecursiveInternal() +50
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +7248
System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +213
System.Web.UI.Page.ProcessRequest() +86
System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) +18
System.Web.UI.Page.ProcessRequest(HttpContext context) +49
ASP.pages_report_aspx.ProcessRequest(HttpContext context) +4
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +358
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64




Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433

View 3 Replies View Related

Problem Integrating Reporting Services In MOSS 2007

Aug 30, 2007



Hi all!

I am experiencing a problem integrating Reporting Services in MOSS 2007.


I tell you:

When i am in Reporting Services -> Aplications Administration, i click to set the default server settings and this error appears (it's in spanish, i try to translate below)


Error inesperado durante la conexión al servidor de informes. Compruebe que el servidor de informes está disponible y configurado para el modo integrado de SharePoint. --> El servidor no puede procesar la solicitud. ---> El cliente encontró el tipo de contenido de respuesta 'text/html; charset=utf-8', pero se esperaba 'text/xml'.
Error de la solicitud con el mensaje de error:

Unexpected error while conecting to the report server. Check that the server is online and configured for the integrated Sharepoint mode. --> Server can precess the request ---> The client found the content response type 'text/html; charset=utf-8', but expected 'text/xml'.


I have watched into the report server, and it appears as integrated in Sharepoint.

If someone knows how to fix this, it would be very helpful.

Thanks all.
Urko

View 1 Replies View Related

Cannot View SSRS Reports On Internet In MOSS 2007

May 8, 2008

Hi All,

I am having multiple URL in multiple zones for my site.I am not able to view SSRS reports on Internet which is in Internet zone where as i can view the same reports on Intranet site having URL in default zone.
I m getting the following Error while accessing reports over internet:

" Unable to connect to the remote server.No connection to be made because target machine actively refused."

It would be great help if any one can solve this problem.

Thanks in Advance.

View 2 Replies View Related

Urgent SSRS Web Part + MOSS 2007 Question

Oct 2, 2007



I have a masterpage that has no doctype, because I want to have a table with some fixed height TDs and some variable height TDs (this kind of table only seems to be possible in quirks mode, with no doctype). My problem is the SSRS web part, it has the web part title, but the actual report is not there! as soon as i put in the doctype, it renders normally.

Is there any way to have a reporting services web part render a report without a doctype?

View 4 Replies View Related

SSRS 2005 + MOSS 2007 Port Conflict

Apr 12, 2007

hello

we have Reporting services and Office Sharepoint on the same server, but the reporting services website is on default website and won't start because MOSS is already using the port.
can i just change SSRS website port ?

thanks

View 3 Replies View Related

SQL 2005 Reporting Services SP2 Integration With MOSS 2007 SSL Error

Feb 27, 2007

Hi,

I have just installed RS and SP2 on a server running a MOSS 2007 (with SSL using an internal certificate) and configured RS to work on Sharepoint Integrated Mode. Then I went to Sharepoint to configure RS options, but when I tried to set up the Set Servers Defaults I receive the following error:

An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> Server was unable to process request. ---> The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ---> The remote certificate is invalid according to the validation procedure.

Also, when I try to deploy a report from SQL BI Development Studio to Sharepoint, I receive the error:

A connection could not be made to the report server https://myserver.mycompany.com.br/Reports/Site. (Microsoft Report Designer)

Server was unable to process request. ---> The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ---> The remote certificate is invalid according to the validation procedure. (System.Web.Services)

Can anyone help me?

View 1 Replies View Related

Request For The Permission Of Type 'System.Data.SqlClient.SqlClientPermission' Failed In MOSS 2007

Dec 6, 2007



Hi,

I have created a web part in ASP.Net. this web part is extracting data from the sql server database and displaying it on the web part page.
This web part is working fine with asp.net application, but when i deploy it with MOSS. it is reaising security exception error like.

Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

I have made the entry under the safe control list of web.config file. but still i am getting error any suggestion wud be highly appreciable..

pls reply me on sanjiv.singh@kpitcummins.com.

thanks you so much.

Regards,
Sanjiv Singh

View 5 Replies View Related

Sharepoint 2007 &&amp; DB Mirroring

May 8, 2007

I am trying to work through a test on database mirroring I am following the whitepaper that Micrososft published on how to configure mirroring and sahrepoint, but when i failover the config database and admin content database it doesnt appear to work. I execute the following commands after both are failed over

----

stsadm.exe -o renameserver -oldservername <OldPrincipalServer> -newservername <NewPrincipalServer>

iisreset

----

It doesnt work it get the following error.

Unable to connect to database. Check database connection information and make sure the database server is running.

When i bring the admin content databse back to the original principle the admin site works great.

What am I missing?

View 3 Replies View Related

SQL 2005 Mirroring With Sharepoint 2007

Dec 7, 2006

Hi, iam from Mexico,
somebody has installed SQL 2005 with mirroring and sharepoint 2007?
regards.
thanks

View 9 Replies View Related

How To Get Receipients Email Address In Access 2007 Table From Outlook 2007 Using VBA?

Mar 3, 2008

Hi
everybody.
I am new to VBA,.,, I Have created a folder under inbox in Outlook 2007 which stored the receipients information
like name, E-mail, which is not present in the address book of outlook.
I have imported this folder in access 2007. My problem is ... it does not display the email address.
Rest of the informations is displayed... Is there any way i could do this.??
is there any way i could get the email addresses to appear(import/get) in to the access table???
Is there any module i mite have to create??

Plz help...
thanks a million

View 1 Replies View Related

SRS And MOSS

Dec 18, 2007

Hi there-
I want to see the reports developed in SQL reporting Services from Share point Server 2007. I see two methods to do this and would like to know the advantages / disadvantages between these two methods.
1) Configure Report Server to run in Share Point Integration mode and deploy the SQL reporting services reports directly in the Share point site.
2) Configure Report Server to run in Native mode and deploy the SQL reporting services reports in a web site. Just add the link for these reports in the Share point Site.
Thanks in Advance.

View 1 Replies View Related

Database Mirroring | Can Witness Live On Mirroring Server?

May 3, 2008



Server A = primary SQL DBs (mirroring origination)
Server B = failover SQL DBs (mirroring destination)

For database mirroring a witness is required.
Can the witness live in another instance of SQL on server B?

View 7 Replies View Related

MOSS Collation Question

Feb 14, 2008

Hey guys,
I am working on the database side of an upgrade for our Sharepoint site to MOSS 2007. The current environment is SQL Server 2005 (SP2) clustered (8 dual core CPUs, 32GB RAM) with about 0.75 TB of data (about 10 different dbs). I noticed that the collation on the sharepoint databases are not the same as the system databases and other user databases.

The collation setting for our current Sharepoint is:
Latin1_General_CI_AS_KS_WS

The collation setting for MOSS is:
Latin1_General_CI_AS_KS_WS

The collation setting for our system databases is:
SQL_Latin1_General_CP1_CI_AS

The collation setting for the server is:
SQL_Latin1_General_CP1_CI_AS

I am aware of the following issues with having different collation settings between user databases and system databases.
http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/07/12/883.aspx

http://support.microsoft.com/kb/843578

Currently nothing is broken, everything is working fine; So my question is:
What does best practices suggest I do in this situation?
Do I leave everything as is? Do I change the server collation and system databases?

Any suggestions and feedback will help.
Thanks,
Reghardt

View 3 Replies View Related

SRS Integrated With MOSS, Want Subscriptions

Aug 14, 2007

We have 64 bit MOSS with integrated SRS. This works quite well. You lose data-driven subscriptions until the release of SQL 2008. We want to build a custom subscription/workflow solution that renders reports and pops them into SharePoint lists. What we want to do is render thousands of reports into SharePoint document libraries and use workflow rules to route them to file shares, emails, approvals, etc.

This can be done manaully by right clicking the RDL in a report library and selecting Manage Subscriptions. This brings up a web page listing existing subscriptions (_layouts/ReportServer/ManageSubscriptions.aspx). This page does not write to a SharePoint list, but a set of tables in the ReportServerIntegrated database. I can see the tables and stored procedures that do the work. I cannot find a programming interface to create the subscriptions in code. I guess I can just call these stored procedures.

Has anyone played with this?

View 1 Replies View Related

Reporting Services/MOSS

Feb 26, 2008

I also posted in the SharePoint forum, but maybe someone here can shed some light on this frustrating issue:

We have Reporting Services integrated with our MOSS environment. Several reports were set up for autmatic delivery via subscription. This was pre SP1 times and the reports ran just fine (they are not data driven reports). Whether it is related or not I don't know, but two weeks ago we upgraded to SP1 without any problems. Shortly after that, our users stopped getting their reports via email. When I go to the reports and click on "Manage Subscriptions", the history of subscriptions shows that the report ran, but then there is an error message under last results saying

"The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)"

I tried recreating reports, setting up new data connections, re-subscribing... nothing works. Checked SQL server logs - they seem to be OK; checked SharePoint logs - they show error with few minutes off the scheduled report, so I don't know if this is related, but here it is nevertheless:

"Unexpected query execution failure, error code 282. Additional error information from SQL Server is included below. "The 'proc_GetTpWebMetaDataAndListMetaData' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead." Query text (if available): "{?=call proc_GetTpWebMetaDataAndListMetaData(?,'1F57DB6C-AF94-4557-866D-4214D9EC8313',?,NULL,1,?,?,6187)}" "

Any ideas what went wrong or how to fix this? Does this have anything to do with .Net service packs that we installed about the same time as SP1 implementation?

Thank you in advance for any ideas!!

View 1 Replies View Related

Failed To Jump To URL Contains MOSS Server Name

Dec 17, 2007



Hi all,

It would be much appreciated if any expert would have any suggestion.

I use reporting service with SP2 and integrated with MOSS 2007 platform.

I found I couldn't jump to a URL while the URL contains my MOSS server name on it.

For example, I simplely put http://mymoss/mysite on the "Jump to URL" property on my report, and it works fine while I read it on BI Development Studio, but it failed after I deploye it on my MOSS server.

I cannot click the item contains this hyperlink.

Although I could use below java script to open the same URL. ( Type below script on the Jump to URL property "javascript:void(window.open( 'http://mymoss/mysite', '_blank'))")

But the problem is that the URL I used is the link to MOSS's list with a very long path, so the jave script will be truncated after about 128 character length.

It's really strange that I couldn't open the URL contains the MOSS server name directly from the report on this MOSS server.

Your suggetion or solution will be very important to me.

Thanks,
Steve 2007/12/17

View 1 Replies View Related

MOSS And SSRS Integration Problem

Sep 27, 2007



Hi all,

We're currently having a great deal of difficulty getting our MOSS/SSRS integration configured. In short, we're getting "A connection to the computer cannot be established." message in the Grant Database Access page of the Reporting Services Integration settings.

A few more points:


We have two servers:


Server A: Win2K3 EE SP2, MOSS 2007, SSRS Integration Components

Server B: Win2K3 EE SP2, SQL Server 2005 SP2, MOSS database, SSRS, WSS 3.0, SSRS Integration Components
A user in IE on Server A can successfully browse to the ReportServer virtual directory on Server B.

Another "test" MOSS server has been configured separately and successfully against Server B, so it seems like there's something amiss with Server A. The report server configuation tool shows all green. There are no entries in the App or System log that appear related to this issue. We've looked at KB's 871179 and 896861; no luck there.

We've tried both Windows Authentication and Trusted Connection with a number of different accounts, including a domain admin. No luck.

The error is really irritating, considering it gives no additional information, logging, or context.

Can anyone shed some additional light here?

Thanks,

Dave

View 3 Replies View Related

ReportViewer Control And MOSS Reporting Services

Mar 10, 2008



I am trying to use a reportviewer control (processing mode = remote) to view a rdl that is hosted on a server running MOSS, the reporting services are run in "sharepoint integrated mode". When i try to set the path to the RDL on the control like i usually do for an ASP.NET ReportViewer control, i get the error message posted below. I cant find anything on google, Please HELP


Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <HTML dir="ltr"> <HEAD><meta name="GENERATOR" content="Microsoft SharePoint" /><meta name="progid" content="SharePoint.WebPartPage.Document" /><meta HTTP-EQUIV="Content-Type" content="text/html; charset=utf-8" /><meta HTTP-EQUIV="Expires" content="0" /><meta name="ROBOTS" content="NOHTMLINDEX" /><title> Error </title><link rel="stylesheet" type="text/css" href="/_layouts/1033/styles/core.css?rev=5msmprmeONfN6lJ3wtbAlA%3D%3D"/> <script type="text/javascript" language="javascript" src="/_layouts/1033/init.js?rev=VhAxGc3rkK79RM90tibDzw%3D%3D"></script> <script type="text/javascript" language="javascript" src="/_layouts/1033/core.js?rev=F8pbQQxa4zefcW%2BW9E5g8w%3D%3D"></script> <meta name="Robots" content="NOINDEX " /> <meta name="SharePointError" content=""/> </HEAD> <BODY scroll="yes" onload="javascript:if (typeof(_spBodyOnLoadWrapper) != 'undefined') _spBodyOnLoadWrapper();"> <form name="aspnetForm" method="post" action="../../_layouts/error.aspx" id="aspnetForm" onsubmit="return _spFormOnSubmitWrapper();"> <div> <input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwUKLTU2NjkxODU3M2RkBsUItbjjuHbcaHeDmf91mLp59DY=" /> </div> <TABLE class="ms-main" CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH="100%" HEIGHT="100%"> <tr><td> <table CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH="100%"> <tr> <td colspan=4 class="ms-globalbreadcrumb" align="right"> <a href="javascript:TopHelpButtonClick('NavBarHelpHome')" id="ctl00_PlaceHolderGlobalNavigation_TopHelpLink" AccessKey="6" title="Help (new window)"><img src="/_layouts/images/helpicon.gif" align="absmiddle" border="0" alt="Help (new window)" /></a> </td> </tr> </table> </td></tr> <tr> <td class="ms-globalTitleArea"> <table width=100% cellpadding=0 cellspacing=0 border=0> <tr> <td id="GlobalTitleAreaImage" class="ms-titleimagearea"><img id="onetidHeadbnnr0" src="/_layouts/images/titlegraphic.gif" alt="" /></td> <td class="ms-sitetitle" width=100%> </td> <td style="padding-top:8px;" valign=top> </td> </tr> </table> </td> </tr> <TR> <TD id="onetIdTopNavBarContainer" WIDTH=100% class="ms-bannerContainer"> </TD> </TR> <TR height="100%"><TD><TABLE width="100%" height="100%" cellspacing="0" cellpadding="0"> <tr> <td class="ms-titlearealeft" id="TitleAreaImageCell" valign="middle" nowrap><div style="height:100%" class="ms-titleareaframe"></div></td> <td class="ms-titleareaframe" id="TitleAreaFrameClass"> <table cellpadding=0 height=100% width=100% cellspacing=0> <tr><td class="ms-areaseparatorleft"><IMG SRC="/_layouts/images/blank.gif" width=1 height=1 alt=""></td></tr> </table> </td> <td valign=top id="onetidPageTitleAreaFrame" class='ms-areaseparator' nowrap width="100%"> <table id="onetidPageTitleAreaTable" cellpadding=0 cellspacing=0 width=100% border="0"> <tr> <td valign="top" class="ms-titlearea"> <a href="http://xjthdqdwd03:8080/bi" id="ctl00_PlaceHolderTitleBreadcrumb_idSimpleGoBackToHome">Go back to site</a> </td> </tr> <tr> <td height=100% valign=top ID=onetidPageTitle class="ms-pagetitle"> <h2 class="ms-pagetitle"> Error </h2> </td> </tr> </table> </td> <td class="ms-titlearearight"> <div class='ms-areaseparatorright'><IMG SRC="/_layouts/images/blank.gif" width=8 height=100% alt=""></div> </td> </tr> <TR> <TD class="ms-leftareacell" valign=top height=100% id="LeftNavigationAreaCell"> <table class=ms-nav width=100% height=100% cellpadding=0 cellspacing=0> <tr> <td> <TABLE height="100%" class=ms-navframe CELLPADDING=0 CELLSPACING=0 border="0"> <tr valign="top"> <td width="4px"><IMG SRC="/_layouts/images/blank.gif" width=4 height=1 alt=""></td> <td valign="top" width="100%"> </td> </tr> <tr><td colspan=2><IMG SRC="/_layouts/images/blank.gif" width=138 height=1 alt=""></td></tr> </TABLE> </td> <td></td> </tr> </table> </TD> <td> <div class='ms-areaseparatorleft'><IMG SRC="/_layouts/images/blank.gif" width=8 height=100% alt=""></div> </td> <td class='ms-formareaframe' valign="top"> <TABLE width="100%" border="0" cellspacing="0" cellpadding="0" class="ms-propertysheet"> <TR valign="top" > <TD class="ms-descriptiontext" width="100%"> </TD> <TD ID=onetidYPadding width="10px"><IMG SRC="/_layouts/images/blank.gif" width=10 height=1 alt=""></TD> </TR> <TR > <TD ID=onetidMainBodyPadding height="8px"><IMG SRC="/_layouts/images/blank.gif" width=1 height=8 alt=""></TD> </TR> <tr> <td valign="top" height="100%"> <A name="mainContent"></A> <table width=100% border=0 class="ms-titleareaframe" cellpadding=0> <TR> <TD valign=top width="100%" style="padding-top: 10px" class="ms-descriptiontext"> <span id="ctl00_PlaceHolderMain_LabelMessage">The file you are attempting to save or retrieve has been blocked from this Web site by the server administrators.</span> <P><span class="ms-descriptiontext"> <span id="ctl00_PlaceHolderMain_helptopic_troubleshooting"><A Title="Troubleshoot issues with Windows SharePoint Services. - Opens in new window" HREF="javascript:HelpWindowKey('troubleshooting')">Troubleshoot issues with Windows SharePoint Services.</A></span> </span> </TD> </TR> </table> <script type="text/javascript" language="JavaScript"> var gearPage = document.getElementById('GearPage'); if(null != gearPage) { gearPage.parentNode.removeChild(gearPage); document.title = "Error"; } </script> </td> </tr> </table> </td> <td class="ms-rightareacell"> <div class='ms-areaseparatorright'><IMG SRC="/_layouts/images/blank.gif" width=8 height=100% alt=""></div> </td> </TR> <tr> <td class="ms-pagebottommarginleft"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td> <td class="ms-pagebottommargin"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td> <td class="ms-bodyareapagemargin"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td> <td class="ms-pagebottommarginright"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td> </tr> </TABLE></TD></TR> </TABLE> <input type="text" name="__spDummyText1" style="display:none;" size=1/> <input type="text" name="__spDummyText2" style="display:none;" size=1/> </form> </BODY> </HTML> --.

View 16 Replies View Related

RS Integrated With MOSS - Internal Error - AdjustTokenPrivileges

Apr 26, 2007

I'm running MOSS 2007 Enterprise, SQL 2005 SP2, RS integrated with MOSS and have a number of reports deployed to a Reports Library in MOSS. 3 out of 10 times I run a report I get a error message stating that 'An internal error occured on the report server.' Just hitting Apply on the parameter panel will fix the problem and render the report as expected.



Previous entries to the forum about this error hints at an error that supposedly was fixed in SP2; since I'm running SP2 something else must be the problem.



Any insight to what might cause the problem ?



Regards,

Trond



Relevant content from the RS error log included below:


04/26/07 11:42:21, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 7008
04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x47405860
04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
04/26/07 11:42:23, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
04/26/07 11:42:23, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesSQLDmpr0147.mdmp
04/26/07 11:42:23, ACTION, w3wp.exe, Watson Invoke: No


w3wp!processing!1!4/26/2007-11:42:21:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.UpdateTimingInformation(RunningJobContext jobContext, Int64 totalDurationMs, Int64 reportDataRetrievalDurationMs, Int64 reportRenderingDurationMs)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension renderer, DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc, CreateReportChunk cacheDataCallback, Boolean& dataCached)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc)
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext reportContext, ItemProperties properties, ParameterInfoCollection effectiveParameters, Guid reportId, ClientRequest session, String description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean cachingRequested, Boolean isLinkedReport, Warning[]& warnings, ReportSnapshot& resultSnapshotData, DateTime& executionDateTime, RuntimeDataSourceInfoCollection& alldataSources, UserProfileState& usedUserProfile)
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext context)
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
System.Web.HttpApplication.ResumeSteps(Exception error)
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)

w3wp!library!1!4/26/2007-11:42:21:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., un-named assertion fired for component processing;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.


View 1 Replies View Related

HTTP:401 Error When Trying To Use Kerberos With SSRS/MOSS

May 21, 2008

Like many others, I am have trouble getting this to work, and none of the solutions I have found on the inter-tubes seems to work for me:

"An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> The request failed with HTTP status 401: Unauthorized."

The Setup:

MOSS/SSRS (Integration Mode) running on a server farm on a single server: myserver.mydomain.org


Service Account for all Services: mydomainmyaccount (trusted for delegation, member of IIS_WPG)
myserver trusted for delegation
SSAS running under Local System on ssas.mydomain.org.


SETSPN -L mydomainmyaccount results:


HTTP/myserver.mydomain.org

HTTP/myserver

MOSS Authentication Settings

Authentication Type = Windows
Default Authentication Provider = Negotiate (Kerberos)
Anonymous access not enabled

IIS Settings


SSRS on Default Web Site: Port 8080


Application Pool Identity mydomainmyaccount

NTAuthenticationProviders="Negotiate,NTLM"

Security: Windows Authentication

MOSS on Sharepoint-80 Site: Port 80

Application Pool Identity mydomainmyaccount
NTAuthenticationProviders="Negotiate,NTLM"
Security: Basic Authentication except _vti_bin/ReportServer is Windows Authentication
The idea is to use kerberos to pass credentials from SSRS reports running on myserver.mydomain.org to SSAS on ssas.mydomain.org.


View 1 Replies View Related

Using Multiple Report Viewers On MOSS With Common Parameters

May 17, 2007

Hi!

I'm using Reporting Services Integration Mode and I have a page that has a number of report viewer webparts on it to display reports. Is there a way that I can add another webpart to pass parameters to all the reports at once instead of individually? I am trying to build a dashboard and this is one of the requirements. I see on the Report Viewer web part, that there is an option in Connections to 'Get report parameters from' , but it is greyed out. Any ideas on how to do this?



Thanks!

Brian

View 6 Replies View Related

Not Supported Functionality Of SSRS In MOSS (integrated Mode)

Aug 9, 2007



Hello,

does anyone know, when will the functionality of linked reports, my reports, data-driven subscriptions in MOSS integrated mode be enabled? Now it is according to Microsoft not supported. Will this be supported in the future ?Thanks.

View 1 Replies View Related

Cannot View Report With MOSS And SSRS Integrated Mode

May 7, 2008

Hello,


I have configured Reporting services to use MOSS integrated mode. I have two servers, one for MOSS and the other for SQL database and reporting server.


Since I am using NTLM for IIS authentication, I can only use "Trusted Account" for Reporting Service Integration.

Then I created a report in SQL Server BI development studio and deployed to a MOSS document library. The deployment was successful. However, when I tried to open the report, I got the following error message:


An error has occurred during report processing.
This data source is configured to use Windows integrated security. Windows integrated security is either disabled for this report server or your report server is using Trusted Account mode.


I have tried to switch to "Windows Authentication" for Reporting Service Integration, but this will give error for "Set Server Defaults" screen. Also the deployment from BI studio to MOSS will fail with authentication error. So I think I have to stay with "Trusted Account" option there.


What should I do to make the report accessible while using "Trusted Account"? Is there any configuration which has to be done for this purpose? Any input is appreciated.


Thanks,
Jun

View 8 Replies View Related

SSRS Integrated With MOSS Causes Globals!ReportName To Behave Differently

Jun 26, 2007

I have a report where I use Globals!ReportName in the header of the report for the report title. In Development and on SSRS stand alone the value for Globals!ReportName is in mixed case and the file extension is omitted. When the report is published to a MOSS server integrated with SSRS the value for Globals!ReportName is all in lower case and the file extension is included.

Is there any reason for this change in behavior and is there a way I can put back the mixed case and omit the file extension?

View 2 Replies View Related

Mirroring :: Database Mirroring Changes In Application

Oct 12, 2015

Using SQL Server 2008, we would like propose mirroring between two servers of a critical database. Since we initiate, may require to clarify on its purpose and also required changes from application end.Any changes required from OS Level? (I believe both servers IP or Host name should be added in host entries. Mirroring ports should be allowed/open including Principal and mirror server IP Addresses): Windows Team.Any changes required from Application? (Instance name, authentication: user name and its password should be added in web config files): Application Team.Any changes required from Network Team?Also for mirroring both the principal and mirror servers should be with same version, does it only mean SQL Server 2008 versions are enough or does it also mean to say build numbers 10.00.4000 should also be same.URL....

View 5 Replies View Related

Mirroring :: Setting Up Mirroring With Different Vlans?

Sep 15, 2015

I need to set up asyncronous data replication across two clustered instances of SQL 2012 across 2 Datacenters. Both the datacenters have a common domain however the vlans are different. There are only 3 small databases on the primary instance.

any issue in setting up mirroring in this case as vlans are different.

Operating system is Windows 2012.

View 2 Replies View Related

SQL 2007 Error

Feb 20, 2007

Hi everyone,
I am new to SQL Server. I have SQL 2007 installed on win 2003 server, my problem is when I try to start the Sql 2007 server I get the error message "The service control action cannot be completed as no service has been selected"
Thanks in advance
Arunchu from London

View 4 Replies View Related

RS In Sharepoint 2007

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

BCM With Accounting 2007

Feb 1, 2007

I have bcm with outlook 2007 and accounting express. when i create an opportunity in bcm, everything is fine. when i click the convert to quote button, it dumps all of the item information (quantity, name, description, price, tax....) into the description field in accounting. Then I have to copy each piece out of the description field into it's appropriate field in accounting 2007 express. Where is the mapping for these fields, so that I can map each one correctly? Is there something else i should be doing?

View 1 Replies View Related

Vba Access 2007

Mar 12, 2008

I want to user 'acCmdExportFixedFormat' in ms-access to save reports as PDF and XPS.
when i use the code runcommand acCmdExportFixedFormat i have to set manually the filename.
I want to give the filename in my vba code. How do i user this

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved