Showing posts with label settings. Show all posts
Showing posts with label settings. Show all posts

Thursday, March 22, 2012

(Cluster) Memory settings

Hello, I am purchasing a HP DL-380 (Cluster)
I am planing to install Windows 2003 and SQL 2000
Both machines has two processors and 4 GB o Physical Memory (RAM), but I
want to put 6 GB in the
Active Machine and 2 GB in the Passive Machine.
So, That is possible?
1) Is possible to have differentes memory configuration in a cluster?
2) SQL 2000 and Windows 2003 supports 6GB of Physical Memory?
Thanks a lot!!
AA
I forgot to mention that both machine are with 32 bits processors
Thanks again
AA
"AA" <aa@.personal.net.py> wrote in message
news:%23K0V94MIEHA.2376@.TK2MSFTNGP12.phx.gbl...
> Hello, I am purchasing a HP DL-380 (Cluster)
> I am planing to install Windows 2003 and SQL 2000
> Both machines has two processors and 4 GB o Physical Memory (RAM), but I
> want to put 6 GB in the
> Active Machine and 2 GB in the Passive Machine.
> So, That is possible?
> 1) Is possible to have differentes memory configuration in a cluster?
> 2) SQL 2000 and Windows 2003 supports 6GB of Physical Memory?
>
> Thanks a lot!!
>
> AA
>

(Cluster) Memory settings

Hello, I am purchasing a HP DL-380 (Cluster)
I am planing to install Windows 2003 and SQL 2000
Both machines has two processors and 4 GB o Physical Memory (RAM), but I
want to put 6 GB in the
Active Machine and 2 GB in the Passive Machine.
So, That is possible?
1) Is possible to have differentes memory configuration in a cluster?
2) SQL 2000 and Windows 2003 supports 6GB of Physical Memory?
Thanks a lot!!
AA
Do not do this. Just remember that some day resources from node one with 6GB of memory failover to node 2 with 2GB of memory. What will you do then
rgds
Sinisa Perovic
|||What you will do then is exactly what everyone has to do who is running a
configuration with dissimilar processing capacity. You plan for the case
where both are running on the node with the least power. You estimate the
degradation in performance for the applications based on various load and
time scenarios. You then make a business decision as to whether that
degradation in performance during that specific downtime scenario is
acceptable or not. If it is acceptable, you configure it and off you go.
If it isn't acceptable, you come up with alternatives. Saying to not ever
do this is a very simplistic answer that simply is not correct.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com

Thursday, February 9, 2012

#### Security on Report Manager ####

Hi:
I have security settings for everyone as browser on my home directory of the
report manager. No matter what settings I have for the browser role, (view
reports lets him view report properties as well). But i dont want my users to
go in and chnage the data source properties or parameters. How can i not show
the properties tab for the reports, but still have the susbcription available.
ThanksIf the account your testing with sees other report properties than jsut the
General properties (which would not let them get at the
data source) then it is not coming in as "Everyone". May be the account
you are testing with is a member of a higher privelege group.
"Everyone" should have the ability to access subscriptions so long as report
is being executed using stored credentials.
--
-- "This posting is provided 'AS IS' with no warranties, and confers no
rights."
jhmiller@.online.microsoft.com
"NI" <NI@.discussions.microsoft.com> wrote in message
news:5D49B753-7185-49B1-92C5-249A0A6E0788@.microsoft.com...
> Hi:
> I have security settings for everyone as browser on my home directory of
> the
> report manager. No matter what settings I have for the browser role,
> (view
> reports lets him view report properties as well). But i dont want my users
> to
> go in and chnage the data source properties or parameters. How can i not
> show
> the properties tab for the reports, but still have the susbcription
> available.
> Thanks|||Thats exactly what I want, browser be able to see just general properties and
subscription, and not get to parameters and data sources. And you may be
right when you say, the acocunt I am testing with is not coming in as
Everyone. Before I had "everyone" set up on the home directory, I used to
have a bunch of accounts (individual user in the format domain\user) set up.
Now I removed all those individual settings and have just everyone. But when
I look at the ReportServer DB and Users table, it has everyone with userType
1 and Auth Type 1. And it has those individual user accounts I used to have
with userType 1and Auth Type 1, and it has some other indivual accounts
(whihc I never set up, but they r probably hitting the reports coz everyone
can see them), with userTpe 0 and authType 1. Also one wierd thing, it has
"domain\" with UserType 1 and AuthType 1.
Anything wrong happening here.
Thanks a bunch
"John H. Miller" wrote:
> If the account your testing with sees other report properties than jsut the
> General properties (which would not let them get at the
> data source) then it is not coming in as "Everyone". May be the account
> you are testing with is a member of a higher privelege group.
> "Everyone" should have the ability to access subscriptions so long as report
> is being executed using stored credentials.
> --
> -- "This posting is provided 'AS IS' with no warranties, and confers no
> rights."
> jhmiller@.online.microsoft.com
> "NI" <NI@.discussions.microsoft.com> wrote in message
> news:5D49B753-7185-49B1-92C5-249A0A6E0788@.microsoft.com...
> > Hi:
> >
> > I have security settings for everyone as browser on my home directory of
> > the
> > report manager. No matter what settings I have for the browser role,
> > (view
> > reports lets him view report properties as well). But i dont want my users
> > to
> > go in and chnage the data source properties or parameters. How can i not
> > show
> > the properties tab for the reports, but still have the susbcription
> > available.
> >
> > Thanks
>
>