Mapping Un Structured Report Data Into SQL Server Database

Feb 29, 2008

 Hi
I need to map the unstructured  report to my Sql server data source,Is there any method to achieve this in ASP.Net or is there any good tool available in the market which support ASP.Net2.0 with SQL server 2005.
My requirement is to load/parse the existing data into my application which in various formats for each cleints
Please help me on this 
 
 

View 2 Replies


ADVERTISEMENT

Reporting Services :: SSRS To Export Report As Structured CSV File

Feb 3, 2015

I'm trying to use SQL Server Reporting Services (SQL Server 2008 R2) to produce a CSV file.  Row 1 in the CSV has to be a summary row with 8 columns.  The detail rows which follow have 24 columns.  The data in the summary row is "static" except for a date, a count of detail rows, and a total amount due based on the detail rows that follow.  Here's an example of what we need it to look like:

HDR,4242,0,1,20150203,25,I,25823.18,,,,,,,,,,,,,,,,
DTL,4242,0,1,20150203,255092,20150129,989,C,Net 0,Due Upon Receipt,12703,Some Super Customer,1001 Grandview Dr,,SomeCity,TX,US,75012,9729990000,,,,
DTL,4242,0,1,20150203,255093,20150129,1360,C,Net 0,Due Upon Receipt,23774,Another Awesome Customer,52 Six Flags Dr,,DeepInTheHeart,TX,US,76006,8174445555,,,,

I've been able to get the report itself to render correctly in Visual Studio or from a browser using several different approaches but they all fail in one way or another when I try to save it as a CSV (eg, a header is prepended to each detail so they end up side by side, header and detail end up with extra columns, etc).

View 11 Replies View Related

SSIS Parameter Mapping With Oracle Data Type Mapping!

Mar 19, 2008

Hi Friends,

I have a small problem in parameter mapping for Execute SQL Task.
I am using a delete statement with 2 conditions.
Followed by another Execute SQL Task which contains commit statement.

delete from tname where c1 = ? and c2 =?

where c1 is number(4) datatype and c2 is of varchar2(20) datatype in oracle.


The connection manager i am using is ORacle OLE DB provider.
I am passing 2 global variables i.e g_v1 of Int32 and g_v2 of String Type.

In the parameter mapping of the Executing SQL task, i am mapping these 2 variables for
c1 and c2 and changed the datatypes inside parameter mapping as Numeric for c1 and Varchar for c2.

I also set the property as ByPassPrepare = True.

When i am executing the package i getting INVALID NUMBER ERROR.
i believe the SSIS is unable to perform the implict datatype converison.

For the next run, i changed the g_v1 varible datatype to Double and also i changed the parameter mapping for c1 as Doble datatype.
This time it is working fine. I can see the Green signal for the 2 SQL Tasks.

But when i connected to Oracle check the count in the table, the data is not getting deleted.

Also,
I set the property RetainSameConnection = TRUE for oracle connection manager.
I am not able to trace this logical error.

The same is working fine in my local machine.
But i am facing the problem when i deployed the same on the client machine.


Is there any problem with parameter mapping?
What should be equialent Datatype for Oracle NUMBER datatype that should be used inside the SSIS package while declaring the global variable and
inside the parameter mapping.

Any thoughts!

View 5 Replies View Related

Analysis :: Sales And Mapping Data - Apply Join To Get Result Into SSRS Report

May 28, 2015

I have sales data in SSAS cube and mapping data in RDBMS table. I want to apply join to get result into SSRS report.

Here we should get data of yesterday from time dimension of cube.

Time is in [Time].[FiscalYearHierarchy].[Fiscal Day].&[2015-05-28T00:00:00] format.

View 4 Replies View Related

This Feature Remote Access To Report Data Sources And/or The Report Server Database Is Not Supported In This Edition Of Report

Jun 16, 2006

SQL server 2005 express reporting problem.

error message:

This feature "remote access to report data sources and/or the report server database" is not supported in this edition of reporting service

I got this error message when I try to connect to database hosted in another PC running SQL server 2000.

Is it true that SQlL server Express can only use Local Database Engine to host the database?



View 5 Replies View Related

Single Table Structured Dynamic Relational Database

Apr 10, 2008

Sharepoint is a pretty darn dynamic service and that got me thinking of how databases are created.
Just wondering out loud, surely someone has thought of creating databases in such a manner, but I don't know if it's a thought that has been struck down.

It would look something like this:
Single Table
ID uniqueidentifier PK
ParentID uniqueidentifier FK to ID
Name nvarchar(MAX)

Value nvarchar(MAX)

In this manner, you would create your database "columns" as needed in the data-layer.

If that is too strict, (every datatype would be encoded to base64), you could create a value option for basically every data type. EG. nvarchar(max), nvarbinary(max).... and add another field that describes the data-type to be used for that "column"
ID uniqueidentifier PK
ParentID uniqueidentifier FK to ID
Name nvarchar(MAX)
DataType nvarchar(50) //constrained to allowable datatypes
MaxLen nvarchar(31) //ahh, what the hey, let's add this for sniggles.
ValueNvarchar nvarchar(MAX) nullable

ValueNvarbin nvarbinary(MAX) nullable

....

Now, to allow the "values" for those "columns", you may be able to still use the single-table approach, but it may be better to have an extra table for that (probably even a different partition and drive).


Things to consider, indexing.....
In development, the data-layer would handle the creation/reading of table columns.
The business-layer, which could be many for different parts of a company, would make it's requests to the DL. It may need a username, and the DL would either just create it, or suggest an already existing username column. The path to that username may not be where a particular biz element wants it, so they will ask the DL create another under a diff path.

The business-layer is probably the most important reason for wanting a single dynamic table.

In the end, the relation structure could be like:
Human //dir, no value, no parent (root)
FirstName //value - text
LastName //value - text
Parent1 //value - Me Id
Sibling1 //value - Me Id
SiblingN //value - Me Id

School //dir, no val
ParentId //value - Id (perhaps category would be Building)
Name //value - text

The sibling N would be an example of how a table may need to be dynamic. A positive of the single-table approach is no limitation on number of "columns". Another is the ease to move a hierarchical structure if needed. School may want to be University instead of just "school" and be placed as a child of "school".

Looking for any thoughts on the subject,
Nathan

View 1 Replies View Related

Using Other Editions Of SQL Server For Report Data Sources And/or The Report Server Database Is Not Supported In This Edition Of Reporting Services

Sep 9, 2006

Hi My project is in .NET 2003 i.e. framework 1.1 and database in SQLServer 2000. But the reports have been developed using SQLServer 2005 Reporting Services. Now when I am trying to deploy them through deployment project of .NET its giving me following error:"Using other editions of SQL Server for report data sources and/or the report server database" is not supported in this edition of Reporting Services.  Now I am really confused with this. Can any one please guide me regarding this ASAP. Thanks, Falguni   

View 4 Replies View Related

The Report Server Cannot Decrypt The Symmetric Key Used To Access Sensitive Or Encrypted Data In A Report Server Database

May 25, 2007



Hi every one,



I'm very new new at this. I'm try to deploy a report model and got this message. I have no idea what its going on about.



Can anyone help me?



Aku




------------------------------

System.Web.Services.Protocols.SoapException: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> Microsoft.ReportingServices.Diagnostics.Utilities.RPCException: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> System.Exception: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> System.Exception: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> System.Exception: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> System.Exception: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> System.Exception: Bad Data. (Exception from HRESULT: 0x80090005)
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Diagnostics.DataProtection.ProtectData(Byte[] unprotectedData, String tag)
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String storedProcedureName)
at Microsoft.ReportingServices.Library.DBInterface.GetAllConfigurationInfo()
at Microsoft.ReportingServices.Library.RSService.GetSystemProperties(Property[] requestedProperties)
at Microsoft.ReportingServices.WebServer.ReportingService.GetSystemProperties(Property[] Properties, Property[]& Values)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService.GetSystemProperties(Property[] Properties, Property[]& Values) (System.Web.Services)

------------------------------
BUTTONS:

OK
------------------------------

View 38 Replies View Related

Remote Access To Report Data Sources And/or The Report Server Database Is Not Supported In This Edition Of Reporting Services.

Apr 24, 2006

I'm using SQL Express with Advance Services & I get this error when I try to deploy my reports. Why do I get this error

An error has occurred during report processing. (rsProcessingAborted)

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

The feature: "Remote access to report data sources and/or the report server database" is not supported in this edition of Reporting Services. (rsOperationNotSupported)

Justin Song

View 4 Replies View Related

Mapping Of SQL Server Data Types To Integration Services Data Type

Oct 14, 2005

Does anyone know of any cross-references between SQL Server data types and the new data types introduced with SQL Server Integration Services? 

View 6 Replies View Related

Data Mapping And Importing App For SQL Server

Nov 4, 2006

