How To Integrate Reportbuilder With A .Net Web Application?

Oct 12, 2006

How to integrate reportbuilder with a .Net web application?

Reportbuilder.application Authentication Error

May 10, 2006

This is the strangest thing. Whenever I try to access report builder from 90% of machines, I get the following error:

PLATFORM VERSION INFO
Windows : 5.1.2600.131072 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)

SOURCES
Deployment url : https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application

ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
+ The remote server returned an error: (401) Unauthorized.

COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.

WARNINGS
There were no warnings during this operation.

OPERATION PROGRESS STATUS
* [5/10/2006 8:48:02 AM] : Activation of https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application has started.

ERROR DETAILS
Following errors were detected during this operation.
* [5/10/2006 8:48:11 AM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState)
at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
--- Inner Exception ---
System.Net.WebException
- The remote server returned an error: (401) Unauthorized.
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)

COMPONENT STORE TRANSACTION DETAILS
No transaction informtion is available.
-------------------------------

Ok, so here's the catch. It works one 1 machine, a co-workers machine. I can login as any user and it'll work fine. But when I try it on any other machine, including my laptop, my desktop, my server, etc. I get that error. I've tried adjusting the IE Security settings, firewall settings, even tried different browsers. Here's some of the stuff installed on my machines:

Laptop
-Windows XP Pro
-ASP.NET Validation Tool
-Visual Basic Express w/ SQL Server Express
-.NET 1.1/2.0 Framework

Desktop
-Windows XP Home
-Visual Studio 2005 Professional
-.NET 1.1/2.0 Framework

Server
-Windows Server 2003 Enterprise
-SQL Server 2005
-.NET 1.1/2.0 Framework

Any help on this would be greatly appreciated. Even our lead developer has no clue, it won't work on his machine either!

View 1 Replies View Related

ReportBuilder.Application Will Not Work On Client On Network

Apr 10, 2006

PLATFORM VERSION INFO
Windows : 5.1.2600.131072 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)

SOURCES
Deployment url : http://webdev.ci.lubbock.tx.us/ReportServer$SQL05/ReportBuilder/ReportBuilder.application

ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of http://webdev.ci.lubbock.tx.us/ReportServer$SQL05/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading http://webdev.ci.lubbock.tx.us/ReportServer$SQL05/ReportBuilder/ReportBuilder.application did not succeed.
+ The remote server returned an error: (401) Unauthorized.

COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.

WARNINGS
There were no warnings during this operation.

OPERATION PROGRESS STATUS
* [4/10/2006 11:34:29 AM] : Activation of http://webdev.ci.lubbock.tx.us/ReportServer$SQL05/ReportBuilder/ReportBuilder.application has started.

ERROR DETAILS
Following errors were detected during this operation.
* [4/10/2006 11:34:29 AM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading http://webdev.ci.lubbock.tx.us/ReportServer$SQL05/ReportBuilder/ReportBuilder.application did not succeed.
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState)
at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
--- Inner Exception ---
System.Net.WebException
- The remote server returned an error: (401) Unauthorized.
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)

COMPONENT STORE TRANSACTION DETAILS
No transaction information is available.

Does anyone know how that I can get the reportbuilder.application to run on a client on the network. It seems that if I have to remote into the actual server to get the report builder to work would be pointless for users on the network. I get the 401 Unauthorized all the time. Any comments would help.

Jordanb412

View 3 Replies View Related

Problem With Starting Reportbuilder Application When Using ISA Server

Nov 19, 2007

We have installed SQL Server 2005 reporting services and reportbuilder.
On the local machine and local network we can start and use reportbuilder perfectly.

We are using ISA server for security. When we get around ISA it works fine, but when we have to get access via ISA, we get the error 'unauthorised', when starting the reportbuilder application.

The virtual folder 'reportbuilder' is configured in IIS for Anonymous access, the report en reportserver virtual folder, we need basis authentication.

Can someone help?

View 3 Replies View Related

Integrate Report Bulder With .net Application

Oct 30, 2007

How should i integrate Report Builder with my .net application.

