Empty Column: services

Showing posts with label services. Show all posts

Thursday, March 29, 2012

End User Utility

I heard some talk in the past about a tool called Data Views, or
something close to that name, that will be the end user tool for
Reporting Services. Currently, I can't seem to find any information on
it and my company is evaluating Reporting Services. We are looking for
some sort of information on end user tools that can be used to help
them write reports with RS instead of using visual studio. Any ideas
or suggestions?
ThanksMore information on Report Builder (aka Active Views) is available here:
http://www.microsoft.com/sql/reporting/productinfo/av_activeviews.asp
More detailed information will be available closer to RS 2005 Beta 3.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Brian" <cooperb@.gmail.com> wrote in message
news:6aba6d9.0411300723.7ea6957c@.posting.google.com...
> I heard some talk in the past about a tool called Data Views, or
> something close to that name, that will be the end user tool for
> Reporting Services. Currently, I can't seem to find any information on
> it and my company is evaluating Reporting Services. We are looking for
> some sort of information on end user tools that can be used to help
> them write reports with RS instead of using visual studio. Any ideas
> or suggestions?
> Thanks

Tuesday, March 27, 2012

Encryption with Analysis Services 2005

As I understand it SSAS encrypts its data by default; however, I'm looking for strategies on encrypting data in the underlying datawarehouse. If you have a column encrypted in the datawarehouse, what are the options to expose that data, selectively of course, through Analysis Services? The only solution I've found is to bind a dimension to a view in the datasource and have that view decrypt the column. The dimension attribute could then be selectively exposed based on the role(s) the user has access to.

Is this the BEST way to do it? Are there other options and considerations? Are there any great whitepapers on this subject? I haven't found any myself.

Thanks in advance,

Terry

Havent seen any whitepapers on the subject.

Another idea for you to consider is to create a named query in Analysis Services DSV. See if you can use that to skip creating a view in relational database.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||I am working with SQL server 2005 analysis and reporting services. I am

instructed to create a cube for a database using analysis services and
then replicate it so as to produce reports online by reporting services

when requested by clients. I am able to create the cube and also deploy

the report made, in HTTP separately. But the following doubts arise
during the Cube deployment:

The Cube was created as per the requirements by my team lead. Then I
used the deployment wizard in the analysis services 2005 to convert it
into XML script. Using the SQL Management Studio I opened it as
Analysis Server scripts and used the local host as the system in the
connections windows then loaded the XML script into the Queries window
as a XMLA query and executed it. What has to be done after this in
order to use it as a production server?

Once the production server is setup and the connection is made with the

staging server, How can we set the timings to when the updating of the
production server has to be set in terms of hours, days or weeks?

Hoping these doubts would be clarified as early as possible.

Monday, March 26, 2012

Encryption not supported on SQL Server - Error Message

Hi,
When I click on the MSDB node, under Stored Packages (in Object Explorer | my local server's Integration Services), I get the following error message:
Client unable to establish connection
Encryption not supported on SQL Server. (Microsoft SQL Native Client)
I can, however successfully, enumerate File System packages.
I am running...
Microsoft SQL Server 2005 - 9.00.1187.07 (Intel X86)
May 24 2005 18:22:46
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
...on Windows Server 2003 SP1
Does anyone know what is causing this, and how to fix it?
Thanks,
krog
Appears to be related to the following post:
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=19019
...so I need to install a certificate on my computer. Idea

Am now checking whether I can use the MakeCert utility to address this.
|||Did MakeCert resolve this - if so, would you please post the entire process - having same problem - thx|||If you installed your SQL Server 2005 as an named instance with a default SQL Server 2000 on the machine, you might need to change the SSIS configuration file to point the MSDB to the right instance. After changing the configuration file, you need to restart the SSIS service.|||To Add to Roro

Edit the config file MsDtsSrvr.ini.xml in C:\Program Files\Microsoft SQL Server\90\DTS\Binn as follwos:

=====================================
<?xml version="1.0" encoding="utf-8"?>
<DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown>
<TopLevelFolders>
<Folder xsi:type="SqlServerFolder">
<Name>MSDB</Name>
<ServerName>SQL_2K5_SERVER_NAME</ServerName>
</Folder>
<Folder xsi:type="FileSystemFolder">
<Name>File System</Name>
<StorePath>..\Packages</StorePath>
</Folder>
</TopLevelFolders>
</DtsServiceConfiguration>
===============================

The original value for <ServerName> is just a dot (.)|||

Thanks a lot for your replies, people! I ran into the same problem and this thread helped me saved a bunch of time!! :)

|||

Yep, agree to that, thanks for the post. Restarted SSIS and it worked a treat.

Cheers - R.

|||What was resolution? Even I am also running into same problem as I have 2 SQL instances on same server

Encryption not supported on SQL Server - Error Message

