Mirror database and users

We are mirroring to a server used to generate reports and datamarts. Is
there a technique of synching up the database users with the principle
server?
We use snapshots to generate reports and datamarts off of.Best approach is to make sure the logins on that other SQL Server has the co
rrect SID in the first
place. Search KB for sp_help_revlogin and check it out. If that isn't an opt
ion for you, you need to
do something with sp_change_users_login, something you run after the failove
r has taken place...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Kevin Jackson" <kjackson@.powerwayinc.com> wrote in message
news:ekB9rBEeGHA.1320@.TK2MSFTNGP04.phx.gbl...
> We are mirroring to a server used to generate reports and datamarts. Is t
here a technique of
> synching up the database users with the principle server?
> We use snapshots to generate reports and datamarts off of.
>

Mirror database and users

We are mirroring to a server used to generate reports and datamarts. Is
there a technique of synching up the database users with the principle
server?
We use snapshots to generate reports and datamarts off of.Best approach is to make sure the logins on that other SQL Server has the correct SID in the first
place. Search KB for sp_help_revlogin and check it out. If that isn't an option for you, you need to
do something with sp_change_users_login, something you run after the failover has taken place...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Kevin Jackson" <kjackson@.powerwayinc.com> wrote in message
news:ekB9rBEeGHA.1320@.TK2MSFTNGP04.phx.gbl...
> We are mirroring to a server used to generate reports and datamarts. Is there a technique of
> synching up the database users with the principle server?
> We use snapshots to generate reports and datamarts off of.
>sql

Minor pdf-rendering error.

Hi.

We use RS intensively in our app. However, we have had several reports from our customers, that they cannot open our pdf-files on their macintosh computers. I have investigated the problem, and found that this is due to a very simple omission in the rendered pdf.

Apparently the 1.3 specs requires a "carriage return" (char decimal value 13) after the %%EOF-element. If I add this manually, the files open just fine on mac.

Is this a known issue?

Is there some way to get around it, apart from adding it manually in the code?

- Kristian

(Note: There might be some pdf-readers for mac that can read these files, but we have no way of controlling our customers ap-selection.)

I was a little fast on the trigger there.

After manually adding the carriage return, they still do not open on mac. It only made some of the unix-tools we used for testing stop complaining (pdf2ps).

Are there any known issues with pdf-files from RS and Macintosh compatibility.

|||

We found out, that if we installed Adobe Reader on the Mac, we could view our file.

So it's propably the internal (default) pdf-viewer, that doesn't understand the RS pdf format.

sql

Minimum version of Visual Studio.NET

What is the minimum requirement or version of Visual Studio.NET
necessary for editing reports when running Reporting Services. I am
running on a SQL 2000 sp3 and Windows 2003 server.Anything that comes with VS.2003 (It cannot be VS 2005). The cheapest is
VB.Net
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"refdk" <fuhlendorf@.gmail.com> wrote in message
news:1140804364.362272.141300@.z34g2000cwc.googlegroups.com...
> What is the minimum requirement or version of Visual Studio.NET
> necessary for editing reports when running Reporting Services. I am
> running on a SQL 2000 sp3 and Windows 2003 server.
>|||Thanks, I will try that :-)
/Ren=E9

minimum installation?