Currently I am using ReportViewer Class to integrate Regular Reports.
But in that we need to pass both

reportViewer.ServerUrl = "https://SERVERURL/ReportServer/Pages/ReportViewer.aspx?%2fFOLDER%2f";
reportViewer.ReportPath = "REPORT NAME";

reportViewer.Toolbar = com.mitchell.services.workbench.carr.ReportViewer.multiState.True;

reportViewer.Parameters = com.mitchell.services.workbench.carr.ReportViewer.multiState.True;

reportViewer.SetQueryParameter("Company","Company Name");

ReportSecurity rs = new ReportSecurity();

reportViewer.SetQueryParameter("ReportData",Server.UrlEncode(rs.Encrypt(m_sCompCode + "_" + m_objUserInfo.UserID)));

string str = reportViewer.Url;

and passing the str value in my iframe of application
above code is working fine for regular reports

But how should i integrate REPORT BUILDER

Any web tutorial from where i can get good help.

View 1 Replies View Related

Integrate Report Manager In An Asp.net Application

Feb 22, 2007

I thought I can probably find out how the report manager works and create a similar application so that I can define my own things in there.

Looks like there is no sample where I could get a lead. Now I have decided if I can include the report manager in a new aspx page in my application and disable the stuff which is not required by the user to look at it.

I can definitely include the report manager url in the Iframe but how do I disable the stuff from the report manager.

Please help, I am having real hard time.

Thanks in advance.

View 1 Replies View Related

How To Integrate SQL Server Business Intelligence Tool Into ASP.Net Web Application

Jan 10, 2007

How to integrate SQL Server Business Intelligence Tool into ASP.Net web Application.
Anybody can send the answer for above one it is great help for me, just I want to open this tool through >net application and I can able to create some reports from there.

View 3 Replies View Related

[urgent]window Application Integrate SQL Report Service

Apr 24, 2008

i am new for SQL server report service, i have a project that need to generate report and integrate or shown on my window application,
so i have a few questions as follows:

1) do i need to add web reference ( report ) to my window application?.
2) how can i preview and print .rdl report within my window application?
3) how to automatically printer report? can this be done by within a store procedure or trigger or in window application?

ps: view reprot manager, ---- http://localhost/reportserver$SQLEXPRESS
ask me name & password? what name should i type in sa? or Administrator or ?

many thanks,

C

View 4 Replies View Related

Can't Launch ReportBuilder

Feb 20, 2008

I was the happy admin of some reportservers (build 3175) until someone asked me to get the ReportBuilder to work. I've read through the documentation and configured the SSRS site security so that the icon is visible. However when I click on it nothing happens. If I try to launch it by right clicking and then save as -- open I receive the following error:

- Downloading file:///C:/UserTemp/_temp/ReportBuilder.exe.manifest did not succeed.
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState)
at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadApplicationManifest(AssemblyManifest deploymentManifest, String targetDir, Uri deploymentUri, IDownloadNotification notification, DownloadOptions options, Uri& appSourceUri, String& appManifestPath)
at System.Deployment.Application.ApplicationActivator.DownloadApplication(SubscriptionState subState, ActivationDescription actDesc, Int64 transactionId, TempDirectory& downloadTemp)
at System.Deployment.Application.ApplicationActivator.InstallApplication(SubscriptionState subState, ActivationDescription actDesc)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
--- Inner Exception ---
System.Net.WebException
- Could not find file 'C:UserTemp\_tempReportBuilder.exe.manifest'.
- Source: System
- Stack trace:
at System.Net.FileWebRequest.EndGetResponse(IAsyncResult asyncResult)
at System.Net.FileWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
--- Inner Exception ---
System.Net.WebException
- Could not find file 'C:UserTemp\_tempReportBuilder.exe.manifest'.
- Source: System
- Stack trace:
at System.Net.FileWebResponse..ctor(FileWebRequest request, Uri uri, FileAccess access, Boolean asyncHint)
at System.Net.FileWebRequest.WrappedGetResponseCallback(Object state)
--- Inner Exception ---
System.IO.FileNotFoundException
- Could not find file 'C:UserTemp\_tempReportBuilder.exe.manifest'.
- Source: mscorlib
- Stack trace:
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, Boolean useAsync)
at System.Net.FileWebStream..ctor(FileWebRequest request, String path, FileMode mode, FileAccess access, FileShare sharing, Int32 length, Boolean async)
at System.Net.FileWebResponse..ctor(FileWebRequest request, Uri uri, FileAccess access, Boolean asyncHint)
COMPONENT STORE TRANSACTION DETAILS
No transaction information is available.

