Multiple Instances of SQL Server Service Manager

- I am running SQL Server 2000 (Standard Edition, SP3) on a Windows Server
2003 (Standard, v5.2) server operating in terminal services mode. The SQL
Server Service Manager is in the startup folder for all users, so multiple
instances are running when more than one user is logged in.
- I am having some problems with this server, so I'm trying to stop anything
that doesn't need to run.
- Can I delete the SQL Server Service Manager from the all users startup
folder? (I would start Service Manager when the Administrator logs in.)
- Thanks.
Hi
SQL Server Service Manager is not required for SQL Server operation. You can
remove it from the startup folder.
You can still manage SQL Server though Enterprise Manager and Control Panel
> Services.
Any reason you have a server that SQL Server needs to share with Terminal
Server users? It is not an optimal configuration.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Dave" wrote:

> - I am running SQL Server 2000 (Standard Edition, SP3) on a Windows Server
> 2003 (Standard, v5.2) server operating in terminal services mode. The SQL
> Server Service Manager is in the startup folder for all users, so multiple
> instances are running when more than one user is logged in.
> - I am having some problems with this server, so I'm trying to stop anything
> that doesn't need to run.
> - Can I delete the SQL Server Service Manager from the all users startup
> folder? (I would start Service Manager when the Administrator logs in.)
> - Thanks.
|||Mike,
- Thanks for the info.
- Re your question, I am running Act2005 (which uses SQL2000) for a company
that offices virtually. We setup this server in a hosted datacenter, and
loaded all of our apps (Act, MSOffice, a cpl others) and access everything
using terminal services on the server and remote desktop connection on the
client PCs.
- This configuration generally works, although there are some bugs which I
attribute to the poor job done by my IT provider, and the fact that Act2005
is not designed for terminal services. My only big problem is that Act
occasionally starts using a lot of memory (over 1GB of VM in some cases) and
the whole server slows down.
- Thanks again for your help, and please let me know if you have any
suggestions for my configuration.
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> SQL Server Service Manager is not required for SQL Server operation. You can
> remove it from the startup folder.
> You can still manage SQL Server though Enterprise Manager and Control Panel
> Any reason you have a server that SQL Server needs to share with Terminal
> Server users? It is not an optimal configuration.
> Regards
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Dave" wrote:
sql

Multiple Instances of SQL Server Service Manager

- I am running SQL Server 2000 (Standard Edition, SP3) on a Windows Server
2003 (Standard, v5.2) server operating in terminal services mode. The SQL
Server Service Manager is in the startup folder for all users, so multiple
instances are running when more than one user is logged in.
- I am having some problems with this server, so I'm trying to stop anything
that doesn't need to run.
- Can I delete the SQL Server Service Manager from the all users startup
folder? (I would start Service Manager when the Administrator logs in.)
- Thanks.Hi
SQL Server Service Manager is not required for SQL Server operation. You can
remove it from the startup folder.
You can still manage SQL Server though Enterprise Manager and Control Panel
> Services.
Any reason you have a server that SQL Server needs to share with Terminal
Server users? It is not an optimal configuration.
Regards
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Dave" wrote:
> - I am running SQL Server 2000 (Standard Edition, SP3) on a Windows Server
> 2003 (Standard, v5.2) server operating in terminal services mode. The SQL
> Server Service Manager is in the startup folder for all users, so multiple
> instances are running when more than one user is logged in.
> - I am having some problems with this server, so I'm trying to stop anything
> that doesn't need to run.
> - Can I delete the SQL Server Service Manager from the all users startup
> folder? (I would start Service Manager when the Administrator logs in.)
> - Thanks.|||Mike,
- Thanks for the info.
- Re your question, I am running Act2005 (which uses SQL2000) for a company
that offices virtually. We setup this server in a hosted datacenter, and
loaded all of our apps (Act, MSOffice, a cpl others) and access everything
using terminal services on the server and remote desktop connection on the
client PCs.
- This configuration generally works, although there are some bugs which I
attribute to the poor job done by my IT provider, and the fact that Act2005
is not designed for terminal services. My only big problem is that Act
occasionally starts using a lot of memory (over 1GB of VM in some cases) and
the whole server slows down.
- Thanks again for your help, and please let me know if you have any
suggestions for my configuration.
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> SQL Server Service Manager is not required for SQL Server operation. You can
> remove it from the startup folder.
> You can still manage SQL Server though Enterprise Manager and Control Panel
> > Services.
> Any reason you have a server that SQL Server needs to share with Terminal
> Server users? It is not an optimal configuration.
> Regards
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Dave" wrote:
> > - I am running SQL Server 2000 (Standard Edition, SP3) on a Windows Server
> > 2003 (Standard, v5.2) server operating in terminal services mode. The SQL
> > Server Service Manager is in the startup folder for all users, so multiple
> > instances are running when more than one user is logged in.
> > - I am having some problems with this server, so I'm trying to stop anything
> > that doesn't need to run.
> > - Can I delete the SQL Server Service Manager from the all users startup
> > folder? (I would start Service Manager when the Administrator logs in.)
> > - Thanks.