What is the minimum installation for the developer's computer if the person
is going to desing the reports locally? Typical installation of Visual
Studio 2005 does not have anything to do with Reporting Services, SQL Server
Express installed together with VS2005 also not configured for Reporting
services.
So, which components the developer must add to VS and/or SQL Server Express
to start working with the reports?
--
Regards,
Dmitry DuginovIf you want to design and deploy locally, you will need to install SQL
Server Reporting Services on the local PC, since it will create a
ReportServer and ReportTemp DB on the local SQL Server. You will also
need ASP.net 2.0 and IIS, but the RS install will evaluate your target
machine to determine what missing components you need to install first.
Don't forget the service packs.
Actually, I've just noticed you are using SQL Server Express
Check this link for product comparisons...SQL Server Express does not
come with Reporting Services
http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx
On Oct 24, 3:26 pm, "Dmitry Duginov" <d...@.nospam.nospam> wrote:
> What is the minimum installation for the developer's computer if the person
> is going to desing the reports locally? Typical installation of Visual
> Studio 2005 does not have anything to do with Reporting Services, SQL Server
> Express installed together with VS2005 also not configured for Reporting
> services.
> So, which components the developer must add to VS and/or SQL Server Express
> to start working with the reports?
> --
> Regards,
> Dmitry Duginov|||"weelin" <weelin@.gmail.com> wrote in message
news:1161701622.875595.325280@.i3g2000cwc.googlegroups.com...
> If you want to design and deploy locally, you will need to install SQL
> Server Reporting Services on the local PC, since it will create a
> ReportServer and ReportTemp DB on the local SQL Server. You will also
> need ASP.net 2.0 and IIS, but the RS install will evaluate your target
> machine to determine what missing components you need to install first.
Nope, you got it wrong. The guy wants to design/edit reports locally, deploy
on the remote server. What does he need to get the Report Designer in Visual
Studio 2005?
Regards,
Dmitry Duginov|||http://msdn2.microsoft.com/en-us/library/ms173745.aspx -- RS in BIDS
- you need to install RS to get the RS templates in BIDS
http://msdn2.microsoft.com/en-us/library/ms365166.aspx -- RS in SQL
Server Express
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_8k82.asp
-- installing Reporting Services - you need a SQL Server to install RS
whether that is local or remote.
When RS first came out, you HAD TO have a SQL Server license and hence
a SQL Server install to install it, since it needs somewhere to install
it's DBs. After you install it, you can always deploy to remote
servers, but I thought you would need your own SQL Servier instance to
hold your ReportServer and ReportTempDB. I am not sure that you can
connect to a remote instance of ReportServerTempDB just to develop on.
Otherwise everyone could just use one instance of SQL Server and all
have RS.
If you find out otherwise, I would like to know.
On Oct 24, 4:07 pm, "Dmitry Duginov" <d...@.nospam.nospam> wrote:
> "weelin" <wee...@.gmail.com> wrote in messagenews:1161701622.875595.325280@.i3g2000cwc.googlegroups.com...
> > If you want to design and deploy locally, you will need to install SQL
> > Server Reporting Services on the local PC, since it will create a
> > ReportServer and ReportTemp DB on the local SQL Server. You will also
> > need ASP.net 2.0 and IIS, but the RS install will evaluate your target
> > machine to determine what missing components you need to install first.Nope, you got it wrong. The guy wants to design/edit reports locally, deploy
> on the remote server. What does he need to get the Report Designer in Visual
> Studio 2005?
> --
> Regards,
> Dmitry Duginov|||Thank you, that's been really helpful!
D.
"weelin" <weelin@.gmail.com> wrote in message
news:1161706899.281701.60240@.k70g2000cwa.googlegroups.com...
> http://msdn2.microsoft.com/en-us/library/ms173745.aspx -- RS in BIDS
> - you need to install RS to get the RS templates in BIDS
> http://msdn2.microsoft.com/en-us/library/ms365166.aspx -- RS in SQL
> Server Express
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_8k82.asp
> -- installing Reporting Services - you need a SQL Server to install RS
> whether that is local or remote.
> When RS first came out, you HAD TO have a SQL Server license and hence
> a SQL Server install to install it, since it needs somewhere to install
> it's DBs. After you install it, you can always deploy to remote
> servers, but I thought you would need your own SQL Servier instance to
> hold your ReportServer and ReportTempDB. I am not sure that you can
> connect to a remote instance of ReportServerTempDB just to develop on.
> Otherwise everyone could just use one instance of SQL Server and all
> have RS.
> If you find out otherwise, I would like to know.
>
> On Oct 24, 4:07 pm, "Dmitry Duginov" <d...@.nospam.nospam> wrote:
> > "weelin" <wee...@.gmail.com> wrote in
messagenews:1161701622.875595.325280@.i3g2000cwc.googlegroups.com...
> >
> > > If you want to design and deploy locally, you will need to install SQL
> > > Server Reporting Services on the local PC, since it will create a
> > > ReportServer and ReportTemp DB on the local SQL Server. You will also
> > > need ASP.net 2.0 and IIS, but the RS install will evaluate your target
> > > machine to determine what missing components you need to install
first.Nope, you got it wrong. The guy wants to design/edit reports locally,
deploy
> > on the remote server. What does he need to get the Report Designer in
Visual
> > Studio 2005?
> >
> > --
> > Regards,
> > Dmitry Duginov
>

Minimizing Locking Question

Hello all,
I am working on an Access 2000 project that is used to generate reports on archived sales data. This app uses linked tables that are pointing to some SQL 2K tables. Some of the queries are large and end up creating a table lock when executed, blocking all other users from using the app until it has finished executing the query. I would like to have queries that read data ignore this lock on the table but do not know of a way to do this using linked tables in Access 2000. I would use a NOLOCk table hint but need something else for this issue.
Any ideas?
ThanksWhat else do you need other than NOLOCK with linked tables?

MIME attachment blocked

We send reports via subscription and the attachments are blocked by
Mailsweeper saying "Invalid base64". It seems that the server encodes the
attachment wrong so it's blocked by mailsweeper. In notepad the "extra"
character is visible. I encoded an attachment locally and no extra characters
displayed. Not sure how to start. Is Reporting Service causing the error
because mails sent via outlook express are going throught. I know Reporting
Service uses the built-in CDO capabilities to send mails but I have no idea
where to start.It's solved with Service Pack 2. It's not mentioned there as a bug fix but I
believe it was fixed regarding the problems they had with Lotus notes domino
Server.
cheer
"Joachim" wrote:
> We send reports via subscription and the attachments are blocked by
> Mailsweeper saying "Invalid base64". It seems that the server encodes the
> attachment wrong so it's blocked by mailsweeper. In notepad the "extra"
> character is visible. I encoded an attachment locally and no extra characters
> displayed. Not sure how to start. Is Reporting Service causing the error
> because mails sent via outlook express are going throught. I know Reporting
> Service uses the built-in CDO capabilities to send mails but I have no idea
> where to start.

Million Records Problem

Is there any way or approach on handling reports with million of records retrieved?

Had a problem for 25 silmultaneous users accessing the report.
Problems are:
- Timeout Expired.
- Server unavailable.
- Page cannot be displayed.

Please let me know if there is... Thanks in advance...

You should set the report to execute from a snapshot, otherwise each user access results in another 1M rows put into memory.

|||I am curious... why do your users want to see all million rows? Is it possible to reduce the amount of data coming into the report server by pushing filters down into the query expressions?

Migration to new servers

I have to migrate reports to two new servers. I tried simply moving the
databases over, but RS freaked. rsactivate and the other utilities are
problematic, to say the least (I freaked).
It seems like the easiest thing would be to install SQL RS on the new
servers, copy over all of the project files/reports, and then from within VS,
reset the project properties to the new server and redeploy.
Does this make sense? Is there an easier, or more reliable way?
--
Thanks,
CGWYou are correct. easiest is to install RS on new servers and then to the new
RS URL, you can just post your reports directly from Visual studio, or
however you deploy your reports today. This is the cleanest way to deploy as
well.
"CGW" wrote:
> I have to migrate reports to two new servers. I tried simply moving the
> databases over, but RS freaked. rsactivate and the other utilities are
> problematic, to say the least (I freaked).
> It seems like the easiest thing would be to install SQL RS on the new
> servers, copy over all of the project files/reports, and then from within VS,
> reset the project properties to the new server and redeploy.
> Does this make sense? Is there an easier, or more reliable way?
> --
> Thanks,
> CGW|||Thank you!
CGW
"Ram" wrote:
> You are correct. easiest is to install RS on new servers and then to the new
> RS URL, you can just post your reports directly from Visual studio, or
> however you deploy your reports today. This is the cleanest way to deploy as
> well.
> "CGW" wrote:
> > I have to migrate reports to two new servers. I tried simply moving the
> > databases over, but RS freaked. rsactivate and the other utilities are
> > problematic, to say the least (I freaked).
> >
> > It seems like the easiest thing would be to install SQL RS on the new
> > servers, copy over all of the project files/reports, and then from within VS,
> > reset the project properties to the new server and redeploy.
> >
> > Does this make sense? Is there an easier, or more reliable way?
> > --
> > Thanks,
> >
> > CGW

Migration path of Reporting Servcies 2000 to 2005

This may have been asked before but can some one comment on migration path
for moving reporting services 2000 created reports to 2005.
Many thanks.It is supposed to be transparent. I am counting on it being so.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ah_la_ma" <ah_la_ma@.yahoo.com> wrote in message
news:O0TL8xcNFHA.3420@.tk2msftngp13.phx.gbl...
> This may have been asked before but can some one comment on migration path
> for moving reporting services 2000 created reports to 2005.
> Many thanks.
>|||The goal is it is completely transparent. RS 2005 supports both 2000 and
2005 report definitions. If you load a 2000 report into the 2005 report
designer, it will upgrade it. The server will also support both 2000 and
2005 web services clients.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"ah_la_ma" <ah_la_ma@.yahoo.com> wrote in message
news:O0TL8xcNFHA.3420@.tk2msftngp13.phx.gbl...
> This may have been asked before but can some one comment on migration path
> for moving reporting services 2000 created reports to 2005.
> Many thanks.
>

Migration of crystal reports from oracle to DB2

Crystal Reports is currently using Oracle. If the database is migrated to DB2 what are the changes required to be done for crystal reports to continue to work with DB2?
Can you please point me to relevant documentation?
TIA.Is it right to assume that the following changes are needed?

- Oracle driver to be replaced with appropriate DB2 driver
- SQL statements in crystal reports that use Oracle proprietary functions/features, join syntax, etc., to be replaced with corresponding / equivalent in DB2

Please let me have your input.

Thanks in advance.

Migration of Crystal Report 7.4 to version 11.0

Hi,
Is it possible to migrate the crystal reports developed in version 7.4 to version 11.0 directly?
Please let me know if any one knows.
Thanks and Regards,
AmitYou shouldn't have any issue. This is what BO has to say on the issue:

Crystal Reports XI, 10, and 9 support Unicode. Earlier versions of Crystal Reports do not support Unicode. Therefore, once an RPT file has been saved in Crystal Reports XI, 10, or 9 the RPT cannot be opened in Crystal Reports 8.5 or earlier.

I have brought over v8.0 reports to CR XI and didn't have any issues.

Brian
http://www.briankuipers.com

Migration form MS access reports to Sql server reports

Does any of the free dowloadable reporting packs come with Reporting Services wizard to migrate data and reports from MS-Access?

Does SQL Server reporting tools come integrated with any of the VS 2005 tools?

Yes, if you are dealing with the 2000 version than have your service packs up to date and you have to have Access 2003 for the option to show up in your designer. Once you have Access 2003 it will give you the option under "project" --> "import reports".

I believe in 2005 it is under the same location: "project" --> "import reports"

I hope this helps.

|||I need to convert from MS Access 97 to .NET 2005.
Is this possible with Reporting tool?|||It may be, but with what is built into Reporting Services you have to have Access 2003. This doesn't mean you couldn't open the Access 97 database with a 2003 version of Access.

Migrating to Report Services

Or rather, migrating to local reports using the Microsoft Report
Services.
We are in the process of planning the next generation of our software,
and among other things we are contemplating which reporting platform
we will use.
Until now we have been using Crystal Report, but it seems to be
getting more and more heavy to work with, plus it is a rather hefty
investment, well it can be.
First a little history:
- Our software will be running on anything from a stand-alone PC with
no connection to the surrounding world, to large-scale "enterprise"
networks with several dozens of clients. As a result our reporting
platform must be able to handle this.
Originally Crystal Report handled this very nicely, in that regard
that we simply installed the runtime libraries on each PC with our
software and a bunch of report files locally. This is model our
customers are used to.
Now I have decided to check out Reporting Services, but I have a bit
of a difficult time wrapping my mind around the concept. Some things
seem very nice and elegant, but others seem somewhat less so. For one
thing, the reports seem a little too simple and no where nearly as
powerful as Crystal Reports.
Now, our database is usually called the same regardless of the
customer, and of course, the layout of the database is always the same
(some customers may have a few custom tables, etc). But internally we
may have any number of databases that is named differently (customer
backups, test databases etc). So I need a way of being able to set the
database "on-the-fly".
What (I think) I need:
- A way of designing local reports and setting the data source at
runtime.
- I do not want to use the web server exclusively.
- Initially I want local reports, but the central reporting server can
be an option.
- I want to be able to mix tabular/matrix and chart reports.
- I want to be able to show group headers and footers, as well as page
headers and footers.
- I want to have full access to all tables in the database, and not
being restricted once I select on table, or entity.
Basically, I want to use the Reporting Service, but I don't want to
loose the freedom in data selection that Crystal Report gives me.According to your description, you need to use both SQL Server Reporting
Services and local report tool, which is bundled with VS2005/8 (VS2003 is
bundled with CrystalReport.NET as local report tool, while VS2005/8 come
with both CrystalReport.NET and MS report tool).
More comments inline.
"ThomasD" <tho.due@.gmail.com> wrote in message
news:4de6bed8-f6bc-4188-afd5-93ac01d49398@.8g2000hse.googlegroups.com...
> Or rather, migrating to local reports using the Microsoft Report
> Services.
> We are in the process of planning the next generation of our software,
> and among other things we are contemplating which reporting platform
> we will use.
> Until now we have been using Crystal Report, but it seems to be
> getting more and more heavy to work with, plus it is a rather hefty
> investment, well it can be.
> First a little history:
> - Our software will be running on anything from a stand-alone PC with
> no connection to the surrounding world, to large-scale "enterprise"
> networks with several dozens of clients. As a result our reporting
> platform must be able to handle this.
> Originally Crystal Report handled this very nicely, in that regard
> that we simply installed the runtime libraries on each PC with our
> software and a bunch of report files locally. This is model our
> customers are used to.
> Now I have decided to check out Reporting Services, but I have a bit
> of a difficult time wrapping my mind around the concept. Some things
> seem very nice and elegant, but others seem somewhat less so. For one
> thing, the reports seem a little too simple and no where nearly as
> powerful as Crystal Reports.
> Now, our database is usually called the same regardless of the
> customer, and of course, the layout of the database is always the same
> (some customers may have a few custom tables, etc). But internally we
> may have any number of databases that is named differently (customer
> backups, test databases etc). So I need a way of being able to set the
> database "on-the-fly".
> What (I think) I need:
> - A way of designing local reports and setting the data source at
> runtime.
If you have VS2005/8, you can do local report with either CrystalReport.NET
or MS report tool. By "Local". If you use SQL Server RS, I'd use MS report
tool in VS for local report, because the report viewer control can render
both local report and report from SQL Server RS. So, you app can seemlessly
dispaly report either from local report or from SQL Server RS without user
knowing the difference.
> - I do not want to use the web server exclusively.
> - Initially I want local reports, but the central reporting server can
> be an option.
> - I want to be able to mix tabular/matrix and chart reports.
> - I want to be able to show group headers and footers, as well as page
> headers and footers.
MS local report is a bit not as fancy as RS report can be.
> - I want to have full access to all tables in the database, and not
> being restricted once I select on table, or entity.
That has little to do with reporting, local or server.
> Basically, I want to use the Reporting Service, but I don't want to
> loose the freedom in data selection that Crystal Report gives me.
Do not know what "Data selection freedom" means here.
With local report, you can connect to whatever data source. If needed, you
can use code do trasform anything into a DataSet/Table of your desired
schema and use it as the report source, I'd think it is complete freedom.
With SQL Server RS, if the report data is difficult to access by reqular
queries, or the data source is not conventinal database, you can write your
own Data Processing Extensions sitting between the reporting processor and
data source. Of course, this requires lots of coding.|||> According to your description, you need to use both SQL Server Reporting
> Services and local report tool, which is bundled with VS2005/8 (VS2003 is
> bundled with CrystalReport.NET as local report tool, while VS2005/8 come
> with both CrystalReport.NET and MS report tool).
We use VS2008. I would like keep the option of using the report server
open, but my primary concern is local reports.
> More comments inline.
Cool. :)
> > - A way of designing local reports and setting the data source at
> > runtime.
> If you have VS2005/8, you can do local report with either CrystalReport.NET
> or MS report tool. By "Local". If you use SQL Server RS, I'd use MS report
> tool in VS for local report, because the report viewer control can render
> both local report and report from SQL Server RS. So, you app can seemlessly
> dispaly report either from local report or from SQL Server RS without user
> knowing the difference.
I finally managed to actually get the report designer working (it is
not easy to handle, when you are used to using Crystal Reports). It
looks very promising, however as it turns out, I have to supply the
data source "manually" when using the report locally. That is fine,
not a problem. However, I would like to use the SQL embedded in the
report, but that seems to be somewhat difficult to get at. So far I
have managed to get it by using XPath, but I can't help thinking that
there must be an easier way.
> MS local report is a bit not as fancy as RS report can be.
True, but I AM making progress in understanding the limitations and
differences.
> > - I want to have full access to all tables in the database, and not
> > being restricted once I select on table, or entity.
> That has little to do with reporting, local or server.
Well, after I "discovered" the report designer in Sql Server Business
Intelligence Development Studio (what a mouthful), I see that. Now I
just need to get a handle on the embedded SQL.
> > Basically, I want to use the Reporting Service, but I don't want to
> > loose the freedom in data selection that Crystal Report gives me.
> Do not know what "Data selection freedom" means here.
SQL. I don't want to be relying on some obscure model. Direct SQL
input is my preferred method of pulling data. Crystal Reports can do
both, and after discover the report designer in BI studio it looks
very promising.
> With local report, you can connect to whatever data source. If needed, you
> can use code do trasform anything into a DataSet/Table of your desired
> schema and use it as the report source, I'd think it is complete freedom.
> With SQL Server RS, if the report data is difficult to access by reqular
> queries, or the data source is not conventinal database, you can write your
> own Data Processing Extensions sitting between the reporting processor and
> data source. Of course, this requires lots of coding.
Coding doesn't scare me, I wouldn't be a software developer otherwise
*grin*
Regards,
Thomas