How To Add Reporting Services In Microsoft Dynamics CRM 3.0

SQL Reporting Services Data Connector For Dynamics CRM 4.0 Issue

I can't find a Dynamics CRM topic and I'm hoping someone here will recognize the problem that we are having with integration between Dynamics and SRS.

Dynamics CRM server deployed fine. But we are having this problem when trying to install the Dynamics SRS Data Connector (an additional component that is supposed to be installed locally on the SRS server):
http://support.microsoft.com/kb/947060/en-us

Trouble is, the SQL server is a default instance, and SRS is hosted on a default web site listening on port 80. In fact, this is just a plain default install of SQL 2005 and SRS 2005 on one server. Nothing has been customized. And yet we get this error when we try to install SRS Data Connector on the local SRS machine:
"Unable to validate SQL Server Reporting Services Report Server installation. Please check that it is correctly installed on the local machine."

But the SRS is installed and running fine! I can even see and run reports that the Dynamics CRM Server install had created on the SRS server! And yet the setup program insists that SRS is not installed and it won't proceed with installation. It obviously runs some strange prerequisite check. (Devs: Why not just run a connect test to the SRS Web service?)

Environment: Win 2003 native domain on server A, Dynamics CRM 4.0 Pro on server B (Win 2003 VM 32bit), SQL 2005 SP2 and SRS 2005 SP2 on server C (Win 2003, physical server, 64bit). Data Connector failing to install on server C. I've even tried using a domain admin account, and went as far as running the installer in SYSTEM context. Still it fails.

I've also tried every variation of SRS and IIS configs that I know of (disabling SSL, enabling anon auth, etc etc etc etc...) I've gone as far as setting up a separate domain, separate SQL and SRS, and making a local Dynamics install, and STILL I got the same error while installing the Data Connector.

This is most frustrating. There's obviously something wrong with the method Dynamics CRM setup program uses to determine whether or not SRS is installed. But how come there isn't any info about this except for that one KB article that doesn't apply to us?

Please if you know anything post a reply! Thanks.

Installing Microsoft Dynamics 10.0 With Microsoft SQL Server 2008 Katmai

Hi,

I'm trying to install Microsoft Dynamics 10.0 with SQL 2008 Dev but when launching the utilities this returns the following error message:

******************************************************************
Your current SQL Server is not a supported version.

Req: Microsoft SQL Server 8.0
Act: Microsoft SQL Server code name "Katmai" (CTP) - 10

You need to upgrade to SQL Server 8.0 before continuing.

******************************************************************

Any ideas could help or has this if anyone knows been desinged not to work with GP10 currently?

Assad

Microsoft Dynamics GP

Hello Guys


can anyone please tell me where can i download a trial version of Microsoft Dynamics GP because i lost my cd , and microsoft.com tells me that the shipping will take about 6 weeks.





thanks in advance

Database Mirror && Microsoft Dynamics GP

Has anyone tried mirroring any of the Dynamics GP databases yet?

I am looking at using this and what to see if anyone has had any problems or even know if it can be done.



Thanks

Analysis :: Excel Freezing When Interacting With Microsoft Dynamics AX Cubes

I am running into a problem where Excel 2010 is freezing when I try to work with data coming from a Microsoft Dynamics AX 2012 R3 pre-built cube.

What is happening is that when I go to add a second dimension to my pivot table, excel locks up and becomes completely unresponsive for at least 2 hours.  If I add the dimension to the table before the measure though, everything is fine.

For Example, I am trying to build a sales report with the product name and customer name as dimensions, and Sales as the measure. If I add the product name to my pivot table as a column and then sales as a measure, Excel will freeze when I try to add the customer dimension. However, if I add both dimensions to the pivot table first and then the measure, Excel seems to work fine.

Business Objects And Microsoft Reporting Services

Hi,I am evaluating Microsoft Reporting Services against Business Objectsas a reporting tool against SQL Server. I am primarily a BOBJdeveloper and am finding RS not easy to use. Can anyone provide anyfeedback to the overall comparison between these 2 products as I amfinding RS frustrating and am wondering if it is just a matter ofre-adjusting and spending more time on it or if anyone else is findingRS more trickey to use than BOBJ as wellI would be extremely grateful for any feedback.Many thanks in advanceLA

How To Use A Variable From The Code On Microsoft Reporting Services 2005

Hi all.

I have a Application developed on VB2005 with the reports (processed local) from Microsoft Reporting Services 2005.

I would like to know how can i use the value of a variable to be displayed on a textbox on my report.

Thanks for the help.

Best regards.

dp

Reporting Services :: Dataset In Microsoft Report With Too Many Columns

I have a dataset with rows that I normally would display in a  table control. I have too many columns and I would like each data row to be display on many lines. How is that possible?

Reporting Services :: Printing Reports With Microsoft Edge

I can't print reports using Microsoft Edge from Windows 10 With IE 11 Works fine.I've tried regsvr32 with rsclientprint64.dll but it's not working.

Microsoft SQL Server 2005 Reporting Services -- Error 1303

