BUG?: Deploy to non-trusted SSL site will fail

If I try to deploy report solution to SSL site which I do not trust
(certificate not in Trusted Root) the deployment will fail.
It would be better to pop-up the dialog to choose to trust or not (like the
dialog in IE).Hi Dinko:
I take it you are deploying with the web service? It's a pain, but you
can create a class implementing the ICertificatePolicy class to
determine what certificates you'll allow your script / application to
trust.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemneticertificatepolicyclasstopic.asp
--
Scott
http://www.OdeToCode.com/blogs/scott/
On Tue, 2 Nov 2004 14:29:34 +0100, "Dinko Deranja" <dd@.dd.dd> wrote:
>If I try to deploy report solution to SSL site which I do not trust
>(certificate not in Trusted Root) the deployment will fail.
>It would be better to pop-up the dialog to choose to trust or not (like the
>dialog in IE).
>

Browsing Cube

Hi,

I have created, populate and processed a cube successfully and can also browse it successfully on one server. But when I deploy this cube to another server I can create, populate and process the cube sucessfully but when I go to browse the cube through SQL Management Studio I recive the following error:

The query could not be processed: o OLE DB error: OLE DB or ODBC error: You do not have permission to run 'SP_TRACE_CREATE'.; 42000.

I have checked the security and it all appears to be the same, I am using the domain administrator on both servers.

Have you any idea what my issue might be?

Your help will be greatly appreciated.

Cheers,

Hi,

I resolved this issue myself and am position what my resolution so that i may hopefully help someone else if they are to encounter the same problem.

Resolution:

I set the authentication of the datasources being used by the cube to SQL authentication and then used the SQL server 'sa' account as the user.

|||This would imply that you are using ROLAP or HOLAP storage. You should not need to use the "sa" account. A user with db_datareader rights should be enough. The "sa" user has too many rights and really should not be used for anything other than administrative tasks.|||

Hi Darren,

All dimensions of the cube are using plain MOLAP and the cube itself is using plain MOLAP also. If you have any suggestions on how I could browse the cube with using 'sa' as the datasources user then that would be great as I also think as you mentioned that 'sa' should only be used for administration purposes.

Cheers,

|||

MOLAP storage only needs a SQL connection at processing time. When you browse it does not need a connection to the relational source. You could try using SQL Profiler to see what is going on. Do you have pro-active caching or something like that configured?

Browsing Cube

Hi,

I have created, populate and processed a cube successfully and can also browse it successfully on one server. But when I deploy this cube to another server I can create, populate and process the cube sucessfully but when I go to browse the cube through SQL Management Studio I recive the following error:

The query could not be processed: o OLE DB error: OLE DB or ODBC error: You do not have permission to run 'SP_TRACE_CREATE'.; 42000.

I have checked the security and it all appears to be the same, I am using the domain administrator on both servers.

Have you any idea what my issue might be?

Your help will be greatly appreciated.

Cheers,

Hi,

I resolved this issue myself and am position what my resolution so that i may hopefully help someone else if they are to encounter the same problem.

Resolution:

I set the authentication of the datasources being used by the cube to SQL authentication and then used the SQL server 'sa' account as the user.

|||This would imply that you are using ROLAP or HOLAP storage. You should not need to use the "sa" account. A user with db_datareader rights should be enough. The "sa" user has too many rights and really should not be used for anything other than administrative tasks.|||

Hi Darren,

All dimensions of the cube are using plain MOLAP and the cube itself is using plain MOLAP also. If you have any suggestions on how I could browse the cube with using 'sa' as the datasources user then that would be great as I also think as you mentioned that 'sa' should only be used for administration purposes.

Cheers,

|||

MOLAP storage only needs a SQL connection at processing time. When you browse it does not need a connection to the relational source. You could try using SQL Profiler to see what is going on. Do you have pro-active caching or something like that configured?

Broken Image when using SQL 2000 Reporting Services

Hi,

I have a report that works fine when i deploy it in the development environment, but when i deploy the same report on the production server pointing to the same data source as the development environment; the images doesn't show up. I do see broken image X on all the images.

I searched the internet but couldn't find a solution to solve this problem. Any help on this will be appreciated.

Thanks,

Chaitanya

How did you express the image source expression? And is it embedded or external?

>L<

|||

The problem has been resolved.

When i am investigating the security setting and other configuration files for the reporting services i realised that i have not applied SP2 for the Reporting Services on the Production Server. SP2 provided a lot of updates which include showing the Print button on the Report Viewer, displaying images etc which are helpful.

By the way the images are web based external images.

Thanks,

Chaitanya