Here are the things I have checked/tried:

Ensured the .NET Framework Reliant components are enabled in the browser

Running the browser with a user account that is local admin on the workstation

MIME settings on IIS server look ok

I am not seeing any access denieds on my workstation (checked with file and regmon)

I am not seeing any failures in the security event log

For the test that I am doing, both the user account, workstation and server are in the same domain

Don't see any errors in the SSRS logs
Can anyone think of anything else that would lead me to resolving this problem?

Thanks

View 3 Replies View Related

ReportBuilder And Forms Authentication

Aug 6, 2007

We created a custom security extension for RS using Forms Authentication. The issue I am having is in ReportBuilder when the forms authentication ticket expires. Forms auth will attempt to redirect (send a HTTP 302) and the report builder will show the error message "Object moved to here" instead of prompt for credentials. I have been watching the IIS logs and I see the first time report builder start it attempt to connect using default windows credentials and after the FormsAuthenticationRequired exception it will prompt for credentials and invoke LogonUser method, but this only happens the first time or if change the server in the url. I was expecting ReportBuilder to consider the Forms Authentication expiration at any time.

Do you have any idea how to work around this?

Any help is really appreciated.

Thanks

View 6 Replies View Related

Question About If Condition In ReportBuilder

May 11, 2007

I have a question about table layout report. I want to do that:

I have a table report and on that report i have a Total field of money. And i want to do that if condition on that field, so if the prize is less then 150, the color of the text it should be red otherwise it should be other color. So how can i achieve that. I know that this is possible in Reporting services in Report Designer is like =IIF(field.???.Value<150;"red";"gree")

But if i make that same in report builder, the what it does, it displays not the value in color, but it displays the text "red" od "green".

I will be very happy and gratefull if somebody can help me.

thank you in advance.

View 2 Replies View Related

Dynamic Report Using ReportBuilder

Jan 4, 2008

I am using a Visual Studio 2005 for web application development, for Reporting service

I am using Sql Server Reporting Service and Report Builder 9.0.1399.0.

Is it possible to use the Report builder tools (Explorer, Fields and Design Report) in

an ASPX pages?.

Is it Possible to create the Reports dynamically in a Web Application using Report

Builder?

Thanks in Advance
Thanigaivel

View 1 Replies View Related

ReportBuilder Filter Width

Nov 9, 2007

Hi,
Is there a way to change the size of the fields (in this case a drop down list) on the filter page of ReportBuilder? I have an attribute I want to filter by, but the contents are too wide so the full thing can't be read if I set up an 'equals to' filter in ReportBuilder.

Thanks.....

View 1 Replies View Related

Possible To Open Reportbuilder From Within A Web App And Pass Credentials?

Nov 4, 2007

I am trying to open the reportbuilder from within a web application so that I can pass the credentials. I would like to be able to have the reportbuilder open within the app. Is this possible.

I'm trying to avoid keeping the report builder credentials and the app's credentials both up to date.

Thanks.

View 2 Replies View Related

Liste Of Report Made With ReportBuilder

Aug 7, 2006

Hi !

I'm trying to figure out how can i get a list of the reports made with reportbuilder. I have create a folder in ReportManger and all my report are in this folder.
When i create report with ReportDesigner i get a .RDL file, but when i create a report using reportBuilder i can't file the file created. What i want to do is to create in our web application a Web page with a list of report that our client has create using ReportBuilder. I was thinking about doing a loop on the folder for each report File but i can't find those files.

Any idea ?

Thanks!

View 7 Replies View Related