Edit the config file MsDtsSrvr.ini.xml in C:\Program Files\Microsoft SQL Server\90\DTS\Binn as follwos:

The original value for <ServerName> is just a dot (.)|||

Thanks a lot for your replies, people! I ran into the same problem and this thread helped me saved a bunch of time!! :)

|||

Yep, agree to that, thanks for the post. Restarted SSIS and it worked a treat.

Cheers - R.

|||What was resolution? Even I am also running into same problem as I have 2 SQL instances on same server

Encryption not supported on SQL Server - Error Message

Edit the config file MsDtsSrvr.ini.xml in C:\Program Files\Microsoft SQL Server\90\DTS\Binn as follwos:

The original value for <ServerName> is just a dot (.)|||

Thanks a lot for your replies, people! I ran into the same problem and this thread helped me saved a bunch of time!! :)

|||

Yep, agree to that, thanks for the post. Restarted SSIS and it worked a treat.

Cheers - R.

|||What was resolution? Even I am also running into same problem as I have 2 SQL instances on same server

Encryption not supported on SQL Server - Error Message

Edit the config file MsDtsSrvr.ini.xml in C:\Program Files\Microsoft SQL Server\90\DTS\Binn as follwos:

The original value for <ServerName> is just a dot (.)|||

Thanks a lot for your replies, people! I ran into the same problem and this thread helped me saved a bunch of time!! :)

|||

Yep, agree to that, thanks for the post. Restarted SSIS and it worked a treat.

Cheers - R.

|||What was resolution? Even I am also running into same problem as I have 2 SQL instances on same serversql

Encryption not supported on SQL Server - Error Message

Edit the config file MsDtsSrvr.ini.xml in C:\Program Files\Microsoft SQL Server\90\DTS\Binn as follwos:

The original value for <ServerName> is just a dot (.)|||

Thanks a lot for your replies, people! I ran into the same problem and this thread helped me saved a bunch of time!! :)

|||

Yep, agree to that, thanks for the post. Restarted SSIS and it worked a treat.

Cheers - R.

|||What was resolution? Even I am also running into same problem as I have 2 SQL instances on same server

Encryption not supported on SQL Server

Hi,
I have a problem with Integration services. When connecting to
Integration services in Management studio and clicking on MSDB, I get
the error:
Encryption not supported on SQL Server. (Microsoft SQL Native Client)
Integration Services
This problem occured after all files were deleted by mistake from:
..\Application Data\Microsoft\Crypto\RSA
SQL Server 2000 client tools(only) were also installed on the box.
There is one package installed in msdb that was working fine before.
Server: sql server 2005 Standard
OS: Windows 2003 Standard
Asim.To add to the post above,
I changed the file:MsDtsSrvr.ini.xml
and replaced the "." with the sql server name for the tag: <ServerName>
Restarted sql, agent and integration services but still get the same
error.
Asim.

Encryption not supported on SQL Server

Encryption Keys (Reporting Services Configuration)

Ok I am playing around with SQL Server 2005 got it all setup. Then I decided to change the admin password and run dcpromo. Now I got all the issues resolved except this one. It had a key from what the server use to be called. I deleted it to make a new key for the state of the server now. Well big mistake I am finding out. Below are the only real directions I have found to recreate the key and it is not a lot of help. Does anyone know how to do this? Not like SQL Server 2000 to many choices and I got click happy on over load. Thanks in advance...

SQL Server Setup Help

Encryption Keys (Reporting Services Configuration)
Delete
Deletes the symmetric key and all encrypted content, including connection strings and stored credentials. You should only delete the symmetric key if you cannot restore it.

Once you delete the symmetric key, you must re-enter the missing connection strings and stored credentials in the reports and shared data sources that no longer have these values. You must also update all subscriptions that use delivery extensions that store encrypted data. This includes the file share delivery extension and any third-party delivery extension that use encrypted value.

There is no automated way to update this information. Each report, subscription, and shared data source that uses stored credentials and connection strings must be updated one at a time.

Initialization (Reporting Services Configuration)
Remove
Click Remove to remove the encryption keys of the selected report server instance from the report server database. You can remove keys to remove a report server from a scale-out deployment. With this option, only the encryption keys for the specified report server instance are removed. Encrypted data in the report server database is not affected.

As a precaution, be sure to create a backup copy of the symmetric key before you remove it. Once you remove the encryption keys of the last report server in the list, you introduce new requirements for any subsequent report server initialization for that database. The new requirement is that after you initialize a report server you must restore a backup copy of the symmetric key. Restoring the symmetric key is necessary if you want to access the encrypted data that is currently in the report server database.

If you no longer need the encrypted data or if you do not have a backup copy of the key, you must delete the encrypted data. For more information, see Encryption Keys (Reporting Services Configuration).

Event Viewer Log

Event Type: Error
Event Source: Report Server Windows Service (MSSQLSERVER)
Event Category: Management
Event ID: 107
Date: 2/9/2006
Time: 11:13:32 PM
User: N/A
Computer: VM-IPDG3
Description:
Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.

If you don't have a backup of your key and you've deleted it, then the only thing you could do is to create a new key. From the "Encryption keys" panel in the config tool, click "change". By now you've lost all secure information, so you should reenter them. You need to redo the "Database setup" panel, and the credentials for data sources.|||

James Wu

Thanks for the reply I will try this when I get home. On the "Encyption Keys" panel in the configure reporting sections if memory serves me. The Change was disabled and the only two buttons out of the four I could click were Restore and Delete. The Change and Backup buttons were disabled. Can you supply a step by step to get where you are talking about.

I know if you go into

Microsoft SQL Server 2005|||

Yes your are right. "Change" and "Backup" will be disabled if your report server is not initialized. Here is a more detailed article on how to delete and recreate encryption keys :) http://msdn2.microsoft.com/en-us/library/ms156010.aspx

|||

James Wu

Thanks for the link I will research it now. I am using vmware so I reverted back a snapshot and started over. Made a few dumb errors that I should have been smarter not to do. Thanks Again

Encryption Key

I am getting the following error while configuring the reporting services on
my local machine. I cannot restore the key as I do not know the file or the
password.
Somebody please help!
ReportServicesConfigUI.WMIProvider.WMIProviderException: The encrypted value
for the "LogonCred" configuration setting cannot be decrypted.
(rsFailedToDecryptConfigInformation)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.DeleteEncryptedInformation()Hello,
Are you installing a new version of Reporting Services (with clear
ReportServer database) or just reinstalling it with using previous version
of ReportServer database'
It looks like that you've reinstalled Reporting Services without recovering
previous encryption key.
If you don't have any copy of your previous encryption key, the only way to
make Reporting Services content available is to delete all unusable
encrypted data from ReportServer database.
Follow these steps to apply the encryption key to the report server
database:
1.. Run rskeymgmt.exe locally on the computer that hosts the report
server. You must use the -d apply argument. The following example
illustrates the argument you must specify:
rskeymgmt -d
2.. Restart Internet Information Service (IIS).
After the values are removed, you must re-specify the values as follows:
1.. Run rsconfig utility to specify a report server connection. This step
replaces the report server connection information. For more information, see
Configuring a Report Server Connection and rsconfig Utility.
2.. If you are supporting unattended report execution for reports that do
not use credentials, run rsconfig to specify the account used for this
purpose. For more information, see Configuring an Account for Unattended
Report Processing.
3.. For each report and shared data source that uses stored credentials,
you must retype the user name and password. For more information, see
Specifying Credential and Connection Information.
4.. Open and resave each subscription. Subscriptions retain residual
information about the encrypted credentials deleted during the rskeymgmt
delete operation. You can update the subscription by opening and saving it.
You do not need to modify or recreate it.
I hope this infomation will helpful.
Best Regards,
Radoslaw Lebkowski
U¿ytkownik "RouteC" <RouteC@.discussions.microsoft.com> napisa³ w wiadomo¶ci
news:D246447F-1622-4230-AC73-71D0F1073C11@.microsoft.com...
>I am getting the following error while configuring the reporting services
>on
> my local machine. I cannot restore the key as I do not know the file or
> the
> password.
> Somebody please help!
> ReportServicesConfigUI.WMIProvider.WMIProviderException: The encrypted
> value
> for the "LogonCred" configuration setting cannot be decrypted.
> (rsFailedToDecryptConfigInformation)
> at
> ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject
> mo)
> at
> ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.DeleteEncryptedInformation()|||Hi Rad,
The very first step in trying to delete the key is giving me the same
exception which is ReportServicesConfigUI.WMIProvider.WMIProviderException:
The encrypted value
for the "LogonCred" configuration setting cannot be decrypted.
rskeymgmt -d -i instance
This is completely new installation in 2steps.
1. Installed sql server 2005 with all other services except reporting
services as iis was not installed at that time.
2. Installed reporting services.
"Radoslaw Lebkowski" wrote:
> Hello,
> Are you installing a new version of Reporting Services (with clear
> ReportServer database) or just reinstalling it with using previous version
> of ReportServer database'
> It looks like that you've reinstalled Reporting Services without recovering
> previous encryption key.
> If you don't have any copy of your previous encryption key, the only way to
> make Reporting Services content available is to delete all unusable
> encrypted data from ReportServer database.
> Follow these steps to apply the encryption key to the report server
> database:
> 1.. Run rskeymgmt.exe locally on the computer that hosts the report
> server. You must use the -d apply argument. The following example
> illustrates the argument you must specify:
> rskeymgmt -d
> 2.. Restart Internet Information Service (IIS).
> After the values are removed, you must re-specify the values as follows:
> 1.. Run rsconfig utility to specify a report server connection. This step
> replaces the report server connection information. For more information, see
> Configuring a Report Server Connection and rsconfig Utility.
> 2.. If you are supporting unattended report execution for reports that do
> not use credentials, run rsconfig to specify the account used for this
> purpose. For more information, see Configuring an Account for Unattended
> Report Processing.
> 3.. For each report and shared data source that uses stored credentials,
> you must retype the user name and password. For more information, see
> Specifying Credential and Connection Information.
> 4.. Open and resave each subscription. Subscriptions retain residual
> information about the encrypted credentials deleted during the rskeymgmt
> delete operation. You can update the subscription by opening and saving it.
> You do not need to modify or recreate it.
> I hope this infomation will helpful.
> Best Regards,
> Radoslaw Lebkowski
>
> UÂ¿ytkownik "RouteC" <RouteC@.discussions.microsoft.com> napisaÂ³ w wiadomoÂ¶ci
> news:D246447F-1622-4230-AC73-71D0F1073C11@.microsoft.com...
> >I am getting the following error while configuring the reporting services
> >on
> > my local machine. I cannot restore the key as I do not know the file or
> > the
> > password.
> > Somebody please help!
> >
> > ReportServicesConfigUI.WMIProvider.WMIProviderException: The encrypted
> > value
> > for the "LogonCred" configuration setting cannot be decrypted.
> > (rsFailedToDecryptConfigInformation)
> > at
> > ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject
> > mo)
> > at
> > ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.DeleteEncryptedInformation()
>
>|||Hmm, that's a little strange situation.
Under the following link there is a very similar problem with LogonCred
decryption problem.
http://groups.google.pl/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/ec7858be1ef25e24/9f72570a671b74e7?lnk=st&q=LogonCred+decrypted&rnum=1&hl=pl#9f72570a671b74e7
Maybe you have problem with authorization a connection to ReportServer
database (bad values contained in RSReportServer.config file used to connect
to the report server database)
Try to use rsconfig utility described below
http://msdn2.microsoft.com/en-us/library/aa179654(SQL.80).aspx
Regards
Radoslaw Lebkowski
U¿ytkownik "RouteC" <RouteC@.discussions.microsoft.com> napisa³ w wiadomo¶ci
news:7BC3B705-71DF-4B48-93FE-6959E94A51FF@.microsoft.com...
> Hi Rad,
> The very first step in trying to delete the key is giving me the same
> exception which is
> ReportServicesConfigUI.WMIProvider.WMIProviderException:
> The encrypted value
> for the "LogonCred" configuration setting cannot be decrypted.
> rskeymgmt -d -i instance
> This is completely new installation in 2steps.
> 1. Installed sql server 2005 with all other services except reporting
> services as iis was not installed at that time.
> 2. Installed reporting services.
> "Radoslaw Lebkowski" wrote:
>> Hello,
>> Are you installing a new version of Reporting Services (with clear
>> ReportServer database) or just reinstalling it with using previous
>> version
>> of ReportServer database'
>> It looks like that you've reinstalled Reporting Services without
>> recovering
>> previous encryption key.
>> If you don't have any copy of your previous encryption key, the only way
>> to
>> make Reporting Services content available is to delete all unusable
>> encrypted data from ReportServer database.
>> Follow these steps to apply the encryption key to the report server
>> database:
>> 1.. Run rskeymgmt.exe locally on the computer that hosts the report
>> server. You must use the -d apply argument. The following example
>> illustrates the argument you must specify:
>> rskeymgmt -d
>> 2.. Restart Internet Information Service (IIS).
>> After the values are removed, you must re-specify the values as follows:
>> 1.. Run rsconfig utility to specify a report server connection. This
>> step
>> replaces the report server connection information. For more information,
>> see
>> Configuring a Report Server Connection and rsconfig Utility.
>> 2.. If you are supporting unattended report execution for reports that
>> do
>> not use credentials, run rsconfig to specify the account used for this
>> purpose. For more information, see Configuring an Account for Unattended
>> Report Processing.
>> 3.. For each report and shared data source that uses stored
>> credentials,
>> you must retype the user name and password. For more information, see
>> Specifying Credential and Connection Information.
>> 4.. Open and resave each subscription. Subscriptions retain residual
>> information about the encrypted credentials deleted during the rskeymgmt
>> delete operation. You can update the subscription by opening and saving
>> it.
>> You do not need to modify or recreate it.
>> I hope this infomation will helpful.
>> Best Regards,
>> Radoslaw Lebkowski
>>
>> U?ytkownik "RouteC" <RouteC@.discussions.microsoft.com> napisa3 w
>> wiadomo?ci
>> news:D246447F-1622-4230-AC73-71D0F1073C11@.microsoft.com...
>> >I am getting the following error while configuring the reporting
>> >services
>> >on
>> > my local machine. I cannot restore the key as I do not know the file
>> > or
>> > the
>> > password.
>> > Somebody please help!
>> >
>> > ReportServicesConfigUI.WMIProvider.WMIProviderException: The encrypted
>> > value
>> > for the "LogonCred" configuration setting cannot be decrypted.
>> > (rsFailedToDecryptConfigInformation)
>> > at
>> > ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject
>> > mo)
>> > at
>> > ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.DeleteEncryptedInformation()
>>

