.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Imran Ghani
Post New Web Links

SQL server 2008 reporting setting

Posted By:      Posted Date: September 24, 2010    Points: 0   Category :Sql Server
 

I have an .net1.1 windows application with Reporting Service 2005 and ruunning successfully on MS SQl Server 2008 . but in some other enviroment ( have MS SQL Server 2008 Express) I am getting  below exception while executing report:

Exception: The request failed with HTTP status 401: Unauthorized. ---> System.Net.WebException: The request failed with HTTP status 401: Unauthorized.
   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 Microsoft.SQL.ReportingServices.ReportingService2005.FindItems(String Folder, BooleanOperatorEnum BooleanOperator, SearchCondition[] Conditions)
   at EYOND.MRSware.Reporting.ReportingService.GetSqlCatalogItem(ReportingService2005 rs, String fullpath)
   at EYOND.MRSware.Reporting.ReportingService.GetReport(CallContext& context, String path)


On both system SQL Server Repot Servie configuration Manager having same setting
 - Reporting Service Run under 'Network Service' Account
 - Execution Account information is blank in both places.

But if I pass the user credential to Report service then it


View Complete Post


More Related Resource Links

Need help with setting up SQL Server 2008 for role/user management

  

I've posted my problem in a few other categories.  Sorry for that.  I didn't see the security category until now.

I'm trying to use ASP.NET's built-in role/user management for a couple ASP.NET MVC 2 sites.  I'm using the MVCMusicStore as my guide.  I click on the Configuration Tool as the tutorial suggests, which launches the site administration page.  Unfortunately when I click on the security tab, I get an error that it cannot connect to the data store.  Attempting to test the AspNetSqlProvider gives me a similar error.

I've run the aspnet_regsql program as the error message suggested, and I have a role/user management database ready to go on the server.  The proper tables are constructed, and all that.  The configuration tool still doesn't see the data store.

As a test, I ran the MVCMusicStore demo in the debugger.  Its role/user management functionality worked.  I was able to add myself as a customer, and add/remove items from my cart with no errors or exceptions.  However, when I attempted to access its security tab in the configuration tool, I received the same error as I get for my own project.  How is it possible that role/user management works, but the configuration tool cannot change its settings?

Any suggestions on how I can get the configuration t

Setting up SQL Server 2008 for an ASP.NET website on IIS 6.0

  
Hi, I have a problem with setting up SQL Server 2008 for an ASP.NET website on IIS 6.0. I allways recieve the error message: "Login failed for user 'BADER-7C554BD89\ASPNET'. " What I should do? Please, I need your help,   Regards, Bader