I am trying to install Microsoft SQL Server 2005 Reporting Services, Receiving the following error
 
Microsoft SQL Server 2005 Reporting Services -- Error 1303. The installer has insufficient privileges to access this directory: C:Config.Msi.  The installation cannot continue.  Log on as administrator or contact your system administrator.
 
 
I am already logged in as Administrator and should have all the necessary permissions to install software 

Please help me.

Can't Connect To Reporting Services Using Microsoft SQL Server Management Studio

When I try to connect to the Reporting Services using Microsoft SQL Server Management Studio, the following error message propmpts up:

_____________________________________________________________
ADDITIONAL INFORMATION:
The request failed with HTTP status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient)
_____________________________________________________________

Is there any settings that I need to do in the "Reporting Services Configuration Manager" ?

Thanks.

Best regards,

Michael Wu

Cannot Connect To Reporting Services Using Microsoft Sql Server Management Studio.

Hi,

Microsoft SQL Reporting Services - Which Function To Use To Evaluete Null Values?

Report Viewer Issue In Visual Studio 2005 Beta 2. For Microsoft Reporting Services

Hi

Can I Run SQL Server 2008 - Reporting Services CTP Until Microsoft Sells SQL 2008

There are a few features in the new SQL Server - Reporting Services that I really need in production. I have tested everything and it works great. I am running the CTP version since Microsoft is saying they aren't releasing the release version until 3rd quarter 2008.


Since Microsoft won't sell SQL 2008 until 3rd quarter, can I run the CTP in production until the release and then purchase SQL 2008?


Jim

Migrate From 32bit 2000 Reporting Services To 2005 64bit Reporting Services

Hello,

I am trying to migrate my reports from SQL server 2000 reporting services 32bit to 2005 64bit. I am following the migration steps that MS specified.
Restored my Reportserver and ReportserverTempDB databases
Then I was using the configure Report services to upgrade these databases but I always end up getting the follwoing exception when I run the upgrade on the "Database Setup" configuration for 'ReportServerTempDB' database
System.Data.SqlClient.SqlException: Could not locate entry in sysdatabases for database 'ReportServerTempDBTempDB'. No entry found with that name. Make sure that the name is entered correctly.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script)
at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)

It's driving me crazy, why is it looking for 'ReportServerTempDBTempDB' in the catalog instead of 'ReportServerTempDB'?
Is it possible to migrate from 32bit to 64bit?

Any help is appreciated

Compatibility Of SQL Express Reporting Services With SQL 2000 Reporting Services

I'm attempting to obtain a cost effective solution for my existing customers to develop reports on their SQL 2000 Server installations using their Reporting Services 2000. With products like Visual Basic.NET 2003 becoming almost impossible to obtain, I have at least one customer who is running into a dead end.

One option possibly is the SQL Express with Advanced Services download, which has Reporting Services. My questions are as follows:

Can the report designer component of SQL Express Reporting Services be configured to connect to an external database (which would happen to be a SQL 2000 database) to establish its datasets?
Does the resultant designed report end up in an RDL file? If the customer published this report via the Reporting Services 2000 Report Manager, would the report be able to run?

Sorry for asking a question like this that I could probably answer on my own, but my customer needed this answer yesterday. I have scoured the web and microsoft sites - and posted a question on the official SQL Reporting Services cateogy ... in an attempt to answer the basic question of how to design reports for Reporting Services 2000 in the absence of Visual Basic.NET 2003 (or other .NET 2003 tools) with no success.

Thanks to anyone who can help.

-- Mark

Microsoft Reporting Service

I have the following Question:Is it possible to install a Reporting Service at IIS Webserver withoutSQL Server 2000 on the same machine.We have a Enterprise SQL Server at another machine and i don't want toinstall another SQL Server at a IIS.Thank you for all responsesFlecki

Reporting Services :: Localization Data In Reporting Services?

I work in a big project and we will begin in using reporting services as the base technique for reports and I will be responsible for this part. but I have a problem I will discuss in the following:

Currently: We use currently devexpress reports and we have 2 languages(Arabic and English). the data in tables saved in two ways (Arabic and English). when the end user change the language of the web site the report data language changed when run it.

Example:

we have table with (ID, NAME_AR, NAME_EN, JobTitle_AR, JobTitle_EN). designed report will display(ID, NAME_EN, JobTitle_EN) . but the end user change the language of the system the report will

dispaly(ID, NAME_AR, JobTitle_AR) 

Hint:this done pragmatically

how to do this in reporting services.

Microsoft SQL Server 2005 Reporting In Danish

Were can i find Microsoft SQL Server 2005 Reporting on danish???

ReportServer And Dynamics CRM 3.0

hi all

i'm currently installing MS Dynamics CRM 3.0. on the check page before installing is an error:
The Web Site for Installing SQL Server Reporting Services {0} uses an application pool of non-supported identity. Supported identity is Network Service.

so, when i open the properties (tab identity) of the reportserver under application pools in iis manager prefered "Network Service" is choosen, this should by right. do i made any failure? have anyone an idea, tanks