Encryption error processing cube with Visual Studio 2005 Analysis Services

Hi!

I am trying to process a cube in analysis services of visual studio
2005, with sql server 2005. The error is:

"Errors in the encryption library: Failed to encrypt sensitive data.
Possibly the encryption key is inaccessible because of improper service
account change."

Please, if anyone know how to solve this eror, please let me know...

Cristovao

We seem to have this problem as well. Any answers to this one? Our datawarehouse was well and running for 4 months now until this weekend when we got this problem. Havent solved this yet.|||

Hi Cristavo

I also experienced the same error when I tried to configure the datasource property of my OLAP database. In the Data Source Properties dialog box, I've set the connection string and leave the security settings to its default value "ImpersonateServiceAccount" and the errors shows up when clicking the OK.

Larry

Encryption error processing cube with Visual Studio 2005 Analysis Services

Hi!

I am trying to process a cube in analysis services of visual studio
2005, with sql server 2005. The error is:

"Errors in the encryption library: Failed to encrypt sensitive data.
Possibly the encryption key is inaccessible because of improper service
account change."

Please, if anyone know how to solve this eror, please let me know...

Cristovao

We seem to have this problem as well. Any answers to this one? Our datawarehouse was well and running for 4 months now until this weekend when we got this problem. Havent solved this yet.|||

