Is it possible to localize Report Manager using satellite assembly

Hi,
I'm trying to localize Report Manager (Reporting Services 2005) by
implementing my own Finnish version of the resources in
ReportingServicesWebUserInterface.dll assembly.
I have the satellite assembly in the following folder:
C:\Program Files\Microsoft SQL Server\MSSQL.6\Reporting
Services\ReportManager\Bin\fi
I used the Assembly Linker tool (al) to create the assembly and used the
ReportingServicesWebUserInterface.dll in the base directory as the template.
I tried delay signing the assembly using my own key. Then I used the Strong
Name
Utility (sn) to add the assembly to skip verification list.
For some reason my satellite assembly is not loaded when I set my web
browser language to Finnish. If I set it to German it works ok. I have very
little .NET experience by I suspect that is due to the fact that the
sattelite assembly should be signed with the same key as the base assembly?
So is it possible to implement your own language version of the
ReportingServicesWebUserInterface.dll satellite assembly to use it to
localize report manager?
If it is possible is there any document that describes the process and the
related security issues?
If it's not possible then please tell me so that I can make a decision about
developing a new report portal web application. We would like to use the
Report Manager if we only could localize it.
I tried emailing the Gold Certified Partner support address, but got no
answer. Any assitance will be greatly appreciated.
Thank you,
Juho Salo> I tried emailing the Gold Certified Partner support address, but got no
> answer.
Scractch that. They actually called me instead of emailing, but my phone was
not on, stupid I know. I will post the answer here when I get it.
Juho|||I have received a very decisive answer from Microsoft.
Quote:
"You have asked if it is possible to implement your own language version of
the ReportingServicesWebUserInterface.dll satellite assembly to use it to
localize report manager. Unfortunately, this is NOT possible. The Report
Manager resource assemblies MUST be signed with a Microsoft key."
So if anyone else is wondering, if you need to localize Report Manager
easily it's not possible (unless ofcourse you live in one of those
priviledged countries that are provided with localization for it).
I'm off to writing my own report portal application then.|||I actually came up with a solution that is a bit of a hack but will do nicely
and let's me use the Report Manager. Just add the code below to all of the
aspx pages under the Report Manager\Pages folder
<script language=cs runat=server src= "Dictionary.cs"/>
<script language="C#" runat="server">
void Page_LoadComplete(object sender, EventArgs e) {
TranslateControls(Page);
}
private void TranslateControls(Control c)
{
Type t = c.GetType();
System.Reflection.PropertyInfo p = t.GetProperty("Text");
string s;
if (p != null) {
s = (string) p.GetValue(c, null);
if (s!= null ) {
if (s.Length > 0 ) {
if (p.CanWrite)
{
p.SetValue(c, Dictionary.Translate((string) p.GetValue(c, null)), null);
}
}
}
}
foreach (Control child in c.Controls)
{
TranslateControls(child);
}
}
</script>
Then just create some sort of implementation for the Dictionary class in the
Dictionary.cs file. The code above is not the final version but it works.
Comments are welcome.

Is it possible to customize the Report Manager user interface?

I would like to add my own logos, fonts and layouts so the Report Manager
user interfaces better fits in with our site. Is this possible by editing
HTML templates or style sheets?
Thanks,
SteveTry to get your hands on Hitchhiker's guide to SQL server Reporting services
book , it will show you the lot i.e how to customise the RS interface etc...
alternatively visit http://www.sqlreportingservices.net
hope it helps!
"Stephen Walch" wrote:
> I would like to add my own logos, fonts and layouts so the Report Manager
> user interfaces better fits in with our site. Is this possible by editing
> HTML templates or style sheets?
> Thanks,
> Steve
>
>|||Customizing the Report Manager user interface is not
supported although The file \Microsoft SQL
Server\MSSQL\ReportingServices\ReportManager\Styles\Repor
tingServices.css allows some changes but this was not a
design goal it can't be guaranteed to be easy to
understand and not everything was exposed.
If you want to change the reporting services site name
displayed in Report Manager you can modify that on
Report Manager's site settings page.
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
This posting is provided "AS IS" with no warranties, and
confers no rights.
--
>From: "Stephen Walch" <swalch@.online.nospam>
>Subject: Is it possible to customize the Report Manager
user interface?
>Date: Sun, 27 Feb 2005 17:41:58 -0500
>Lines: 9
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>Message-ID: <#Bk3N2RHFHA.3928@.TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>NNTP-Posting-Host: 69-164-66-20.lndnnh.adelphia.net
69.164.66.20
>Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.
phx.gbl!TK2MSFTNGP09.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.sqlserver.reportingsvcs:44052
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>I would like to add my own logos, fonts and layouts so
the Report Manager
>user interfaces better fits in with our site. Is this
possible by editing
>HTML templates or style sheets?
>Thanks,
>Steve
>
>|||You can write your own. Start with the ReportViewer sample included with
RS.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Stephen Walch" <swalch@.online.nospam> wrote in message
news:%23Bk3N2RHFHA.3928@.TK2MSFTNGP09.phx.gbl...
>I would like to add my own logos, fonts and layouts so the Report Manager
> user interfaces better fits in with our site. Is this possible by editing
> HTML templates or style sheets?
> Thanks,
> Steve
>