Hello,Our company often receives data from outside sources to add to our application.  This data is usually provided to us in Excel, CSV, XML, etc.  The files that we receive usually have different columns from the columns in our database, so we have to map these columns to our table structure to import.I'm looking for an application that will easily allow me to load up the data file (whatever type it may be), expose the columns in the data file, allow me to map these columns in our SQL server, then import the data.  I know that this can be done as DTS, however I'm looking for alternatives.  Does anyone have any recommendations? Thanks in advance. 

View 1 Replies View Related

Mapping SQL Server Data Types To C DataTypes

Jul 20, 2005

Hi Can anyone point me to a document somewhere that shows a mapping ofSQL Server 2000 datatypes to C datatypes? I am writing some extendedstored procedures which need to be able to process pretty much anydata type, so I want to make sure I am taking them from SRVPROC andstoring them in the correct C data type.Thanks,Bruce

View 1 Replies View Related

SQL Server 2008 :: Review Data Type Mapping (Import And Export Wizard)

Jun 5, 2015

Not seeing the Review Data Type Mapping Screen in SQL Server Import and Export Wizard?

Is there only a certain version where that screen shows up?

I am trying to import data from an MS Access application to SQL Server and all of the connections are good, but some of the data isn't and if I let it migrate using this tool it crashes on the bad data and there is no data that migrates. The Review Data Type Mapping screen will allow me to bypass the records in error and load the rest. however, I can;t do that if I cannot see the screen.

View 9 Replies View Related

Moving DTS Stored Structured Files

Sep 20, 2002

How do you load existing DTS Stored Structured files on to a new SQL 2000 Server?

View 1 Replies View Related

Reading DTS Logs On Structured Storage File

Jul 6, 2006

Our DTS packages are saved as structured storage files. I can find instructions on accessing log files for locally saved DTS packages but not the kind we use.

Can someone help?

View 4 Replies View Related

Is There A Way To Do A Bulk Migration Of DTS Structured Storage Files?

Sep 22, 2006

For a number of excellent reasons, I have exported the DTS packages that need to be migrated to SSIS to structured storage files. However, unlike the migration from a SQL Server source, the wizard doesn't allow a developer to select more than one package at a time.

Is there a way to do this in bulk that I am unaware of? I sure hope so as I have a couple of hundred to do and it's going to get very old very quickly if I have to do them one at a time!

View 4 Replies View Related

Event 107 Report Server Windows Service (MSSQLSERVER) Cannot Connect To The Report Server Database.

Dec 5, 2007

every 1 hour my server's computer is restarting !
when the windows finish restarting i open the Event viewer and see that what coused it is the error :


"Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database."
Event 107
source : "Report Server Windows Service (MSSQLSERVER)"

How can i solve it ?

View 4 Replies View Related

Data Mapping And Migration

May 28, 2004

Has anyone used DTS packages for migrating old data to a new schema?

If so are there any tutorials on this?

I'd prefer not to do this by hand. ;-)

View 3 Replies View Related

Mapping XML Data To Variable

Jun 20, 2007

I can€™t figure out how to map xml data stored in a table to a variable in integration service.

For example:
I would like to use a €œfor each loop container€? to iterate through a row set selected from database. Each row has three columns, an integer, a string and an xml data. In the variable mappings, I can map the integer column and the string column to a variable with type of int and a variable with type of string. But I am having trouble to map the xml data column to any variable. I tried using either a string variable or object. It always reports error like €œvariable mapping number X to variable XXX can€™t apply€?.
Any help?

View 1 Replies View Related

Multiple Report Server Instances Sharing A Single Report Server Database

Mar 30, 2007

I would like to know if it is possible to have different applications on separate report servers sharing one report server database. If so are there possible issues or ptfalls to this type of architecture?



Thanks,



thecoleman

View 3 Replies View Related

Data Mapping And Migration Tool?

Jun 21, 2014

I am developing one automation tool for data migration from one table to other table, here i am looking for one function or SP for which i will pass source column and destination column as input parameter and want output parameter to return true when source column data is compatible to copy to destination column if not then it should return false.

For example if source column is varchar and destination column is integer, the script should check all the data in source column in good enough to move to integer column or not and return the output flag. I want a script to work this for all types of data types.

View 2 Replies View Related

Data Conversion Mapping Weirdness

Mar 4, 2008

Hi,

I have an Excel source > Data Conversion task > OLE DB Destination.

In the Data Conversion task I rename all the outputs to match the column names in my destination table.

However, when I go to map the columns in the OLE DB Destination mapping tab, it's a mess. Some fields are prefaced by "Data Conversion" as in "Data Conversion.column1", others are prefaced by "Excel Source" and others have no prefix at all.

What's confusing is, since all the columns are going through the Data Conversion task, how come I don't have ALL fields prefaced by "Data Conversion" ?

That is, only SOME of the fields have a "Data Conversion" prefix, and some don't. The ones that aren't prefaced by "Data Conversion" have no corresponding "Excel Source" so I'm assuming that the ones without the prefix are from the Data Conversion task.

It's inconsistent. Any ideas.

Thanks

View 3 Replies View Related

Getting The Report Server Cannot Open A Connection To The Report Server Database Error

Jul 5, 2007

Hi



I went to my comp ->rt cick->manage-IIS->default website->rt click->properties->directory security->annoymouse access€¦EDIT->under Default domain it was blank, and i added a domain there.



And i was getting error opening up the reports from localhost.



I changed everything to same as it was previosly, and I am getting the error:

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) (rsRPCError) Get Online Help










Cannot open database "ReportServer$SQLExpress" requested by the login. The login failed. Login failed for user 'NGESComputer name$'.

View 1 Replies View Related

WBE Based Data Mapping/conversion Tool

Oct 3, 2007

Can anyone recomend an EXTREEMLY user friendly web based data mapping / conversion tool? I am wanting to transform csv, xml, database sources into csv, xml, db sources. There are a ton of Windows based applications (ie: www.altova.com / mapforce). I am looking for something I can expose via the web...

users has ability to upload a csv file and then define how the data would be mapped to an output source (say another csv or xml). In addition having functions like concantination, sum, if-exists, etc...

Does SSIS have a user friendly interface or has someone written some interactive tools on top of SSIS.

Any information will be greatly apreciated.

Thanx

View 1 Replies View Related

One To Many Column Mapping In Data Flow Task

Sep 27, 2007



Hi,
Is there a way to accomplish one- many or many -one or many - many column mappings in the SSIS data flow task or using any other tasks. We were able to do this in DTS Transform data task. Also is it possible to edit the mapping like:
dest column1 = Right(dest column1, 3)

Thanks.

View 4 Replies View Related

SSIS Data Cleansing Mapping Problem

Apr 18, 2007

I am just starting out with SSIS and trying to get the feel of data cleansing using it. But on my very first project for data cleansing I've got into this weird error.



My data flow is very simple, it has a OLE DB source, Fuzzy Lookup and OLE DB destination. I've built three tables for this purpose, one is source, one is reference (it will be used to match for the real entries in fuzzy lookup) and the last is the destination table.



In all the three tables I've a field of City which I'd like to Fuzzy lookup in the reference table and if it crosses certain confidence level, I'd like to insert to the destination table. City in all the tables has the same datatype, defined in the same way, it is varchar(50).



But when in the fuzzy lookup I try to map the Source tables City field to reference tables City field, it gives me this error:



The following columns cannot be mapped:

[City, CityRef]

One or more columns do not have supported data types, or their data types do not match.