Hi Cristavo

Larry

sql

Sunday, March 11, 2012

Encrypted data in a report

I'm new to RS but how does one deal with encrypted data
within reporting services.
That is we have a table that has encrypted data. Is there
fuctionality within RS that allows the decrypting of that
data in generation of the report.
If there is, someone point me in the right direction.
Thanks,
WarrenUse embedded code or a custom assembly. Check
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_expressions_v1_84f9.asp?frame=true
and
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_rdl_6d0i.asp?frame=true
for details.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Warren Smith" <anonymous@.discussions.microsoft.com> wrote in message
news:978801c478b4$9af1f0d0$a401280a@.phx.gbl...
> I'm new to RS but how does one deal with encrypted data
> within reporting services.
> That is we have a table that has encrypted data. Is there
> fuctionality within RS that allows the decrypting of that
> data in generation of the report.
> If there is, someone point me in the right direction.
> Thanks,
> Warren
>
>

Sunday, February 26, 2012

Enabling full text search on existing sql server instance

I have an existing instance of sql express 2005 w/advanced services installed. When I installed I did not install full text search. Is there a way I can enable full text search on this existing instance?

Thanks

Try this:

sp_configure 'user instances enabled', '0'

sp_fulltext_database 'enable'

Then go ahead and try create your catalogs and indexes as normal.

Friday, February 24, 2012

Enable SSL

I have read the MSDN articles about setting up SSL on the SQL server. I am
running Microsoft Certificate services on my network as well. The article t
alks about the following
Enter the fully qualified domain name of your computer in the Name: text box
. Ping your computer to get the fully qualified domain name if you are not s
ure what it is.
In the Intended Purpose section, change the selection to Server Authenticati
on Certificate by using the drop-down list box from the Client Authenticatio
n Certificate.
I cannot seem to find these options anywhere...How do I change the FQDN if I
have no name field...I don't even have an intended purpose dropdown list.
I can issue a computer certificate from the MMC on the SQL Server but it doe
s not use the FQDN of the c
luster I am trying to setup. How can I get this to work if I cannot see the
options that these articles are telling me? I am logging in with Domain Ad
min rights as well.
Ignore my last post...I forgot my email address...That article is if you make a http request to a Standalone Certificate
Cerver.
If you have a standalone CA you have to use http request to request the
cert. Follow this article:
276553 HOW TO: Enable SSL Encryption for SQL Server 2000 with Certificate
Server
http://support.microsoft.com/?id=276553
If you installed the Enterprise CA as part of Active Directory, then you
can use MMC. Follow this article.
316898 HOW TO: Enable SSL Encryption for SQL Server 2000 with Microsoft
http://support.microsoft.com/?id=316898
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

enable reomte error