Is it possible to create a custom SQL session function/variable

To avoid having to pass this user specific ID via a parameter in the stored
procedure, is it possible to create your own function like (like
suser_sid()) or variable (like @.@.SPID) ?
This value would be passed from a Web Service (asp.net 2.0) in the
connection string or something and could be referred to anywhere in the SQL
code (SQL 2005).
Has anyone got a better solution than a SP parameter ?Take a look at CONTEXT_INFO in the Books Online. This allows you to store
up to 128 bytes of binary info that can be used anywhere in the session.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"GMG" <gmgsoftware@.nospam.net.au> wrote in message
news:uI04I9duHHA.4440@.TK2MSFTNGP06.phx.gbl...
> To avoid having to pass this user specific ID via a parameter in the
> stored
> procedure, is it possible to create your own function like (like
> suser_sid()) or variable (like @.@.SPID) ?
> This value would be passed from a Web Service (asp.net 2.0) in the
> connection string or something and could be referred to anywhere in the
> SQL
> code (SQL 2005).
> Has anyone got a better solution than a SP parameter ?
>

Is it possible to create a custom SQL session function/variable

To avoid having to pass this user specific ID via a parameter in the stored
procedure, is it possible to create your own function like (like
suser_sid()) or variable (like @.@.SPID) ?
This value would be passed from a Web Service (asp.net 2.0) in the
connection string or something and could be referred to anywhere in the SQL
code (SQL 2005).
Has anyone got a better solution than a SP parameter ?Take a look at CONTEXT_INFO in the Books Online. This allows you to store
up to 128 bytes of binary info that can be used anywhere in the session.
Hope this helps.
Dan Guzman
SQL Server MVP
"GMG" <gmgsoftware@.nospam.net.au> wrote in message
news:uI04I9duHHA.4440@.TK2MSFTNGP06.phx.gbl...
> To avoid having to pass this user specific ID via a parameter in the
> stored
> procedure, is it possible to create your own function like (like
> suser_sid()) or variable (like @.@.SPID) ?
> This value would be passed from a Web Service (asp.net 2.0) in the
> connection string or something and could be referred to anywhere in the
> SQL
> code (SQL 2005).
> Has anyone got a better solution than a SP parameter ?
>sql

Is it possible to create a custom SQL session function/variable

To avoid having to pass this user specific ID via a parameter in the stored
procedure, is it possible to create your own function like (like
suser_sid()) or variable (like @.@.SPID) ?
This value would be passed from a Web Service (asp.net 2.0) in the
connection string or something and could be referred to anywhere in the SQL
code (SQL 2005).
Has anyone got a better solution than a SP parameter ?Asked and answered in .programming. Please refrain from multiposting.
Adam Machanic
SQL Server MVP
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"GMG" <gmgsoftware@.nospam.net.au> wrote in message
news:%23cNc2ceuHHA.3376@.TK2MSFTNGP04.phx.gbl...
> To avoid having to pass this user specific ID via a parameter in the
> stored
> procedure, is it possible to create your own function like (like
> suser_sid()) or variable (like @.@.SPID) ?
> This value would be passed from a Web Service (asp.net 2.0) in the
> connection string or something and could be referred to anywhere in the
> SQL
> code (SQL 2005).
> Has anyone got a better solution than a SP parameter ?
>|||Take a look at SET CONTEXT_INFO in the Books Online. That allows you to set
a value for the connection that is accessible anywhere in the session with
the CONTEXT_INFO function. Since the value is binary, you'll need to
convert as needed.
Hope this helps.
Dan Guzman
SQL Server MVP
"GMG" <gmgsoftware@.nospam.net.au> wrote in message
news:%23cNc2ceuHHA.3376@.TK2MSFTNGP04.phx.gbl...
> To avoid having to pass this user specific ID via a parameter in the
> stored
> procedure, is it possible to create your own function like (like
> suser_sid()) or variable (like @.@.SPID) ?
> This value would be passed from a Web Service (asp.net 2.0) in the
> connection string or something and could be referred to anywhere in the
> SQL
> code (SQL 2005).
> Has anyone got a better solution than a SP parameter ?
>

Is it commertial or NOT ?

I would like to show You one situation:
I have my own private firm and we specialized
helping people with accounting and taxes.
We would like to use MSDE Server in our small
company
Will it be legal ?
Please send me some answers.
eagleeye@.interia.pl
hi,
"Eagleeye from Poland" <eagleeye@.interia.pl> ha scritto nel messaggio
news:E510C800-EB82-4ED9-BC46-35511C94E435@.microsoft.com...
> I would like to show You one situation:
> I have my own private firm and we specialized
> helping people with accounting and taxes.
> We would like to use MSDE Server in our small
> company
> Will it be legal ?
> Please send me some answers.
> eagleeye@.interia.pl
>
MSDE release A is free to download at
http://www.microsoft.com/sql/msde/do...s/download.asp and you can freely
distribute it as long as you register dirtibution rights for free at
http://www.microsoft.com/sql/msde/ho...stregister.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Is it best practice to put both the SQL & MSDTC groups on the same node?

