[SQL Server Reporting] Converting a GUID back to its original contents

Hi,
I have an SQL Server Table in which one of the attributes is stored as
a GUID. The GUID actually represents the name of a SQL Server
Reporting Services report.
Once I retrive the GUID from the DB, I cant figure out how to get the
Report Name back from it.
I was wondering if anyone could point me to where the data for all the
GUIDs are stored in an SQL Server DB. Is it in tables? or are there
specific calls i need to make?
Any help would be great, been trying to figure this out for quite some
time now. :)
Thanks in advance.
Regards, LloydOn Jun 19, 11:25 am, lloyddsi...@.gmail.com wrote:
> Hi,
> I have an SQL Server Table in which one of the attributes is stored as
> a GUID. The GUID actually represents the name of a SQL Server
> Reporting Services report.
> Once I retrive the GUID from the DB, I cant figure out how to get the
> Report Name back from it.
> I was wondering if anyone could point me to where the data for all the
> GUIDs are stored in an SQL Server DB. Is it in tables? or are there
> specific calls i need to make?
> Any help would be great, been trying to figure this out for quite some
> time now. :)
> Thanks in advance.
> Regards, Lloyd
Hi,
I've got the answer from my post in the
microsoft.public.sqlserver.reportingsvcs group.
Thanks everyone.
Cheers, Lloyd|||On Jun 19, 1:24 pm, lloyddsi...@.gmail.com wrote:
> On Jun 19, 11:25 am, lloyddsi...@.gmail.com wrote:
>
> > Hi,
> > I have an SQL Server Table in which one of the attributes is stored as
> > a GUID. The GUID actually represents the name of a SQL Server
> > Reporting Services report.
> > Once I retrive the GUID from the DB, I cant figure out how to get the
> > Report Name back from it.
> > I was wondering if anyone could point me to where the data for all the
> > GUIDs are stored in an SQL Server DB. Is it in tables? or are there
> > specific calls i need to make?
> > Any help would be great, been trying to figure this out for quite some
> > time now. :)
> > Thanks in advance.
> > Regards, Lloyd
> Hi,
> I've got the answer from my post in the
> microsoft.public.sqlserver.reportingsvcs group.
> Thanks everyone.
> Cheers, Lloyd
Oops .. i meant the microsoft.public.sqlserver.programming group above
Cheers.

[SBS2003 Premium R2] Reporting services problem

Hi!
When I try configure report data source to connect to database on another
SQL Server 200 i receive message:
The feature: "Remote access to report data sources and/or the report server
database" is not supported in this edition of Reporting Services.
What can I do with thiss message?
Please help me
Best regards
AdamOn Jun 29, 1:57 am, "Adam Kobylinski" <akobylin@.NO_SPAM.op.pl> wrote:
> Hi!
> When I try configure report data source to connect to database on another
> SQL Server 200 i receive message:
> The feature: "Remote access to report data sources and/or the report server
> database" is not supported in this edition of Reporting Services.
> What can I do with thiss message?
> Please help me
> Best regards
> Adam
If you are running SQL Server 2005 Express Edition (w/Advanced
Services), this is one of the limitations. Otherwise, you will want to
open the local SQL Server Surface Area Configuration tool and select
Surface Area Configuration for Services and Connections -> View by
Instance -> MSSQLSERVER (or the local instance name) -> Database
Engine -> Remote Connections and make sure that it is set to: Local
and remote connections. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||User "EMartinez" <emartinez.pr1@.gmail.com>
> On Jun 29, 1:57 am, "Adam Kobylinski" <akobylin@.NO_SPAM.op.pl> wrote:
>> Hi!
>> When I try configure report data source to connect to database on another
>> SQL Server 200 i receive message:
>> The feature: "Remote access to report data sources and/or the report
>> server
>> database" is not supported in this edition of Reporting Services.
>> What can I do with thiss message?
>> Please help me
>> Best regards
>> Adam
>
> If you are running SQL Server 2005 Express Edition (w/Advanced
> Services), this is one of the limitations. Otherwise, you will want to
> open the local SQL Server Surface Area Configuration tool and select
> Surface Area Configuration for Services and Connections -> View by
> Instance -> MSSQLSERVER (or the local instance name) -> Database
> Engine -> Remote Connections and make sure that it is set to: Local
> and remote connections. Hope this helps.
>
Unfortunately it doesn't work, i already have remote connections selected,
SQL server 2000 on other computer is Standard Edition and i can connect
remotely from other applications.
Have you any idea?
Regards
Adam

[HELP] How can I start an Analysis Services service

Hi all,

at Surface Area Configuration in my SQL Server 2005 I noticed that I have Database Engine, Reporting Services and SQL Server Browser services. I want to deploy a cube modelled at SQL Server Business Intelligence Development Studio and I'm getting connection errors.

I checked at Management Studio that I don't have an instance of Analysis Services. Only Database Engine and Reporting Services.

How can I create an instance of Analysis Services.

Does anyone could help me please?

Thanks a lot.

Another way to verify if you have Analysis Services installed or not, is to look in Services for "SQL Server Analysis Services". To install it, re-run the Setup and there is an option for Analysis Services.

Adrian Dumitrascu

[241] Startup error: Unable to initialize error reporting system

When I try to start the SQL Server Agent I am getting this error.
[241] Startup error: Unable to initialize error reporting system
(reason: The EventLog service has not been started)
Thsi is very frustrating and i cant put up the DB until im sure that I
can have my backups working. Anyone know the solution to this?no one?

[2.0] web service method to list the reports ?

Hello,

I'd like to use the Reporting Services 2005 Web Service to list all the reports on the server, but I don't know which method to use ?
I found many web methods to do all sort of things but not to get a list of reports.

Any idea ?

Ok I found the method of the Reporting Web Service : ListChildren(...)

But when I make a call to the WS on my web app, I got the error :HTTP status 401: Access Denied.

My Web App use Form authentication.
My ASPNET user is member of the ReportinsServicesWebServiceUser role so it should work.

I try to use impersonation, but still the same result...

|||

Have you tried allowing anonymous access to the site in IIS and adding

service.Credentials = System.Net.CredentialCache.DefaultCredentials

in code?

|||

I tried this and it's ok !

There was another security problem with RS which make a DCOM access to NetMan component with Network Services account.

Weird but it seems ok now, thanks.

[+]/[-] inconsistency

SQL Server 2005, Reporting Services 2005, Windows Server 2003.

It looks like in report matrix the start icon for collaspsing/expanding subgroups is always [+], regardless of whether subgroups are hidden or visible by default.

In report table it is vice versa [-].

Expected behavior: [-] when group is expanded, [+] when contracted.

So to get that behavior I'm forced to hide all subgroups in report matrix, and expand in report tables.

What am I doing wrong?

Is there a way to control which icon appears when group is expanded/contracted?

Was it resolved in one of Service Packs?

BTW. Can I assign my own icon images?

Thanks, Andrei.

ToggleImage property on the textbox that toggles the subgroups controls what the start icon is. If you haven't set anything for this property, the default should be [+], in both table and matrix. Can you check what value this property currently has in your table and matrix? You can right-click on the textbox, in the properties dialog go to the Visibility tab, and look at the "initial appearance of the toggle image for this report item".

Being able to assign your own icon images is not currently supported. It's on our wishlist for a future release.

[?] Error accessing from internet

I've installed Reporting Services and customized the authentication ( Forms
Authentication Sample ) with SSL.
Everything works fine in intranet environment.
Now I'm trying to publish this server in internet, but it doesn't work:
when I call the server url I can see the login form, but when I press the
"Login" button nothing happens.
I debugged the application and see the request coming in correctly, the
login credentials are authenticated but the redirect to the
"/Pages/Folder.aspx" is wrong.
It seems like the report manager and the report server can't communicate
each other when accessed from internet.
May the SSL certificate be released on Netbios name but the internet access
is something like www.myserver.com ?
Thanks for responses.
MorenoI had a similar problem. What I did was add a entry into my host file
on the server. Make sure your internal ip for the server matches your
domain name. Hope this helps.
Example:
10.0.0.1 yourssldomain.com
"Moreno" <movendra@.yahoo.com> wrote in message news:<#Q$tpBtWEHA.3800@.TK2MSFTNGP11.phx.gbl>...
> I've installed Reporting Services and customized the authentication ( Forms
> Authentication Sample ) with SSL.
> Everything works fine in intranet environment.
> Now I'm trying to publish this server in internet, but it doesn't work:
> when I call the server url I can see the login form, but when I press the
> "Login" button nothing happens.
> I debugged the application and see the request coming in correctly, the
> login credentials are authenticated but the redirect to the
> "/Pages/Folder.aspx" is wrong.
> It seems like the report manager and the report server can't communicate
> each other when accessed from internet.
> May the SSL certificate be released on Netbios name but the internet access
> is something like www.myserver.com ?
> Thanks for responses.
> Moreno

[ URGENTlY URGENT ] PARAMETER LENGTH 1024

I got a parametrized report in Reporting Services.The problem is that i got Really large paramteres which are exceeding 1024 limit and if that probolem is not solved..please let me know a hotel where a waiter is Needed on good Pay and Respect.

Try splitting into multiple parameters and then merging after the fact.
Or try using a table to store parameters based on user id & look up after the fact.
More information around application & parameter types would help.
URLs don't really support that much information, so you're better off saving the parameter to a database, then using an id field to retrieve the information in a stored procedure.|||Does this mean that there is a 1024 limit on the report parameters of RS?

[ URGENTlY URGENT ] PARAMETER LENGTH 1024

I got a parametrized report in Reporting Services.The problem is that i got Really large paramteres which are exceeding 1024 limit and if that probolem is not solved..please let me know a hotel where a waiter is Needed on good Pay and Respect.

Try splitting into multiple parameters and then merging after the fact.
Or try using a table to store parameters based on user id & look up after the fact.
More information around application & parameter types would help.
URLs don't really support that much information, so you're better off saving the parameter to a database, then using an id field to retrieve the information in a stored procedure.|||Does this mean that there is a 1024 limit on the report parameters of RS?