Multiple Instances of SQL Server Service Manager

- I am running SQL Server 2000 (Standard Edition, SP3) on a Windows Server
2003 (Standard, v5.2) server operating in terminal services mode. The SQL
Server Service Manager is in the startup folder for all users, so multiple
instances are running when more than one user is logged in.
- I am having some problems with this server, so I'm trying to stop anything
that doesn't need to run.
- Can I delete the SQL Server Service Manager from the all users startup
folder? (I would start Service Manager when the Administrator logs in.)
- Thanks.Hi
SQL Server Service Manager is not required for SQL Server operation. You can
remove it from the startup folder.
You can still manage SQL Server though Enterprise Manager and Control Panel
> Services.
Any reason you have a server that SQL Server needs to share with Terminal
Server users? It is not an optimal configuration.
Regards
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Dave" wrote:

> - I am running SQL Server 2000 (Standard Edition, SP3) on a Windows Server
> 2003 (Standard, v5.2) server operating in terminal services mode. The SQL
> Server Service Manager is in the startup folder for all users, so multiple
> instances are running when more than one user is logged in.
> - I am having some problems with this server, so I'm trying to stop anythi
ng
> that doesn't need to run.
> - Can I delete the SQL Server Service Manager from the all users startup
> folder? (I would start Service Manager when the Administrator logs in.)
> - Thanks.|||Mike,
- Thanks for the info.
- Re your question, I am running Act2005 (which uses SQL2000) for a company
that offices virtually. We setup this server in a hosted datacenter, and
loaded all of our apps (Act, MSOffice, a cpl others) and access everything
using terminal services on the server and remote desktop connection on the
client PCs.
- This configuration generally works, although there are some bugs which I
attribute to the poor job done by my IT provider, and the fact that Act2005
is not designed for terminal services. My only big problem is that Act
occasionally starts using a lot of memory (over 1GB of VM in some cases) and
the whole server slows down.
- Thanks again for your help, and please let me know if you have any
suggestions for my configuration.
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> SQL Server Service Manager is not required for SQL Server operation. You c
an
> remove it from the startup folder.
> You can still manage SQL Server though Enterprise Manager and Control Pane
l
> Any reason you have a server that SQL Server needs to share with Terminal
> Server users? It is not an optimal configuration.
> Regards
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Dave" wrote:
>

multiple instances of Reporting Services - is it possible?

Hi there,

is it possible to host multiple Reporting-Webs and Reporting-Databases on a single Server?
What I want is to create two virtual directories

http://myserver/reports
http://myserver/reports_internal

and each web points to a different Database with different reports.

Best regards
Markus

Yes, this is supported and should work fine.|||

It would be very helpfull if you could tell me how this work!

Thanks
Markus

Multiple datasources in SSRS 2005 reports