In Rodney R. Fournier's blog it states:
"If MSDTC is used with SQL, you should ensure it is in it's own group,
on it's own disk resource. Lastly, Microsoft recommends to run the
MSDTC & SQL group on the same node, and that the MSDTC is brought
online first when the groups are moved."
("http://msmvps.com/clustering/archive/2004/10/25/16672.aspx").
I have a couple of questions about this but let first list my
assumptions.
Best:
For high performance, installing an MSDTC Resource to it in its own
group. This group should have its own disk and IP resources.
Good:
The next best method is to put the MSDTC resource in the cluster or
quorum group.
Worse:
Put the MSDTC resource in SQL Group.
What are the reasons for running the MSDTC & SQL group on the same
node, beyond these potential Win2003 cluster issues listed in:
http://support.microsoft.com/default...b;en-us;889706
http://support.microsoft.com/kb/821751/
?
If DTC is in the quorum group is it still best to put SQL and quorum
group on the same node?
Our system admin is religious about putting the SQL group on a
different node from the Quorum & DTC groups. Is there a best practice
here or a KB I can point to?
Are there any implications not having SQL dependent of MSDTC starting
first (MSDTC is brought online first when the groups are moved)
beyond the possibility of not being able to start a distributed
transaction?
Replies below...
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
"Sean" <spowell71@.hotmail.com> wrote in message
news:1126723915.556530.64310@.g44g2000cwa.googlegro ups.com...
> In Rodney R. Fournier's blog it states:
> "If MSDTC is used with SQL, you should ensure it is in it's own group,
> on it's own disk resource. Lastly, Microsoft recommends to run the
> MSDTC & SQL group on the same node, and that the MSDTC is brought
> online first when the groups are moved."
> ("http://msmvps.com/clustering/archive/2004/10/25/16672.aspx").
> I have a couple of questions about this but let first list my
> assumptions.
> Best:
> For high performance, installing an MSDTC Resource to it in its own
> group. This group should have its own disk and IP resources.
>
Correct.

> Good:
> The next best method is to put the MSDTC resource in the cluster or
> quorum group.
>
Correct.

> Worse:
> Put the MSDTC resource in SQL Group.
>
Yuck! Correct.

> What are the reasons for running the MSDTC & SQL group on the same
> node, beyond these potential Win2003 cluster issues listed in:
> http://support.microsoft.com/default...b;en-us;889706
> http://support.microsoft.com/kb/821751/
> ?
>
Correct, pre SP1 for Windows Server 2003 MSDTC has issues! Lots of issues.
The Q is correct.

> If DTC is in the quorum group is it still best to put SQL and quorum
> group on the same node?
>
If you can, yes!

> Our system admin is religious about putting the SQL group on a
> different node from the Quorum & DTC groups. Is there a best practice
> here or a KB I can point to?
>
http://support.microsoft.com/default...b;en-us;889706
Remember, SQL does not require MSDTC. You only need it if you application
will use it.

> Are there any implications not having SQL dependent of MSDTC starting
> first (MSDTC is brought online first when the groups are moved)
> beyond the possibility of not being able to start a distributed
> transaction?
>
Isn't that enough?
|||What are the arguments against these types of statements?
Having Quorum & DTC groups on a different node than the SQL group
a) has a load balancing effect, i.e. the SQL group will have the full
physical resources of the node.
b) enables the failover of SQL group happen be quicker cause Quorum &
DTC groups are already on the failover node.
|||http://support.microsoft.com/default...b;en-us;889706 pretty much
covers it.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
"Sean" <spowell71@.hotmail.com> wrote in message
news:1126789871.591787.32620@.g44g2000cwa.googlegro ups.com...
> What are the arguments against these types of statements?
> Having Quorum & DTC groups on a different node than the SQL group
> a) has a load balancing effect, i.e. the SQL group will have the full
> physical resources of the node.
> b) enables the failover of SQL group happen be quicker cause Quorum &
> DTC groups are already on the failover node.
>
|||I had this problem, MSTDC not available so I put MSDTC in the same group as
SQLServer AND made SQLServer dependant on MSDTC Works fine now.
Nik Marshall-Blank MCSD/MCDBA
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:%23sx340fuFHA.3188@.TK2MSFTNGP14.phx.gbl...
> http://support.microsoft.com/default...b;en-us;889706 pretty much
> covers it.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://www.msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
>
> "Sean" <spowell71@.hotmail.com> wrote in message
> news:1126789871.591787.32620@.g44g2000cwa.googlegro ups.com...
>