Do not yet understand the repercussion of this failure. For instance, the Common Language Runtime CLR should probably not be deployed, at least for most users; but we will want to be able to use it. Turn it on. I have seen various recommendations to extract and backup the symmetric encryption key; but it took a bit of a search to find out the technique.
The utility to use is named rskeymgmt. This should be run as part of every installation of reporting services and should be incorporated into the installation instructions when they are written. The symmetric encryption key is an integral part of storing encrypted data. The utility captures and stores the key in a file that can be saved on removable media and taken offsite. You will need the key if the account service changes as insignificantly as a change of the password, or if you want to connect a new report server to an existing report server database instance.
Without this key you may have no choice but to delete all encrypted data in your catalog including data source and user information. If, at some point, the encryption key for the report server instance is different from the key used to store encrypted content in the database i.
So, bottom line, store your encryption key on a floppy disk for safe keeping using rskeymgmt. There is no space between the command line flag and the password or directory name. A copy should be stored on removable media and potentially offsite. Reporting Services should be installed using SSL. This has been tested successfully on both XP and AS SQL Server should also be installed using SSL and a certificate; but that has not been covered and will be included later. The following changes are required to Reporting Services if you add a self-certification after the initial installation:.
These should be set properly if certificate is installed in IIS before installation of Reporting Services. Okay, perhaps that is not completely true. My configuration is in a domain. My configuration is not, it is only a workgroup machine. Therefore I cannot attest to this being true in Reporting Services; but the solution was gleaned working between the two.
If you leave both lines then SSL will not work properly on the site settings page, my subscriptions, and home, to name three.
You will also get the following message when you try to create a data source:. If you remove the line completely, SSL will not work. The help tab in the Report Manager still points to an http: page. If you edit the URL in the browser address to https: the help is available.
This could be an easy fix; but this is beta software and not worth any effort at this time. There is a similar problem in Visual Studio when you attempt to deploy. You get the same error message as above about a secure channel. Since our organization uses external configuration management CM tools to create builds we do not care whether this features works or not.
In fact, we would prefer the choice not to be available. This way the burden does not fall on one individual, usually in CM. Cannot connect to integration service and reporting service in GUI at same time. These are notes made for installation in a corporate development environment. They are not intended nor should they be construed as exhaustive and complete, but hopefully they will help others from experiencing similar difficulties.
Log in or register to rate. Thanks in Advance. I tried pointing it to my recently downloaded SQL Developer edition, but that failed as well. When I launched VS, the business intelligence project types were missing. I have all my files copied to hard drive and still I can't see the option of BI on my visual studio. Don't know and I waste enoph time on installing this fonctionnality. I had the same issue as well. Sometimes we don't realize something so basic could solve our issues.
The content you requested has been removed. Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums. NET development. Questions for all versions are welcome here. Sign in to vote. User posted Greetings, i have installed Visual studio professional edition but when i go to make a new project then i do not find the business intelligence projects in order to make DTS package for sql server so my question how can i install Business intelligence development studio from Visual studio professional edition??
Thursday, January 11, AM. User posted thank you for the support i make as you tell me ,copy the contents of the sql server developer edition on my hard drive and rerurn setup and he gives me the option to select the compnent to install or to upgrade so i select integration services then he tell me that this component is already installed,so i still have the same problem.
Friday, January 12, AM. Saturday, January 13, AM. User posted I told you in my first reply that BI Management Studio is separate from Visual Studio and you don't need to remove Express because it is not part of Express.
User posted Hi, You were saying that we need to rerun setup. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.
Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually.
0コメント