Visual Studio VS ReportBuilder Problem

Jul 31, 2006

Hi !

We have made a lot of reports using Visual Studio. Now some of our client would like to customize those reports. We have install ReportBuilder on their server to allow them to create their own reports. Everything is working fine when they are trying to create new reports. The problem is when they are trying to customize reports that we have made using Visual Studio.

When they are trying to open those reports in ReportBuilder they get this Error:

One or more unexpected Report Definition Language (RDL) elements of the following type have been removed: DataSetMicrosoft.ReportingServices.ReportBuilder.ReportModel.Report: System.Web.Services.Protocols.SoapException: The operation you are attempting on item "/Data Sources/DataSource1" is not allowed for this item type. ---> Microsoft.ReportingServices.Diagnostics.Utilities.WrongItemTypeException: The operation you are attempting on item "/Data Sources/DataSource1" is not allowed for this item type. at Microsoft.ReportingServices.Library.ModelCatalogItem.ModelStorage.GetModelItemIDAndItemSecurity(ModelCatalogItem model) at Microsoft.ReportingServices.Library.ModelCatalogItem.ModelStorage.LoadModel(ModelCatalogItem model, Boolean getModelDefinition) at Microsoft.ReportingServices.Library.ModelCatalogItem.LoadModel(CatalogItemContext modelContext, Nullable`1 requiredOperation, Boolean getModelDefinition) at Microsoft.ReportingServices.Library.ModelCatalogItem.LoadUserModel(CatalogItemContext modelContext, Nullable`1 requiredOperation, String perspectiveID) at Microsoft.ReportingServices.Library.GetUserModelAction.PerformActionNow() at Microsoft.ReportingServices.Library.RSSoapAction.Execute() at Microsoft.ReportingServices.WebServer.ReportingService2005.GetUserModel(String Model, String Perspective, Byte[]& Definition) --- End of inner exception stack trace --- at Microsoft.ReportingServices.WebServer.ReportingService2005.GetUserModel(String Model, String Perspective, Byte[]& Definition)

We get this error for each report that we have create under Visual Studio (All those report use parameters). Is there a way to allow our client to customize those reports ?

Thanks !!

View 8 Replies View Related

ReportBuilder / Report Model Explanation Needed

May 1, 2008