Hi,
Is is possible to have multiple analysis Services datasources for a single
report? I want to be able to display measures from both cubes on the same
report with a common dimension without having to redesign my cubes.
Thanks!
BrianThe short answer is yes, but you won't be able to display the measures
side-by-side in the same region if this is what you are after. That's
because you cannot join RS datasets. That said, you can have two regions,
each bound to its own dataset. If you have a virtual cube and your MDX query
pulls data from both cubies than you should be OK.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Brian Madden" <bmadden@.gmail.com> wrote in message
news:756074632671466407265129@.msnews.microsoft.com...
> Hi,
> Is is possible to have multiple analysis Services datasources for a single
> report? I want to be able to display measures from both cubes on the same
> report with a common dimension without having to redesign my cubes.
> Thanks!
> Brian
>

Multiple Databases accessed by Multiple reports by Multiple users...?

Hello All,
I am somewhat new to MS Reporting Services and I've got a situation
where I have different users needing to access the same report (rdl)
but from different databases?
Ideally I would want to have each report pointing to all databases
dynamically.
Do you know how I would go about setting this up? Multiple reports
pointing to different datasources? Passing a parameter which
determines a specific datasource? - Is it even possible to pass a
parameter to the report to determine which data source to use?
Thanks for your help in advance
MagAre you using RS 2000 or RS 2005? In RS 2005 you can use data source
expressions (search books online under expressions, data sources). If RS
2000 it is much harder and a total pain and I strongly suggest going to RS
2005.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"mag" <mestafanos@.gmail.com> wrote in message
news:1137700476.286569.181810@.g14g2000cwa.googlegroups.com...
> Hello All,
> I am somewhat new to MS Reporting Services and I've got a situation
> where I have different users needing to access the same report (rdl)
> but from different databases?
> Ideally I would want to have each report pointing to all databases
> dynamically.
> Do you know how I would go about setting this up? Multiple reports
> pointing to different datasources? Passing a parameter which
> determines a specific datasource? - Is it even possible to pass a
> parameter to the report to determine which data source to use?
> Thanks for your help in advance
> Mag
>

Multiple Databases

Is possible to pull data from multiple databases into one report within
Reporting Services 2000? What about RS 2005?No problem at all. Just create a new data source for each database, and
create your datasets based on the different data sources. It might be a bit
more tricky to join data from different databases in the same dataset. But
then you can create a stored procedure in one of the databases, and create
your query just as you would normally do between databases, and reference
your stored procedure in the RS Report. Goes for both RS 2000 and 2005.
Kaisa
"David" <dilworth@.newsgroups.nospam> wrote in message
news:0049509F-B71D-4DEE-9984-1544D9F3E7A0@.microsoft.com...
> Is possible to pull data from multiple databases into one report within
> Reporting Services 2000? What about RS 2005?|||Also, read up on sub reports.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David" <dilworth@.newsgroups.nospam> wrote in message
news:0049509F-B71D-4DEE-9984-1544D9F3E7A0@.microsoft.com...
> Is possible to pull data from multiple databases into one report within
> Reporting Services 2000? What about RS 2005?|||David,
The only limit that I know is that reporting services 2000 (Dont know
aboout 2005), is that you can't use 2 data sets for 1 table - so you
cant MERGE data into 1 table.
So I would recommend either creating a store procedure as suggested by
Kaisa that would get data from different databases.
If you want the data in two different tables, then YES you can use 2
tables, or a subreport as suggested by Bruce.
Regards,
Stas K.|||Still true in RS 2005.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sorcerdon" <sorcerdon@.gmail.com> wrote in message
news:1136556065.510433.278670@.g49g2000cwa.googlegroups.com...
> David,
> The only limit that I know is that reporting services 2000 (Dont know
> aboout 2005), is that you can't use 2 data sets for 1 table - so you
> cant MERGE data into 1 table.
> So I would recommend either creating a store procedure as suggested by
> Kaisa that would get data from different databases.
> If you want the data in two different tables, then YES you can use 2
> tables, or a subreport as suggested by Bruce.
> Regards,
> Stas K.
>|||Is it possible to collect data from multiple databases in a report model also?
I'd like to define a data source view made up of three data sources, and it
works well, but when it comes to generating the report model, it seems to me
that only the primary data source is availible for the report model. Is this
true? If so it's a real showstopper for me. The solutions I see for this
problem is:
1. Views to the other databases
2. Building a ssas cube to overcome the limitations
Please help me out!
"Bruce L-C [MVP]" wrote:
> Still true in RS 2005.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Sorcerdon" <sorcerdon@.gmail.com> wrote in message
> news:1136556065.510433.278670@.g49g2000cwa.googlegroups.com...
> > David,
> >
> > The only limit that I know is that reporting services 2000 (Dont know
> > aboout 2005), is that you can't use 2 data sets for 1 table - so you
> > cant MERGE data into 1 table.
> > So I would recommend either creating a store procedure as suggested by
> > Kaisa that would get data from different databases.
> >
> > If you want the data in two different tables, then YES you can use 2
> > tables, or a subreport as suggested by Bruce.
> >
> > Regards,
> >
> > Stas K.
> >
>
>|||Sorry, I don't use Report Model so I am not aware of what can or cannot be
done. However, I doubt that it would allow something that is not possible
from with RS Designer.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Erik Hedlund" <ErikHedlund@.discussions.microsoft.com> wrote in message
news:7EDBEB3A-BAE8-431E-AB03-B866C2C179E2@.microsoft.com...
> Is it possible to collect data from multiple databases in a report model
> also?
> I'd like to define a data source view made up of three data sources, and
> it
> works well, but when it comes to generating the report model, it seems to
> me
> that only the primary data source is availible for the report model. Is
> this
> true? If so it's a real showstopper for me. The solutions I see for this
> problem is:
> 1. Views to the other databases
> 2. Building a ssas cube to overcome the limitations
> Please help me out!
> "Bruce L-C [MVP]" wrote:
>> Still true in RS 2005.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Sorcerdon" <sorcerdon@.gmail.com> wrote in message
>> news:1136556065.510433.278670@.g49g2000cwa.googlegroups.com...
>> > David,
>> >
>> > The only limit that I know is that reporting services 2000 (Dont know
>> > aboout 2005), is that you can't use 2 data sets for 1 table - so you
>> > cant MERGE data into 1 table.
>> > So I would recommend either creating a store procedure as suggested by
>> > Kaisa that would get data from different databases.
>> >
>> > If you want the data in two different tables, then YES you can use 2
>> > tables, or a subreport as suggested by Bruce.
>> >
>> > Regards,
>> >
>> > Stas K.
>> >
>>|||Given that report models are based off a data source I would lean towards
"no" without some additional work. Looks like a cube may be your best bet
for gathering data like that.
"Erik Hedlund" <ErikHedlund@.discussions.microsoft.com> wrote in message
news:7EDBEB3A-BAE8-431E-AB03-B866C2C179E2@.microsoft.com...
> Is it possible to collect data from multiple databases in a report model
> also?
> I'd like to define a data source view made up of three data sources, and
> it
> works well, but when it comes to generating the report model, it seems to
> me
> that only the primary data source is availible for the report model. Is
> this
> true? If so it's a real showstopper for me. The solutions I see for this
> problem is:
> 1. Views to the other databases
> 2. Building a ssas cube to overcome the limitations
> Please help me out!
> "Bruce L-C [MVP]" wrote:
>> Still true in RS 2005.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Sorcerdon" <sorcerdon@.gmail.com> wrote in message
>> news:1136556065.510433.278670@.g49g2000cwa.googlegroups.com...
>> > David,
>> >
>> > The only limit that I know is that reporting services 2000 (Dont know
>> > aboout 2005), is that you can't use 2 data sets for 1 table - so you
>> > cant MERGE data into 1 table.
>> > So I would recommend either creating a store procedure as suggested by
>> > Kaisa that would get data from different databases.
>> >
>> > If you want the data in two different tables, then YES you can use 2
>> > tables, or a subreport as suggested by Bruce.
>> >
>> > Regards,
>> >
>> > Stas K.
>> >
>>|||Well, the report model is based upon a data source view, which is an
abstractionlayer on top of the data source(s). I the data source view it is
no problem to use tables from many data sources, but when it comes to the
report model, it seems to me that only the primary data source in the data
soure view is "in reach". I think that this is rather odd. Why should the
report model be concerned about what lies bellow the abstraction layer?
"Chris Taylor" wrote:
> Given that report models are based off a data source I would lean towards
> "no" without some additional work. Looks like a cube may be your best bet
> for gathering data like that.
>
> "Erik Hedlund" <ErikHedlund@.discussions.microsoft.com> wrote in message
> news:7EDBEB3A-BAE8-431E-AB03-B866C2C179E2@.microsoft.com...
> > Is it possible to collect data from multiple databases in a report model
> > also?
> >
> > I'd like to define a data source view made up of three data sources, and
> > it
> > works well, but when it comes to generating the report model, it seems to
> > me
> > that only the primary data source is availible for the report model. Is
> > this
> > true? If so it's a real showstopper for me. The solutions I see for this
> > problem is:
> > 1. Views to the other databases
> > 2. Building a ssas cube to overcome the limitations
> >
> > Please help me out!
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Still true in RS 2005.
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Sorcerdon" <sorcerdon@.gmail.com> wrote in message
> >> news:1136556065.510433.278670@.g49g2000cwa.googlegroups.com...
> >> > David,
> >> >
> >> > The only limit that I know is that reporting services 2000 (Dont know
> >> > aboout 2005), is that you can't use 2 data sets for 1 table - so you
> >> > cant MERGE data into 1 table.
> >> > So I would recommend either creating a store procedure as suggested by
> >> > Kaisa that would get data from different databases.
> >> >
> >> > If you want the data in two different tables, then YES you can use 2
> >> > tables, or a subreport as suggested by Bruce.
> >> >
> >> > Regards,
> >> >
> >> > Stas K.
> >> >
> >>
> >>
> >>
>
>