Hello,
I got the error:
______________________
Reporting Services Error
* For more information about this error navigate to the report
server on the local server machine, or enable remote errors SQL Server
Reporting Services
______________________
I saw the answer:
"You could set the "EnableRemoteErrors" configuration value to True in
the ReportServer.ConfigurationInfo database table."
How can I get to the ReportServer.ConfigurationInfo database table?
I am on the reportservice server and I run "reporting services
configuration manager" and the "sql server managment". I didn't saw
that option :(
Where is this configuration?
Any help?
Thanks.Hello,
Follow the steps below.
Enable remote errors through script
Create a text file and copy the following script into the file.
Public Sub Main()
Dim P As New [Property]()
P.Name = "EnableRemoteErrors"
P.Value = True
Dim Properties(0) As [Property]
Properties(0) = P
Try
rs.SetSystemProperties(Properties)
Console.WriteLine("Remote errors enabled.")
Catch SE As SoapException
Console.WriteLine(SE.Detail.OuterXml)
End Try
End Sub
Save the file as EnableRemoteErrors.rss.
Click Start, point to Run, type cmd, and click OK to open a command prompt
window.
Navigate to the directory that contains the .rss file you just created.
Type the following command line, replacing servername with the actual name
of your server:
rs -i EnableRemoteErrors.rss -s http://servername/ReportServer
Best regards,
Radoslaw Lebkowski
Uzytkownik "nicknack" <roezohar@.gmail.com> napisal w wiadomosci
news:1170747019.500396.131190@.v45g2000cwv.googlegroups.com...
> Hello,
> I got the error:
> ______________________
> Reporting Services Error
> * For more information about this error navigate to the report
> server on the local server machine, or enable remote errors SQL Server
> Reporting Services
> ______________________
>
> I saw the answer:
> "You could set the "EnableRemoteErrors" configuration value to True in
> the ReportServer.ConfigurationInfo database table."
> How can I get to the ReportServer.ConfigurationInfo database table?
> I am on the reportservice server and I run "reporting services
> configuration manager" and the "sql server managment". I didn't saw
> that option :(
> Where is this configuration?
> Any help?
> Thanks.
>|||Hi Radoslaw,
Thanks for the replay.
Is that the only way?
Isn't there any simple way to change this with one of the
configuration tools?
If not, I'll use the script you sent me.
Thanks again.
Radoslaw Lebkowski =D7=9B=D7=AA=D7=91:
> Hello,
> Follow the steps below.
> Enable remote errors through script
> Create a text file and copy the following script into the file.
> Public Sub Main()
> Dim P As New [Property]()
> P.Name =3D "EnableRemoteErrors"
> P.Value =3D True
> Dim Properties(0) As [Property]
> Properties(0) =3D P
> Try
> rs.SetSystemProperties(Properties)
> Console.WriteLine("Remote errors enabled.")
> Catch SE As SoapException
> Console.WriteLine(SE.Detail.OuterXml)
> End Try
> End Sub
> Save the file as EnableRemoteErrors.rss.
> Click Start, point to Run, type cmd, and click OK to open a command prompt
> window.
> Navigate to the directory that contains the .rss file you just created.
> Type the following command line, replacing servername with the actual name
> of your server:
> rs -i EnableRemoteErrors.rss -s http://servername/ReportServer
> Best regards,
> Radoslaw Lebkowski
>
> Uzytkownik "nicknack" <roezohar@.gmail.com> napisal w wiadomosci
> news:1170747019.500396.131190@.v45g2000cwv.googlegroups.com...
> > Hello,
> > I got the error:
> > ______________________
> > Reporting Services Error
> >
> > * For more information about this error navigate to the report
> > server on the local server machine, or enable remote errors SQL Server
> > Reporting Services
> > ______________________
> >
> >
> > I saw the answer:
> > "You could set the "EnableRemoteErrors" configuration value to True in
> > the ReportServer.ConfigurationInfo database table."
> >
> > How can I get to the ReportServer.ConfigurationInfo database table?
> >
> > I am on the reportservice server and I run "reporting services
> > configuration manager" and the "sql server managment". I didn't saw
> > that option :(
> >
> > Where is this configuration?
> >
> > Any help?
> > Thanks.
> >|||I think you can also use Enterprise Manager (for SQL 2000 database) or SQL
2005 Management Studio (for SQL 2005 server)
to change this value in ReportServer.ConfigurationInfo database table.
You have to connect to database server and ReportServer database and then
change value in ConfigurationInfo table.
Radoslaw Lebkowski
U¿ytkownik "nicknack" <roezohar@.gmail.com> napisa³ w wiadomo¶ci
news:1170768672.373595.150750@.k78g2000cwa.googlegroups.com...
Hi Radoslaw,
Thanks for the replay.
Is that the only way?
Isn't there any simple way to change this with one of the
configuration tools?
If not, I'll use the script you sent me.
Thanks again.
Radoslaw Lebkowski ?:
> Hello,
> Follow the steps below.
> Enable remote errors through script
> Create a text file and copy the following script into the file.
> Public Sub Main()
> Dim P As New [Property]()
> P.Name = "EnableRemoteErrors"
> P.Value = True
> Dim Properties(0) As [Property]
> Properties(0) = P
> Try
> rs.SetSystemProperties(Properties)
> Console.WriteLine("Remote errors enabled.")
> Catch SE As SoapException
> Console.WriteLine(SE.Detail.OuterXml)
> End Try
> End Sub
> Save the file as EnableRemoteErrors.rss.
> Click Start, point to Run, type cmd, and click OK to open a command prompt
> window.
> Navigate to the directory that contains the .rss file you just created.
> Type the following command line, replacing servername with the actual name
> of your server:
> rs -i EnableRemoteErrors.rss -s http://servername/ReportServer
> Best regards,
> Radoslaw Lebkowski
>
> Uzytkownik "nicknack" <roezohar@.gmail.com> napisal w wiadomosci
> news:1170747019.500396.131190@.v45g2000cwv.googlegroups.com...
> > Hello,
> > I got the error:
> > ______________________
> > Reporting Services Error
> >
> > * For more information about this error navigate to the report
> > server on the local server machine, or enable remote errors SQL Server
> > Reporting Services
> > ______________________
> >
> >
> > I saw the answer:
> > "You could set the "EnableRemoteErrors" configuration value to True in
> > the ReportServer.ConfigurationInfo database table."
> >
> > How can I get to the ReportServer.ConfigurationInfo database table?
> >
> > I am on the reportservice server and I run "reporting services
> > configuration manager" and the "sql server managment". I didn't saw
> > that option :(
> >
> > Where is this configuration?
> >
> > Any help?
> > Thanks.
> >|||Thanks,
I'll try to find this elusive ReportServer.ConfigurationInfo database
Take care,
Roy.
Radoslaw Lebkowski =D7=9B=D7=AA=D7=91:
> I think you can also use Enterprise Manager (for SQL 2000 database) or SQL
> 2005 Management Studio (for SQL 2005 server)
> to change this value in ReportServer.ConfigurationInfo database table.
> You have to connect to database server and ReportServer database and then
> change value in ConfigurationInfo table.
>
> Radoslaw Lebkowski
>
>
> U=C2=BFytkownik "nicknack" <roezohar@.gmail.com> napisa=C2=B3 w wiadomo=C2==B6ci
> news:1170768672.373595.150750@.k78g2000cwa.googlegroups.com...
> Hi Radoslaw,
> Thanks for the replay.
> Is that the only way?
> Isn't there any simple way to change this with one of the
> configuration tools?
> If not, I'll use the script you sent me.
> Thanks again.
> Radoslaw Lebkowski ?:
> > Hello,
> >
> > Follow the steps below.
> >
> > Enable remote errors through script
> > Create a text file and copy the following script into the file.
> > Public Sub Main()
> > Dim P As New [Property]()
> > P.Name =3D "EnableRemoteErrors"
> > P.Value =3D True
> > Dim Properties(0) As [Property]
> > Properties(0) =3D P
> > Try
> > rs.SetSystemProperties(Properties)
> > Console.WriteLine("Remote errors enabled.")
> > Catch SE As SoapException
> > Console.WriteLine(SE.Detail.OuterXml)
> > End Try
> > End Sub
> > Save the file as EnableRemoteErrors.rss.
> > Click Start, point to Run, type cmd, and click OK to open a command pro=mpt
> > window.
> > Navigate to the directory that contains the .rss file you just created.
> > Type the following command line, replacing servername with the actual n=ame
> > of your server:
> > rs -i EnableRemoteErrors.rss -s http://servername/ReportServer
> >
> > Best regards,
> > Radoslaw Lebkowski
> >
> >
> > Uzytkownik "nicknack" <roezohar@.gmail.com> napisal w wiadomosci
> > news:1170747019.500396.131190@.v45g2000cwv.googlegroups.com...
> > > Hello,
> > > I got the error:
> > > ______________________
> > > Reporting Services Error
> > >
> > > * For more information about this error navigate to the report
> > > server on the local server machine, or enable remote errors SQL Server
> > > Reporting Services
> > > ______________________
> > >
> > >
> > > I saw the answer:
> > > "You could set the "EnableRemoteErrors" configuration value to True in
> > > the ReportServer.ConfigurationInfo database table."
> > >
> > > How can I get to the ReportServer.ConfigurationInfo database table?
> > >
> > > I am on the reportservice server and I run "reporting services
> > > configuration manager" and the "sql server managment". I didn't saw
> > > that option :(
> > >
> > > Where is this configuration?
> > >
> > > Any help?
> > > Thanks.
> > >

enable remote errors option?

Hello,

Reporting Services 2005 error messagess always state that for details the report should be run on the local machine or that remote errors should be enabled.

It might be a silly question, but how does one enable the remote errors?
I searched the BOL and the net but found no clues, just many error samples Big Smile

We are facing situations where we can not log onto the server and rune the report from localhost/Reports....

ThanksNot sure but sounds like a .net error - it may be in the .config files?
CustomErrors="RemoteOnly" should be CustomErrors="Off" or something to that effect.|||

You could set the "EnableRemoteErrors" configuration value to True in the ReportServer.ConfigurationInfo database table.

Alternatively, you can use the SetSystemProperties SOAP call:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_lz_63le.asp

-- Robert

|||Hi Robert,

Thanks. Thats what I was looking for. How about adding that to the Site settings form on the report manager?

P.S. I had to restart iis (5.0 ...) to make it take effect.

Thanks again for the quick reply

Sunday, February 19, 2012

Enable Email Delivery of Reports

We have just installed SQL Server and Reporting Services. I'm trying to
setup automatic EMAIL delivery of some reports, but the only option I have
is to deliver to a file share.
How can I enable email delivery as a delivery option on SSRS? Thanks a ton
for your help.It won't be an option until you configure RS with an email source. You have
several options for this. My company has a smtp server around that does not
require a password to use to send email. Use the Reporting Services
Configuration tool to configure it for email.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"HBJimmie" <someone@.mydomain.com> wrote in message
news:4FFAADAD-A502-473B-96FB-2C5C525A495A@.microsoft.com...
> We have just installed SQL Server and Reporting Services. I'm trying to
> setup automatic EMAIL delivery of some reports, but the only option I have
> is to deliver to a file share.
> How can I enable email delivery as a delivery option on SSRS? Thanks a ton
> for your help.

Friday, February 17, 2012

Empty RS Home-folder after changing IIS properties

Hi,
I've installed Reporting Services on my laptop and built some folders and
reports, works great. But when other persons tried to access my reports they
only got an empty Home-folder when connecting (to http://myserver/Reports). I
tried to change properties at IIS/default website/reports/properties
(directory security/anonymous access and auth control/anonymous access) and
after that also I get an empty Home-folder. I can do/see nothing! As you
already noticed I'm a total newbie to webservers/security/domains etc. Any
tips to get the access to my reports back ? I've changed nothing but IIS
props.
/jerome kThis is not an IIS issue. You have to go in and set security on your folders in
Report Manager. Users must have at least Browser permissions to see anything in
the folders, including your root folder.
/jerome k wrote:
> Hi,
> I've installed Reporting Services on my laptop and built some folders and
> reports, works great. But when other persons tried to access my reports they
> only got an empty Home-folder when connecting (to http://myserver/Reports). I
> tried to change properties at IIS/default website/reports/properties
> (directory security/anonymous access and auth control/anonymous access) and
> after that also I get an empty Home-folder. I can do/see nothing! As you
> already noticed I'm a total newbie to webservers/security/domains etc. Any
> tips to get the access to my reports back ? I've changed nothing but IIS
> props.
> /jerome k|||The problem here is when you set anonymous then everybody is treated the
same, i.e. not given access. Change IIS back the way it was. Then create a
local group and put the people you want to have access to it in the group.
Next read up about roles. RS is role based. You have to put Window users or
groups into a role (using Report Manager). The window user or group can
either be local or domain. I create a local group and then add my domain
user and groups to the local group.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"/jerome k" <jeromek@.discussions.microsoft.com> wrote in message
news:1C173666-89C0-46EC-86E2-360F3202095D@.microsoft.com...
> Hi,
> I've installed Reporting Services on my laptop and built some folders and
> reports, works great. But when other persons tried to access my reports
> they
> only got an empty Home-folder when connecting (to
> http://myserver/Reports). I
> tried to change properties at IIS/default website/reports/properties
> (directory security/anonymous access and auth control/anonymous access)
> and
> after that also I get an empty Home-folder. I can do/see nothing! As you
> already noticed I'm a total newbie to webservers/security/domains etc. Any
> tips to get the access to my reports back ? I've changed nothing but IIS
> props.
> /jerome k

Thursday, March 29, 2012

End User Utility

Tuesday, March 27, 2012

Encryption with Analysis Services 2005

Monday, March 26, 2012

Encryption not supported on SQL Server - Error Message

Encryption not supported on SQL Server - Error Message

Encryption not supported on SQL Server - Error Message

Encryption not supported on SQL Server - Error Message

Encryption not supported on SQL Server - Error Message

Encryption not supported on SQL Server

Encryption not supported on SQL Server

Encryption Keys (Reporting Services Configuration)

Encryption Key

Encryption error processing cube with Visual Studio 2005 Analysis Services

Encryption error processing cube with Visual Studio 2005 Analysis Services

Sunday, March 11, 2012

Encrypted data in a report

Sunday, February 26, 2012

Enabling full text search on existing sql server instance

Friday, February 24, 2012

Enable SSL

enable reomte error

enable remote errors option?

Sunday, February 19, 2012

Enable Email Delivery of Reports

Friday, February 17, 2012

Empty RS Home-folder after changing IIS properties

Empty Column

Blog Archive

About Me