(I wish I was able to attach pictures....anyhow I'll try my best without them)

The customer's goal is to via ReportBuilder to select fields from multiple
many-to-many relationships. They are able to see the fields that exists
within the various many-to-many relationships but IS ONLY able to select
fields from ONE many-to-many relationship. Example using AdventureWorks:

DataSourceView (relationships automatically generated by wizard)
Contact ---< VendorContact >--- Vendor
Contact ---< StoreContact >--- Store
Contact ---< ContactCreditCard >--- CreditCard

So the goal in the ReportBuilder is to be able select fields from
Contact/Vendor/Store/ and CreditCard.
PROBLEM is that the ReportBuilder ONLY allows user to select fields from
Contact/Vendor OR Contact/Store OR Contact/CreditCard (exclusively)

The only workaround I've found is to reverse the relationships in the
DataSourceView to the following

Contact >--- VendorContact ---< Vendor
Contact >--- StoreContact ---< Store
Contact >--- ContactCreditCard ---< CreditCard

This works however we need an explanation as to why it only works this way?

Thanks in advance

View 1 Replies View Related

How To Integrate The SP2 Into The Installation

Nov 11, 2007

I want to integrate the service pack 2 into the SQL2005 Installation,so I can easily setup SQL2005+sp2 next time

give me some solutions,Thanks~

View 1 Replies View Related

How Do I Integrate With SourceSafe Or TFS-VC?

Apr 24, 2006

Where can I find information about how to integrate a SQL 2005 database with either SourceSafe or Team Foundation Server Version Control?

I would like to have database changes for tables, views, stored procs, etc. under source control. Is this even possible?

View 3 Replies View Related

Integrate VSS With SQL 2005

Jan 4, 2007

Is there a way to compare a script in Visual source safe with sql 2005 stored procedure without scripting out the stored procedure from sql? I usaually script out a stored procedure from sql to a .sql file and compare it with a script in VSS and I was wondering if anyone know a faster way to compare SPs in production server with VSS. I am using sql management studio and also added all SPs to VSS thru management studio. Thanks.

View 6 Replies View Related

Integrate Micosoft Project Into MS SQL

Dec 6, 2007

hi all, would like to ask for help...is anyone know how save the ms project into database, is it possible to save it into MSSQL.i am just a new beginner..thanks in advanced.-Myra-

View 8 Replies View Related

Integrate In SQL Server 2000

Feb 5, 2006

I want to integrate tool in SQL server 2000.
Ex. add more the approximate search or fuzzy search to get well results.

please show me, what do?

View 1 Replies View Related

Integrate Sub-querying Into Queries

Oct 14, 2014

I should start to integrate sub-querying into my queries to make them run more efficiently and faster.Below is a query that I use often as a template, often just modifying the day, order and truenumber. how to set up a sub-query for this.

select "betatest", order, age, gender, geo, count (1), count (distinct rdz.id)
from analytics1 rdz
join analytics_2 alvds on (rdz.id = alvds.id)
left outer join analytics3 spd on (alvds.zipcode = spd.zip)
where day >= '2014-08-01'
and day <= '2014-09-30'
and order = 317228536
and truenumber = 540192016
group by "betatest",order,age, gender,geo;

View 7 Replies View Related

How To Integrate SSIS And SSAS

Jun 12, 2007

Hi, all,

Some of you may have done this, but how do you integrate a Integration package with Analysis Services?

Within my vs solution, I have a SSIS package and a SSAS, which will build a simple cube.

At the end of SSIS, it can email, log, or exec another SSIS pkg, etc. but I did not find out a way to fire off the SSAS part.

Thanks!

View 7 Replies View Related

How To Integrate Sql Queries Into Sharepoint

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

When Will SQL Everywhere Integrate To The Windows Kernel?

Sep 16, 2006

One of the biggest problems today is that damn slow file system and windows registry, the NTFS file system is good when you work with a small amount of files, and once you have more files, it becomes slower and slower.
And the same applies to the Windows Registry.
It would be wonderful if the SQL Server 2005 everywhere edition is provided as a low level Windows Kernel API, so instead of using a prehistoric NTFS file allocation table for the file system, Microsoft will use the sql server to store the list of files and folder.
I am not talking about the data itself, it can stay as it is today, do not repeat the insane WinFs mistake for the third time, just the list of files and folders, the registry entries, the event log, etc, all the things that are based on an outdated slow prehistoric legacy code, just have them in the SQL Server Everywhere Edition, and the performance will skyrocket, just every other application running under windows will improve.
If this happens, things like Slow VS.NET issues, Slow Windows Vista RC1, and other slow Microsoft products will just become faster again.
Well, just a wish, perhaps we need 10 additional years until the microsoftians get it :-)

View 4 Replies View Related

How To Integrate ADO In A Windows Service

Jan 11, 2007

The problem is integrating an ADO connection into a Service in C#. The peculiar thing is that the same thing works well in an application but throws a problem in the Service i.e. the Service doesnt want to start...

The problem is at establishing the connection - but the same thing works just fine in an Windows application.

string MySqlConnString = "SERVER=N16\SQLEXPRESS; TRusted_connection=yes; database = EventTrack2007";

MySqlConnection = new SqlConnection();

MySqlConnection.ConnectionString = MySqlConnString;

MySqlConnection.Open();

Thank you!

View 9 Replies View Related

How To Integrate Reporting Services With ASP.Net

Jun 16, 2006

Hi

My current situation is how to integrate my application written in asp.net to link to my report server's report ?

as by default anonymous user can access my report server's report without any authentication. how to configure to make the report server by using form authentication before access the reports?

My Application Configuration

Web application (Vb.Net) - http://192.168.1.18/mobiFO

Reporting services - http://192.168.1.19/reportserver/reports/mobiforeport

DBMS - MS SQL Server 2005 developer edition + Reporting Services 2005 SP1

Thanks for your help.

anything can email me at jack0726@yahoo.com

View 22 Replies View Related

Netware Logins And How To Integrate Into SQL 2005?

Mar 17, 2008

I was wondering if anyone could help me with this. I am currently working on a project for reporting on a new acquisition the company have made. Unfortunately, the people I have to give access to the SQL Server are using Netware for authentication.

Is there any way to allow these people to log into SQL Server without having to create a SQL authenticated user for each of them?

Thanks

View 7 Replies View Related

Integrate WSS 3.0 And Reporting Services With Kerberos - Help Need

Mar 12, 2008

Hi,

For last 2 days, I'm struggling to integrate WSS 3.0 with SP1 with SQL Server 2005 Reporting Services with SP2 with Kerberose authentication.

And finally I'm stuck

At the moment I've got 2 issues, one is when "Set defaults" on Central Administration site, second is when I'm trying to browse the reporting server for report �� using Report Viewer webpart configuration (when selecting "Report").

Before I will go futher with errors message, here is my configuration:

WSS 3.0 with SP1 and Reporting Services Add-in:
Computer: SharePoint02 | SharePoint02.led.local
Portal url: http://sharepoint02 | http://sharepoint02.led.local
Admin url: http://sharepointadmin02 | http://sharepointadmin02.led.local
Portal App Pool: LEDSPContentPool
Admin App Pool: LEDSPConfigAcct

SQL Server 2005 with SP2, Reporting Services with SP2, WSS 3.0 with SP1 Front End:
Computer: SharePointDB | SharePointDB.led.local
Front End Portal url: http://sharepointdb | http://sharepointdb.led.local
URL to reporting services: http://sharepointdb/SPSReportServer | http://sharepointdb.led.local/SPSReportServer
Front End App Pool: LEDSPContentPool
Reporting Services App Pool: LEDSPConfigAcct
Report Server Service Account: LEDSPConfigAcct
SQL Server Account: LEDSPConfigAcct

I know I should have separate account.

Service Principals (SPContentPool):
Registered ServicePrincipalNames for CN=SPContentPool,CN=Users,DC=LED,DC=LOCAL:
HTTP/sharepoint02
HTTP/sharepoint02.led.local

Service Principals (SPConfigAcct):
Registered ServicePrincipalNames for CN=SPConfigAcct,CN=Users,DC=LED,DC=LOCAL:
HTTP/sharepointdb
HTTP/sharepointdb.led.local
MSSQLSrv/sharepointdb.led.local:1433
HTTP/sharepointadmin02.led.local
HTTP/sharepointadmin02

Reporting add-in is activated, I'm able to specify the report server (http://sharepointdb.led.local/SPSReportServer) and to grant permission.

1) FIRST ISSUE
However when I'm trying to set the defaults for Reporting Services from Central administration I'm getting following error:

The target location you specified is not supported by the report server. A report definition (.rdl), report model (.smdl), resource, or shared data source (.rsds) file must be located within a library or a folder within it. ---> The target location you specified is not supported by the report server. A report definition (.rdl), report model (.smdl), resource, or shared data source (.rsds) file must be located within a library or a folder within it.

Reporting Server error message is:
w3wp!library!1!03/12/2008-12:15:23:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ContainerTypeNotSupportedException: The target location you specified is not supported by the report server. A report definition (.rdl), report model (.smdl), resource, or shared data source (.rsds) file must be located within a library or a folder within it., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ContainerTypeNotSupportedException: The target location you specified is not supported by the report server. A report definition (.rdl), report model (.smdl), resource, or shared data source (.rsds) file must be located within a library or a folder within it.
w3wp!library!1!03/12/2008-12:15:39:: Call to GetDataSourceContentsAction(http://sharepoint02.led.local/lrs/Reports/SHAREPOINTDB.rsds).
w3wp!library!5!03/12/2008-12:15:49:: Call to GetDataSourceContentsAction(http://sharepoint02.led.local/lrs/Reports/SHAREPOINTDB.rsds).
w3wp!library!1!03/12/2008-12:15:52:: Call to GetDataSourceContentsAction(http://sharepoint02.led.local/lrs/Reports/SHAREPOINTDB.rsds).
w3wp!library!1!03/12/2008-12:15:55:: Call to GetDataSourceContentsAction(http://sharepoint02.led.local/lrs/Reports/SHAREPOINTDB.rsds).
w3wp!library!1!03/12/2008-12:16:07:: Call to GetDataSourceContentsAction(http://sharepoint02.led.local/lrs/Reports/SHAREPOINTDB.rsds).
w3wp!library!1!03/12/2008-12:16:59:: Call to GetDataSourceContentsAction(http://sharepoint02.led.local/lrs/Reports/SHAREPOINTDB.rsds).
w3wp!library!1!03/12/2008-12:17:11:: Call to GetPermissionsAction(http://sharepoint02.led.local/lrs/Reports/TestSharepoint.rdl).

This error message then repeats few times, usually always after:
w3wp!library!5!03/12/2008-11:18:16:: Call to GetSystemPropertiesAction().

2) SECOND ISSUE

When the I'm trying to add Report Viewer (I'm logged as Portal administrator) and then select the report from web part settings, I'm getting:
Server was unable to process request. ---> The request failed with HTTP status 401: Unauthorized.

When I'm looking at the Event log in SharePointDB I see Anonymous login:

Event Type: Success Audit
Event Source: Security
Event Category: Logon/Logoff
Event ID: 540
Date: 12/03/2008
Time: 12:13:07
User: NT AUTHORITYANONYMOUS LOGON
Computer: SHAREPOINTDB
Description:
Successful Network Logon:
User Name:
Domain:
Logon ID: (0x0,0x12C0209E)
Logon Type: 3
Logon Process: NtLmSsp
Authentication Package: NTLM
Workstation Name: SHAREPOINT02
Logon GUID: -
Caller User Name: -
Caller Domain: -
Caller Logon ID: -
Caller Process ID: -
Transited Services: -
Source Network Address: 10.192.65.67
Source Port: 1705

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Is there any chance to solve these issues? What did I done wrong?

I would really appreciate any help!

Cheers,
Jakub G

View 1 Replies View Related

Integrate SSRS With Report Viewer

Oct 25, 2007

Hi All,

I'm going to use report viewer to view the SSRS reports that I create. I have created bunch of reports. But I can publish only one report on report viewer. How can I publish more than one reports there just like on report manager. Can I view those reports just clicking links of each reports? How can I make links?
When I use reportview in visual studio it allows me to create only one report and when I dploy it straightaway it brings up the report in web form, but not the link like we see on report manager.
Is there anyway I can create links for each reports?

Or in other words, I want to integrate report server and report viewer. But I dont have a very good idea about report viewer.
So please can anyone explain the basic steps?

Thanks

View 1 Replies View Related

Integrate More Than One SSIS Packages Into One Package

Jan 12, 2007

Hi

I'm new to SSIS field.
I'm importing data from flat files to sql server 2005 through SSIS packages.
I have around 30 packages which transfers data from flat files to corresponding database tables.
I want a single package that will run all the 30 packages by running that single package.
Like in a single stored procedure we can run multiple stored procedure, I want the same solutions for my packages.
Is there any method which can solve the above issue???

Please kindly guide me .
Its urgent. please reply soon.

Thanks in advance.

View 20 Replies View Related

How To Integrate An Independant MDF File Into Sql Server Express?

Sep 30, 2007

Hi,i have a MDF sql server express database used by an asp.net application (located in local dir App_Data on the same computer as the Sql server).I would like to integrate it into Sql Server express. I mean: NOT only attach it, but transform it as it was created direclty into Sql server and not in Visual Web Developper tool.In Studio Management, i rightclicked on Databases and i took 'Attach'. Now i can see and manage that database from Studio Management, but it still refers to the local path of the MDF file. I see that by doing this query: select * from master...sysdatabases
How can i make it a full database of Sql server?Thanks
Tartuffe

View 4 Replies View Related