Multiple database question

I am planning to develop reports using reporting services. My reports will use data from 3 different SQL Server databases that are application specific on three different cpu's. I'm planning on having a reporting database that is a common repository for data extraction / summarization from the other 3 databases.

I'm trying to understand the best way to approach my design (it's been a while since I've done database work - pretty obvious...):

Use Analysis Services to move the data from the three databases to the reporting database server.

Create some stored procedures that can do this.

I'm not seeing the reporting services as being a "data movement" tool but more of a shell data access tool (correct?).

Other tools someone would suggest.

Thanks and any help would be appreciated.You could also look at replication,DTS, and even log shipping.|||Hi there,

If your (or some) reports need to COMBINE the data from the three databases, you definitely need a common data access like you mentionned. But if you have "Report A" that needs the data from "Database A" and "Report B" from "Database B", that's a breeze.

Each report has it's own datasource setup. That's it!|||tootoo, there's nothing wrong with your solution. However, the snapshot approach might be needed as reporting can sometimes crucify the perf of a database.

multiple connects to database

How does reporting services handle connection strings. There is a single report using a shared datasource. Testing this report seems to generate multiple connections to the database for a single user. The report being tested has 4 datasets (3 to obtain parameter value lists) using the same shared datasource but the number of connections for the single user were 20 in one instance. When does reporting services make the connection and when does it release it? It didnt seem to let these go when the report was done executing. Using RS2005 sp1 with DB2The Report Server processes the dataset queries in parallel whenever possible. This is why you see three connections open when you run a report with multiple datasets. Not sure why the number of connections jump to 20. Does the DB2 provider support connection pooling?