Having problems installing/setting up SQL Server 2008 Express/R2 for ASP.NET user management on deve

  
I'm a bit new to installing and configuring, well, just about anything regarding databases, so please bear with me. I'm currently building a couple of ASP.NET MVC 2 sites.  I'm following along with the MVCMusicStore tutorial, and am trying to set up user management using ASP.NET's configuration tool.  The problem is that ASP.NET can't 'see' the database. I have SQL Server 2008 installed on my laptop.  It's the version which is available on the Web Platform Installer (I believe it's Express).  When I try running the aspnet_sqlreg.exe program to set up my user management database, it can't tell that I'm running any version of SQL Server at all.  I get an exception about 'named pipes', and some other things I don't understand at the moment. Obviously, this is all a bit over my head.  Is there an idiot proof guide or tutorial available that describes, step-by-step, how to: 1. Install SQL Server 2008 on a development PC 2. How to configure it to be used by Visual Studio 2010 Professional 3. How to properly upload/modify the db on the production server with what's on the development PC Essentially, all the things that the ASP.NET tutorials gloss over.  Any suggestions, links to documentation, or other nudges in the right direction would be immensely appreciated.

SQL Server 2008 Install failure - Reporting Services Rule Failures

  
I'm installing SQL Server 2008 on Windows 7.  I'm going through the install and on the "Installation Rules" page I have two failures: Reporting Services Catalog Database File Existance Reporting Services Catalog Temporary Database File Existance Clicking on each of the failures they both say that each file exists "Select a reporting services file-only mode installation" Clicking the "Help" button tells me to "Rename, move, or delete the files" This is the only information I can find on this exact failure.  I'm not technical enough to know exactly where these files are or what they are named.  I cannot proceed any further without correcting this issue.  I'll include some of the shorter summary log files.  I can include other detail log files if that would help. Thank you so much for any help. Select Log Files: SUMMARY GLOBAL RULES LOG: Overall summary:   Final result:                  Passed   Exit code (Decimal):           0   Exit message:                  Passed   Start time:                &n

How to save Windows credentials to a data source in SQL Server Reporting Services 2008 using Visual

  
I am trying to create a shared data source for SQL Server Reporting Services 2008 that uses a specific Windows user ID and password to connect to the database. Using the Report Manager web interface, if I create a shared data source and specify "Credentials stored securely in the report server", I can check the "Use as Windows credentials when connecting to the data source" checkbox. This tells SSRS that the user ID and password I specify are from a Windows user, not a SQL Server user. I want to create the shared data source using Visual Studio though. In Visual Studio I have an option to use stored credentials but there is no equivalent of the "Use as Windows credentials when connecting to the data source" checkbox. SSRS always assumes that user and password are for a SQL Server user, not a Windows user, and thus the connection fails. Does anyone know how to tell Visual Studio that the stored credentials are for a Windows user?

How to set the IP addresses for teh report server on sql server 2008 reporting services

  
How to assign IP address to report server on 2008 version, i don't see nothing on IIS. I have installed sql server / report server 2008 on windows 2003 server. I don't see no info in IIS, can you please help, Also how to check the configuration files i remember in 2005 version i still have to open teh configuration file in notepad and do some modifiications with teh http://local to http://IPaddress etc. Thanky ou very much for the help ful info.  

SQL Server 2008/MOSS 2007 Reporting Nightmares

  
I am having issues of the Reporting services kind...I have 2 issues in regards to executing rdl report files (excel reports work fine) when they're read through sharepoint reporting.I'll give you a rundown of the components and layout I'm using first of all. I'm going to put in as much information as I can find, so if you see things that are irrelevant it's just because I want to dump as much as I can incase it tweaks someones brain. FYI I have rebooted the computers and IIS many, many times.Servers:Both of the machines below are VMs on Xenserver. We run on a /23 network for these servers. The domain functional level is Windows 2000 mixed (yeah, I know). Devsp40: devsp40 is a Windows Server 2003 R2 SP2 Enterprise edition x64 server (winver 5.2 R2 Build 3790.srv03_sp2_rtm.070216-1710 : Service Pack 2) running MOSS 2007 Enterprise SP2 and WSS 3.0 sp2 (it recommended I install that) x64. I extracted the install files and put the updates in the update folder for installation. The IP is 10.200.200.66. It's probably worth noting that I am using a trial key for MOSS at the moment until our MSDN license comes through.Devsql40: devsql40 is a Windows Server 2008 R2 Enterprise edition x64 (winver 6.1 build 7600) running SQL Server 2008 R2 SP1 x64. The file version for sqlservr.exe is 2009.100.1352.12. The SQL instance name is default.Devsql40 also has SQL Reporting services installe

HOW TO INSTALL SQL REPORTING SERVICES on SQL SERVER 2008 R2 ?

  
I want to install  SQL REPORTING SERVICES and curretnly i have SQL SERVER 2008 R2 installed with SQL Management studio.

SQL Server Reporting Services 2008 R2 - The configuration system has already been initialized

  
After correcting issues related to .NET 4.0, I am now encountering the error below. It occurs when I attempt to access one of the two web sites. I've been tracking my install/config progress here: http://serverfault.com/questions/178353/what-would-cause-a-500-internal-server-error-when-accessing-the-report-manager-ur   Error Log: appdomainmanager!DefaultDomain!ae8!09/07/2010-14:47:12:: i INFO: Appdomain:13 ReportServer_11-11-129283588326974843 started. appdomainmanager!DefaultDomain!ae8!09/07/2010-14:47:12:: e ERROR: AppDomain ReportServer_11 failed to start. Error: The configuration system has already been initialized. library!DefaultDomain!ae8!09/07/2010-14:47:12:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: Failed to create HTTP Runtime, Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_11.  ---> System.InvalidOperationException: The configuration system has already been initialized.    at System.Configuration.ConfigurationManager.SetConfigurationSystem(IInternalConfigSystem configSystem, Boolean initComplete)    at System.Web.Configuration.HttpConfigurationSystem.EnsureInit(IConfigMapPath configMapPath, Boolean listenToFileChange

Can't connect to SQL Server 2008 Reporting Services

  
When attempting to connect to SQL Server 2008 (evaluation) on Windows XP SP3, using the following url, http://servername:8080/ReportServer I receive a popup dialog box asking me for a user name and password to connect to the server.  When I enter the domain\user and password that I think it should be, it pops up two more times and then displays a blank internet explorer web page.  It is a fresh install and I believe I have everything running correctly.   Any input or guidance would be extremely appreciated.   Thank you in advance.

Run Reporting services 2005 with databases housed on SQL Server 2008?

  
Hi, I have a RS 2005 install in which the ReportServer and ReportServerTempDB databases reside on a different SQL Server 2005 server. I am planning to upgrade both to 2008 at some point but would like to do the SQL database engine first. So I would be running something like this: Server A: SQL 2005 Reporting Services Server B: SQL 2008 database engine - housing ReportServer and ReportServerTempDB Is this configuration supported? If I do this would I just need to run the DB's in 9.0 compatibility mode until we upgrade the RS server? Would it be better to upgrade the RS box first or both of them at the same time instead of doing the database engine first?

Run Reporting services 2005 with databases housed on SQL Server 2008?

  
Hi, I posted this in the RS forum as well but was thinking it would be better here. I'm not sure if I can move a post to  a different forum or not so sorry for the double post. I have a RS 2005 install in which the ReportServer and ReportServerTempDB databases reside on a different SQL Server 2005 server. I am planning to upgrade both to 2008 at some point but would like to do the SQL database engine first. So I would be running something like this: Server A: SQL 2005 Reporting Services Server B: SQL 2008 database engine - housing ReportServer and ReportServerTempDB Is this configuration supported? If I do this would I just need to run the DB's in 9.0 compatibility mode until we upgrade the RS server? Would it be better to upgrade the RS box first or both of them at the same time instead of doing the database engine first?

How to configure SQL Server 2008 R2 Reporting Services for SSL offloading

  
Hi How to configure SQL Server 2008 R2 Reporting Services for SSL offloading? I found steps for SQL Server 2005 Reporting Service here http://technet.microsoft.com/en-us/library/ms345223(SQL.90).aspx . Will this steps work for 2008 R2 also?  Thanks

Does SQL Server 2008 R2 Express Reporting Service support Shared Datasets?

  
I have spent a few hours trying to get this to work. I am using Report Builder 3.0 (locally), with SQL Server 2008 R2 Express Edition on a remote web server. I am running Report Builder as an Admin under Win7 64bit. All is OK until I attempt a Save of a newly created shared dataset. The error message is: Failed to save dataset "mydataset.rsd" The feature "Shared dataset" is not supported in this edition of Reporting Services. Details: The feature: "Shared dataset" is not supported in this edition of Reporting Services. ---> Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: The feature: "Shared dataset" is not supported in this edition of Reporting Services. I have researched the web, and the list of features for Express Edition does not list this feature as not being supported, although it does list "Shared component library" as being missing. Could anyone please confirm the situation please. If it is  a bug, is there any fix or workaround?  John Walton  

How to integrate SQL Reporting Server 2008 R2 With SharePoint 2007

  

Hi All,

I am facing issue in configuring SQL Reporting 2008 R2 With SharePoint 2007, my enviorment details is i have already MOSS Farm and i create new SQL Server 2008 R2 for reporting services. When i brows my reporting server URL its gives me error

  • The report server has encountered a configuration error. If the report server is configured to use SharePoint integrated mode, verify that the server is joined to a SharePoint farm and that the Report Server service account has been granted access to the SharePoint farm. (rsServerConfigurationError)

my question is how to join my Reporting server with existing MOSS server?

Note: My SharePoint environment is consist of 2 Web Front End Servers and 1 Indexing Server.

regards,

iftikhar


increase initial size in SQL Server 2008 with Advanced Reporting Services

  
What is the maximum size a database using SQL Server 2008 Express with Advanced Services  can grow to?  I currently have one that is 204.44 MB with 0 space free.  Growth is set to Auto.  How can I increase the database size in this version?  I would like to allow it to be at least 400 MB?  May I simply increase the Initial Size to be 400 MB; and then increase the log file size to be 2 MB (currenlty set to 1)?  The enable autogrowth is set to grow automatically by 10 percent. 

SQL Server Reporting Service 2008 R2 - The request failed with HTTP status 401: Unauthorized.

  
I got the error "The request failed with HTTP status 401: Unauthorized." when I call the Reporting Service Web Service.

The code is very simple:

// Initialise the reporting service Web Service

this.RSWebService = new ReportingService2010();

// Pass windos authentication credentials to Web Service

this.RSWebService.Credentials = System.Net.CredentialCache.DefaultCredentials;

// List children

List<CatalogItem> reports = this.RSWebService.ListChildren(folder, false).ToList();

The SQL Server is installed on a different machine (say server A) from the Web server (say server B). We are using Windows Server 2003.

The code work fine for all the scenario below:

i) Run locally (XP) to call the web service on the sql server

ii) Provide the Network Credentials with the username, password, and domain when calling the web service

iii) If the web server and sql server is using same server (i.e. not distributed)

I'm using windows authentication and impersonation. Any idea?


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend