.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

Issue when trying to install ms sql integrated services

Posted By:      Posted Date: September 16, 2010    Points: 0   Category :Sql Server
 
Already have ms sql server 2008 web edition installed. then we needed ms sql integrated services installed. two issues: on one server as we have the ms sql 2008 web cd put in.  went to installation. then to add new features. said add features to existing installation. All boxes are checked but dimmed out.   on another server as we have the ms sql 2008 web cd put in.  went to installation. then to add new features. started the process and when it askes us if we want a new installtion or to add features to existing. i choose add to existing and as i click next i get this error message "The Instance ID is required but missing"   please let me know how i may proceed as we are trying to get integrated services installed on both servers and both are having issues.


View Complete Post


More Related Resource Links

Attempting to install a Reporting Services for MOSS 2007

  

Greetings

I am tasked with writing reports for existing MOSS 2007, for that i am doing a test installation and test connection to a test moss server (copy of the main one)

So, i have a already set and running MOSS 2007. I am following theese tutorials

http://mosshowto.blogspot.com/2009/03/reporting-services-sharepoint-multiple.html#Creating-report-Server-databases-

 

But in my case, i have only two machines - one with main site moss and one with reporting services and sql for reporting services.

So far, i have installed SQL server, installed moss and reporting services on the reporting services machine.

I joined my moss into the existing farm successfully.

I've set up reporting services according to the tutorial (Except i use an account provided by test server administrator, which has all rights granted, since we dont bother with least privellege here, not a very big company...)

But when i check the /reportingservices page i see an error (its in russian) that teh server is wrongly configured. rsServerConfigurationError is the kind of error. 

The tutorial said that i should see a blank page at this point. I will continue tutorial futher tomorrow (work day ends now

SQL Server Reporting Services not able to install on Windows Vista Home Premium

  

Recently I had a weird problem while trying to install SQL Server Reporting Service in my local PC. I am using Windows Vista Home Premium and I wanted to configure SSRS in my PC. During the installation, the setup wizard listed all the services that we want to install and I found that only Reporting Server checkbox option was disabled and I wondered why??? I thought it may be becuase of some installation problem and tried again and its useless... I googled lot of sites for 3 days and finally found that due to some IIS issues, it is not possible to install Reporting Server in Vista Home Premium version. Reporting Server needs some specific IIS features to be installed in the machine.

But unfortunately those features are not available for Home Premium users which in term restricts users not to install reporting server in our PCs... Also, Microsoft has accepted it as an issue and its not possible to get it install in Home Premium...just wanted to share and might be useful for someone like me.

Reference: http://support.microsoft.com/kb/920201/en-us



Excessive Deadlocking Reporting Services 2008 Integrated.

  
Hi, we have a major issue with deadlocking on our reporting Server TEMPDB (REPORTSERVERTEMPDB). The platform is a Sharepoint Integrated platform allong the following lines 2 WFE Servers (NLB) 2 Sharepoint application servers 2 SQL Reporting Services (NLB) Cluster hosting Sharepoint DB's Cluster hosting Reporting Services DB's and the Data. This error is occuring for both manually running reports via sharepoint and load testing, and is happening on our testing platform as well which is slightly different in configuration. Reported back to the users is "An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database" Running a profile with 1224 set, we are finding deadlocks on the REPORTSERVERTEMPDB on PK_SNAPSHOTDATA. We have tried the following 1. Dropping the PK - The deadlock was then showing an OBJID which we could not identify. 2. Change the database properties to READ-COMMITTED_SNAPSHOT and ALLOW_SNAPSHOT_ISOLATION to ON 3. Re-create and change the PK to ALLOW_PAGE_LOCKS OFF None have these have had an impact on the issue This has become apparent since the following actions were taken 1. The setting of caching has been enabled by the developers 2. The Report Server DB's were moved from the Sharepoint Cluster to the Data Cluster. I do have an XDL file from Profiler but it is to

Unable to install SP3 on SQL 2005 due to Database Services language being blank

  
Hi all,   I have an issue that requires me to upgrade to a later SP (currently on RTM), but when I try to install SP3 Database Services cannot be ticked. Upon inspection I see that its reporting "This update requires language ENU.  The language for this product instance MSSQLSERVER is . Download the upadte for langage .", when I check teh Language field to the right it is blank, other parts however are fine and can be upgraded. Can you advise please as I don't know how to manually set the language (which is reported inside SQL itself as English (United Kingdom)) and I cannot un/reinstall. Thanks, John

SQL Server 2005: Install reporting services - which version?

  
Hello - I installed SQL Server 2005 as part of an SBS2008 install. I need to install reporting services, but now I'm having trouble identifying which version (X64 or X86) I'm running. Is there an easy way of figuring out which installation disk I need to insert for SQL Server 2005? Thanks, Nick.

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

Kerberos issue with SQL Reporting Services 2005 on Server 2003 R2

  
Hi Guys,apologies if this is the incorrect forum, so moderators, feel free to move it to SQL/IIS/SharePoint as appropriate... [Windows Server Security moderator pushed me this direction]I have a test environment that I'm trying to get SQL Reporting Services 2005 SP3 working in integrated mode with SharePoint 2007 SP2.The environment is all in VMWare, running Server 2003 R2 x86 and is layed out like this:SERVER A:AD/DNS/DHCPSERVER B:SQL 2005 SP3 CU8SERVER C:SharePoint 2007 SP2 Dec 09 CU- Central admin on port 9000- SSP on port 9001- MySite on port 81- Main Content on port 80SQL Reporting Services 2005 SP3 CU8- Reporting Service website on port 82SERVER D:SharePoint 2007 SP2 Dec 09 CU- Central admin on port 9000- SSP on port 9001- MySite on port 81- Main Content on port 80SQL Reporting Services 2005 SP3 CU8- Reporting Service website on port 82Through the use of DNS and (SharePoint) Alternate Access Names, SERVER D is used to deliver the Main Content in SharePoint and the Reporting Service website.  SERVER C is used to deliver the Central Admin, SSP and MySite.I've set up SPN's for the SharePoint App Pools, using the following: [main content] setspn -S HTTP/SERVERA DOMAIN\AppPoolUserA setspn -S HTTP/SERVERA.FQDN DOMAIN\AppPoolUserA setspn -S HTTP/SERVERB DOMAIN\AppPoolUserA setspn -S HTTP/SERVERB.FQDN DOMAIN\AppPoolUserA [repor

"An error occurred during printing. (0x8000405)" eror - reporting services issue

  
We are getting this error: "An error occurred during printing. (0x8000405)" from time to time - 70% of the time when we are trying to use a printer button within report manager. It happens if we preview report or just print it. We noticed if we restart RS services, the error will stop for a little bit and then starts again. We don't print that much and it will come back after just a few reports printed. Let me know if you had a similar issue. thanks!

Help!!!! Permission issue with Analysis Services on Windows 2008 R2

  
Hi I'm with a project using Sql Server 2008 on Windows Server 2008 R2. It seems I can not connect to Analysis Services server with SA acount but only with Windows Authentication (The 'Authentication' option is diabled). And when I connect to Analysis Services with my windows acount , I do not have the permission to either create a database (ERROR:Either '***' user does not have the permission to create a new object, or the object does not exist) or grant server privilege to my windows account (ERROR: Only an administrator can make changes to server properties). Also, I failed to remote connect to Analysis Services on Server with my windows account (But I can remote connect to Database engine). Any idea?  Thanks!

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.

Reporting Services Local Install

  
I am having problems getting Reporting Services working locally on my laptop. I am running IIS 7 and have installed SQL Server Express 2008 with Advanced Services. The ReportServer database has been created. Within reporting services config my Web Service URL is http://localhost/ReportServer_SQLEXPRESS. I have created a virutal directory in IIS for ReportServer_SQLEXPRESS, converted this to an application and directed it to C:\Program Files\Microsoft SQL Server\MSRS10.SQLEXPRESS\Reporting Services\ReportServer. But when I browse to this url I get an Error: Access is denied. (0x80070005 (E_ACCESSDENIED)) Similar within reporting services config my Report Manager URL is http://localhost/Reports_SQLEXPRESS. I have created a virutal directory in IIS for Reports_SQLEXPRESS, converted this to an application and directed it to C:\Program Files\Microsoft SQL Server\MSRS10.SQLEXPRESS\Reporting Services\ReportManager. But when I browse to this url the page redirects to http://localhost/Reports_SQLEXPRESS/Pages/Folder.aspx and all I get is a blank page.   Can anyone tell me anything else I might need to check?

Reporting Services Local Install

  
I am having problems getting Reporting Services working locally on my laptop. I am running IIS 7 and have installed SQL Server Express 2008 with Advanced Services. The ReportServer database has been created. Within reporting services config my Web Service URL is http://localhost/ReportServer_SQLEXPRESS. I have created a virutal directory in IIS for ReportServer_SQLEXPRESS, converted this to an application and directed it to C:\Program Files\Microsoft SQL Server\MSRS10.SQLEXPRESS\Reporting Services\ReportServer. But when I browse to this url I get an Error: Access is denied. (0x80070005 (E_ACCESSDENIED)) Similar within reporting services config my Report Manager URL is http://localhost/Reports_SQLEXPRESS. I have created a virutal directory in IIS for Reports_SQLEXPRESS, converted this to an application and directed it to C:\Program Files\Microsoft SQL Server\MSRS10.SQLEXPRESS\Reporting Services\ReportManager. But when I browse to this url the page redirects to http://localhost/Reports_SQLEXPRESS/Pages/Folder.aspx and all I get is a blank page.   Can anyone tell me anything else I might need to check?

Shared Services Administration Issue

  
Hi, I have done all the steps in create new SSP, But at the end, When I tried to click on my SSP Name on the left navigations (E.g http://sharpointportal/ssp/admin)  I am not able to get Admin Home page. For me its showing "Page cannot be displayed" I am not sure where it went wrong. please help me for solve this issue.

Shared Services Administration Issue

  
I successfully configured the central administration sharepoint services and Shared services administration. the url like: http://sharepointportal/ssp/admin. But it is not working. Internet Explorer cannot display the webpage error displayed. please give me the solution for this issue

sql server reporting services issue

  
Hello, I have an issue with the sql server reporting services. I make a report , which uses alternate background color for each row. when i preview all seems to be done good. but when i deploy this report on report server , which is a configure as  localhost/ReportServer. when i use http://localhost/ReportServer , "Reports"  directory display which contains all the reports. then i click on my report. Problem is that alternate color for rows not refelected on first column. I do my best to sorted out this problem but in vain. please help me thanks & Regards Rajiv

SharePoint 2010 Reporting Services Integrated-mode Error

  
I am running SharePoint 2010 and Reporting Services 2008 R2 SharePoint integrated-mode. I am able to browse to the reportserver site : http://DBserver/reportserver which lists my site collections and I am able to get to the document library which holds my reports. However, when I try opening a report I get the following error: Report Server has encountered a SharePoint error. (rsSharePointError) The security validation for this page is invalid. Click Back in your Web browser, refresh the page, and try your operation again. For more information about this error navigate to the report server on the local server machine, or enable remote errors I am able to resolve that issue by going to Central Admin, Application Management, General Settings and turning Web Page Security Validation Off. But if I do that I get an error when using silverlight features like site, or list creation. Any ideas?

Access Services report issue

  
Good afternoon. We have an issue where the canned reports in a Web Assets Database site throw the following error: Report viewer failed to set the report parameter defaults for this report. Select new default parameter values from the tool pane. The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition' which cannot be upgraded. (rsInvalidReportDefinition) Actually all web databases (assets, projects, contacts) throw the same error for the canned reports however report services runs without issue on the server. The Web Assets database seems fine outside of the reports and when opened locally in access 2010 the reports run fine. We have one Sharepoint 2010 server with SQL 2008 r2 back end configured in sharepoint integration mode.  Thanks for any assistance you can offer. Cheers!   Cory  
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