dear
riv

SSRS And Dynamics GP 10.0

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'dsGP10FA'. (rsErrorOpeningConnection)

Setuser failed because of one of the following reasons: the database principal 'domainusername' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you do not have permission.

Dynamics In SSIS?

I have a Table say

Table1
Col 1 Col2 Col 3
A X1 1
A X2 2
B Y1 3
C Z1 4
C Z2 5
( Col1 represents Entity names, Col2 represents there respective field name and Col3 represents the values of those field name)

How can i use the above Table1 and update table A, B, C
Ex:
Table A
X1 X2
1 2

Similarly Table B
Y1
3

and Table C
Z1 Z2
4 5


2 Question:
I was trying to use for each loop container. I am getting this error:

Error: Variable "User::ADOVar" does not contain a valid data object
I followed all the steps in the links
http://www.whiteknighttechnology.com/cs/blogs/brian_knight/archive/2006/03/03/126.aspx
and check out other sources but unable to track where the problem is?

Can some body help me out please

Microsoft SQL Server Notification Services

Has anybody used it . can you give me an idea about the performance etc.?

Connections For Microsoft Directory Services

Hi,

Does anyone knows how to use this ?

Connection for the Microsoft Active Directory Services ?

Can help anyone help me about this?

thanks

Microsoft Releases Synchronization Services CTP

The Microsoft Synchronization Services for ADO.NET v1.0 CTP release appeared without fanfare on January 22, 2006. The release contains "v1.0 early CTP" bits for the sync framework and SQL Server 2005 Compact Edition (SSCE) v3.5, the Orcas successor to the SSCE v3.1 RTM bits, which Microsoft released on January 11, 2006. The current code name for Sync Services is OCS (for Occasionally Connected Systems).

Seems to me to resemble a "stealth release."

For more, see http://oakleafblog.blogspot.com/2007/01/microsoft-releases-synchronization.html.

Need Help Moving Dynamics Sl To New Server

so we been running on a decent server now for a couple years. we just bought a new proliant dl380... faster, more ram, etc.

are there documents to reference to how to make the move successful?

-how to copy the log files and db data files onto the new partitions on the new server.

the actual solomon db is on an MSA 1000 and we plan on keeping it there.

so far on the new server...

-installed sql 2005
-dynamics sl 6.5

any documentation about taking solomon from old server to new server is greatly appreciated

Need Help With Dynamics SL (Solomon) Templates

i hear of a feature called TEMPLATES where you can save the data thats entered into any particular Dynamics SL screen and paste the data in to the same screen at a later time (saves time if there is data that is constantly inputed into the same screen over and over). my question is, where are the templates saved at on the hard drive? and can it be opened/edited in notepad or something else if say we want to make changes to the data before pasting/loading it back?

New 9.0 GP Dynamics && SQL 2005 Upgrade

Just finished my first upgrade of 9.0 GP Dynamics and SQL 2005 - I am having lots of trouble with my users and there passwords. I have tried deleting them in SQL and GPS and start over but still cannot log in for the user - can you help me?

Thanks

cscheible

To Access Reporting Sevices (Report Manager, Reporting Web Services), Does One Has To Be An Admin On The Machine

Hi There,

Our DBA has installed reporting services on a server and now in order to access the report manager, one has to be an Admin on that Server. I am guessing that there is a mistake in the configuration of Reporting Services. Usually it should allow anybody who was added to the roles in the properties section of the Report Manager, right? I have also added the users to the DB..

Also I am using Windows Authentication to access Report Catalog items (Reporting Services is installed on Server2) from a web Application(deployed on Server1) and displaying the report using report viewer. For some reason, server1 has to be in an Admin role on Server2 to access the report catalog/report. This is kinda strange for me as I don't want everybody to be an Admin on Server2. Can anybody please point in the right direction?

Thanks.

Reporting Services :: JIT Debugging Error When Reporting Configuration Manager Is Opened

We have installed SQL Server 2005 with reporting services.When tried to open getting errors as below: how to avoid such errors See the end of this message for details on invoking  just-in-time (JIT) debugging instead of this dialog box.

ReportServicesConfigUI.WMIProvider.WMIProviderException: A WMI error has occurred and no additional error information is available. ---> System.Runtime.InteropServices.COMException (0x8000000A)
  at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
 
[code]...

Trouble Installing Reporting Add-In For Microsoft Visual Web Developer 2005 Express

Hi Folks



I've downloaded & installed Visual Web developer Express and SQL Server Express and now I'm trying to install the Reporting Add-In available here: http://msdn.microsoft.com/vstudio/express/downloads/default.aspx



It downloads just fine and, just as the installation progress bar is almost done and the status text says 'Registering Product', I get the following error message:

"There is a problem with this windows installer package. A program run as part of the setup did not finish as expected. Contact your support personell or package vendor"



Running VWD shows the ReportViewer control now appears in the 'data' group. I can add it to a form, but I cannot create a new report, as clicking on 'Design a new report' under the ReportView Tasks popup menu does nothing.



Any ideas, please?



Thanks

Andrew