Although as I have mentioned before, both have same data types and are defined in the same manner (i.e. I've just selected the datatypes for those columns and all the other settings are left to default). I just cannot understand why this is happening, plz help me with this. FYI I've also tried to give the City Column different datatypes in all the tables like varchar(max), text, Only to be greeted with the same error message.



Waiting for your reply!!

Regards,

Sajid.

View 6 Replies View Related

Data Type In Parameter Mapping For An Execute SQL Task

Jul 12, 2006

Hi, I am trying to use an integer as input parameter for my task I get suck on the parameter data type.

The input parameter is define as @Control_ID variable as Int32 in SSIS. When I got into the parameter mapping of Execute SQL Task, I don't find the Int32 data type. I used to try Short, Numeric, Decimal and so on, but all of those data type didn't work. and it returns the following error message:

SSIS package "DCLoading.dtsx" starting.
Error: 0xC002F210 at Update Control_ID, Execute SQL Task: Executing the query "use DCAStaging

update DCA_HFStaging set
[dbo].[Control_ID] = P0 where [Control_ID] is null
" failed with the following error: "The multi-part identifier "dbo.Control_ID" could not be bound.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Task failed: Update Control_ID
Warning: 0x80019002 at DCLoading: The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "DCLoading.dtsx" finished: Failure.

Any help?

View 6 Replies View Related

Custom Data Flow Component Column Mapping Question

Feb 7, 2007

Hi,

I'm having my first go at developing a destination adapter which will send data to an update Web Service.

I've got some rather big gaps in my understanding. I've been following the various samples I've found on the net and have validated my mapping and picked up all the available column names and datatypes which are appearing in the Input and Output Properties tab of the Advanced Editor but I only have a tab for "Input Columns" and not "Column Mappings".

Which method defines the availble columns for the user to map?

Let me know if I haven't given enough information.

cheers

View 1 Replies View Related

Retriving Metadata And Data Of Report From Report Server

Oct 7, 2007

hi all,

i have a deployed on the report server. is there any way i can retrive the metadata(xml) from report server using C#.

Also wanted to run the reoprt from server and get it's output (data) in XML.

please help.

Regards...
girija shankar

View 1 Replies View Related

The Report Server Cannot Open A Connection To The Report Server Database

Mar 29, 2007

Hi,

I am newbie and working with an application that ueses report server 2000 to make reports.



The problem is somebody has moved the database and changed some acounts and now I can not either get any report from the server or install my changes for reports. I used to run this commando to install changes for reports:

rs -i PublishGeckoReports.rss -s http://IpAddress:32808/reportserver -v definitionPath="C:TempDeploymentReportsRDL" -v targetFolder="/MyReports"



here is the error message i get when i try to install:

System.Web.Services.Protocols.SoapException: The report server cannot open a connection to the report server database. The logon failed



when I browse to http://IpAddress:32808/reportserver I get following:

The report server cannot open a connection to the report server database. The logon failed. (rsReportServerDatabaseLogonFailed) Get Online Help

Logon failure: unknown user name or bad password.

at IIS Manager for default web site Enable Anonymous Access is checked and on the database server and the web.config file use same account and password.



but I heard that somewhere there is encrypted password that i have to change it too.



I need your help

Thanks

View 2 Replies View Related

Report Server Cannot Open Connection To Report Server Database

Jan 5, 2007

Hi,

I got consistent error of the following:

ReportingServicesService!runningjobs!13!1/3/2007-10:45:21:: e ERROR: Error in timer Database Cleanup (NT Service) : Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()
--- End of inner exception stack trace ---

The error happens on Reporting Service version 9.00.3017.00 (the version we are running in Production). The Reporting Service and its database are actually resided in the same physical server. And the strange thing is that it does not prevent any functionalities or features working except when I launch the Management Studio on that server, it usually takes 2 minutes to load up. (any other server would just take 5 -10 seconds).

Can any one help?

Thanks!

William.

View 1 Replies View Related

Report Server (MSSQLSERVER) Cannot Connect To The Report Server Database

Feb 15, 2007

I am running SQL Reporting Services and SQL Server 2005 on a Windows 2003 server. The configuration has been unchanged for approx. 3 weeks. Suddenly today, reports being accessed via an ASP.NET 2.0 application (on Windows 2003 Server with IIS 6) using a SOAP call to the reportserver became inaccessable. End users received the following error:


Message: An error occurred during rendering of the report. --->
An error occurred during rendering of the report. --->
An error occurred during rendering of the report. --->
An error occurred during rendering of the report. --->
Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

Stack Trace: at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at IFA.CAP.SQLReportingService.ReportingService.Render(String Report, String Format, String HistoryID, String DeviceInfo, ParameterValue[] Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle, String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings, String[]& StreamIds) in C:ApplicationsIFACAPWeb ReferencesSQLReportingServiceReference.vb:line 1319
at IFA.CAP.BusinessObjects.Reports.Certificate(Int32 certificateID, Boolean isDraft, Boolean isCertified) in C:ApplicationsIFACAPBusinessObjectsIFA.CAP.BusinessObjects.Report.vb:line 551
at IFA.CAP.CertificateDetail.PrintCertificate(Object sender, EventArgs e) in C:ApplicationsIFACAPMainCertificateDetail.aspx.vb:line 2287

Subsequently, the following error is logged on the Report Server/Database server:


Report Server (MSSQLSERVER) cannot connect to the report server database.

I was able to temporarily correct the problem by performing as iisrest on the Report Server/Database server. However, the same problem occured again a couple hours later. I am relatively new to SQL Reporting Services so any help would be appreciated.

MDJ

View 1 Replies View Related

Report Server Cannot Open A Connection To The Report Server Database

Jan 9, 2007

I am getting the following error, when trying to deploy. the report should point to a server which is in my network, but the report is on my machine. where i am trying to deploy locally but point to a different machine.

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

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing.

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

Thank you very much for the information.

View 3 Replies View Related







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