Can I install more then one copy of MSDE on a server?

We are running a Windows 2003 domain. I have a Windows 2003 member server
running an app. and MSDE.
I now have another app. that I would like to install on this same server.
The new app. also needs MSDE. My question is can I install and run more
then one copy of MSDE? Is there anything I need to know about doing it?
TIA,
ClaytonOr can I just use the same MSDE for the new app.? Can MSDE have more the
one DB?
TIA,
Clayton
"Clayton" <none@.none.com> wrote in message
news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
> We are running a Windows 2003 domain. I have a Windows 2003 member server
> running an app. and MSDE.
> I now have another app. that I would like to install on this same server.
> The new app. also needs MSDE. My question is can I install and run more
> then one copy of MSDE? Is there anything I need to know about doing it?
>
> TIA,
> Clayton
>|||Can both apps. share the same MSDE install?
TIA,
Clayton
"Clayton" <none@.none.com> wrote in message
news:DNhog.34477$Bh2.16824@.fe07.news.easynews.com...
> Or can I just use the same MSDE for the new app.? Can MSDE have more the
> one DB?
>
> TIA,
> Clayton
>
> "Clayton" <none@.none.com> wrote in message
> news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
>> We are running a Windows 2003 domain. I have a Windows 2003 member
>> server running an app. and MSDE.
>> I now have another app. that I would like to install on this same server.
>> The new app. also needs MSDE. My question is can I install and run more
>> then one copy of MSDE? Is there anything I need to know about doing it?
>>
>> TIA,
>> Clayton
>|||Yes, you can. It just requires a different instance name than the other
installed instances.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Clayton" <none@.none.com> wrote in message
news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
We are running a Windows 2003 domain. I have a Windows 2003 member server
running an app. and MSDE.
I now have another app. that I would like to install on this same server.
The new app. also needs MSDE. My question is can I install and run more
then one copy of MSDE? Is there anything I need to know about doing it?
TIA,
Clayton|||You can install up to 16 instances of MSDE (I think that is still
correct -someone correct me if I'm wrong.) on the same server.
However, each additional instance will have a variation in the instance
name. For example, if your server is MyServer, the first installation of
MSDE (or SQL Server) will be know as MyServer. When you install a second
instance of MSDE, you are required to provide an 'instance' name (e.g.,
Accounting). Then that server/instance will be referred to as
MyServer\Accounting. You have to use the compounded name in all connection
strings, etc.
That may not be a simple issue for many third party applications. (I would
hope so -but I've learned to be pessimistic about the skills of a lot of
programmers.)
[Loud retort from over my shoulder ="Hey, I represent that remark!"]
--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another Certification Exam
"Clayton" <none@.none.com> wrote in message
news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
> We are running a Windows 2003 domain. I have a Windows 2003 member server
> running an app. and MSDE.
> I now have another app. that I would like to install on this same server.
> The new app. also needs MSDE. My question is can I install and run more
> then one copy of MSDE? Is there anything I need to know about doing it?
>
> TIA,
> Clayton
>|||Cool, thanks guys. I have to go live with this thing (BlackBerry) within
the hour!
Thanks for your help,
Clayton
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:O7BA$QjmGHA.3732@.TK2MSFTNGP05.phx.gbl...
> You can install up to 16 instances of MSDE (I think that is still
> correct -someone correct me if I'm wrong.) on the same server.
> However, each additional instance will have a variation in the instance
> name. For example, if your server is MyServer, the first installation of
> MSDE (or SQL Server) will be know as MyServer. When you install a second
> instance of MSDE, you are required to provide an 'instance' name (e.g.,
> Accounting). Then that server/instance will be referred to as
> MyServer\Accounting. You have to use the compounded name in all connection
> strings, etc.
> That may not be a simple issue for many third party applications. (I would
> hope so -but I've learned to be pessimistic about the skills of a lot of
> programmers.)
> [Loud retort from over my shoulder ="Hey, I represent that remark!"]
> --
> Arnie Rowland, YACE*
> "To be successful, your heart must accompany your knowledge."
> *Yet Another Certification Exam
>
> "Clayton" <none@.none.com> wrote in message
> news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
>> We are running a Windows 2003 domain. I have a Windows 2003 member
>> server running an app. and MSDE.
>> I now have another app. that I would like to install on this same server.
>> The new app. also needs MSDE. My question is can I install and run more
>> then one copy of MSDE? Is there anything I need to know about doing it?
>>
>> TIA,
>> Clayton
>|||That depends on the app. The app may expect a particular instance name, for
example.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Clayton" <none@.none.com> wrote in message
news:DNhog.34477$Bh2.16824@.fe07.news.easynews.com...
Or can I just use the same MSDE for the new app.? Can MSDE have more the
one DB?
TIA,
Clayton
"Clayton" <none@.none.com> wrote in message
news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
> We are running a Windows 2003 domain. I have a Windows 2003 member server
> running an app. and MSDE.
> I now have another app. that I would like to install on this same server.
> The new app. also needs MSDE. My question is can I install and run more
> then one copy of MSDE? Is there anything I need to know about doing it?
>
> TIA,
> Clayton
>|||Yes, one instance of MSDE (which is a version of SQL Server) can handle
quite a few databases. Depends on hardware, traffic, etc., subject to the
MSDE sizing limitations.
--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another Certification Exam
"Clayton" <none@.none.com> wrote in message
news:OOhog.362227$Az2.335116@.fe10.news.easynews.com...
> Can both apps. share the same MSDE install?
> TIA,
> Clayton
>
> "Clayton" <none@.none.com> wrote in message
> news:DNhog.34477$Bh2.16824@.fe07.news.easynews.com...
>> Or can I just use the same MSDE for the new app.? Can MSDE have more the
>> one DB?
>>
>> TIA,
>> Clayton
>>
>> "Clayton" <none@.none.com> wrote in message
>> news:zEhog.34345$Bh2.22632@.fe07.news.easynews.com...
>> We are running a Windows 2003 domain. I have a Windows 2003 member
>> server running an app. and MSDE.
>> I now have another app. that I would like to install on this same
>> server. The new app. also needs MSDE. My question is can I install and
>> run more then one copy of MSDE? Is there anything I need to know about
>> doing it?
>>
>> TIA,
>> Clayton
>>
>

Can I hide displaying a certain member?

Hi,

I have a dimension called customers having the following levels:

ALL
Level 1 CustType
Level 2 Cust Rank
Level 3 Cust Name

Suppose that the possible CustTypes are "Potential", "Active", "Lost".
Is it possible to hide displaying Level 1 and below if the Custtype (Level 1) = "Potential"create a view on the table like select col1,col3 from the table and access (http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21175087.html#) the view.|||Thanks for the reply. Yup it seems that the view approach is what I will have to go with.

Calling Webservice

Hi Scott,
Thanks for the input, but this user has been made a member of all of
the roles defined within Reporting services. i.e "Browser",
"Publisher","My Reports", "Content Manager". I've tried all
combinations of these. No joy. The user has to be a member of the
"Administrators Group" on the machine itself (it appears?).
Scott Allen wrote:
> Hi Amy:
>
> Reporting services uses roles based authorization, and the default
> setup only places the local administrator into a role.
>
> While RSAdminUser might have rights to access all the files and
> folders in the reporting services installation, you still have to put
> the user into a "role". Roles are how RS determines who can browse a
> folder, who can view a report, who can manage a data source etc.
>
> From your reports home page you can go to Site Settings -> Configure
> site wide security (link is at the bottom). Perhaps you should define
> a new role for RSAdminUser and grant just enough authorization for
the
> user to get the things done you need.
>
> Hope this helps,
>
> --
> Scott
> http://www.OdeToCode.com
>
> On 3 Aug 2004 05:04:48 -0700, amydudley@.webmail.co.za (Amy) wrote:
>
> >Hi,
> >
> >I have set the Reporting WebServices WebService Directory Security
in
> >IIS to Windows Authentication. The authentication setting in the
> >config file is set to "Windows" with Impersonation set to "true".
> >
> >I created an account called "RSAdminUser" with which to call the
> >webservice.
> >When calling the "ListReportsUsingDataSource" method, after setting
> >the credentials to this "RSAdminUser", I get the following error:
> >
> >"System.Web.Services.Protocols.SoapException: The permissions
granted
> >to user 'SERVER\RSAdminUser' are insufficient for performing this
> >operation. -->
Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException:
> >The permissions granted to user 'SERVER\RSAdminUser' are
insufficient
> >for performing this operation. at
>
>Microsoft.ReportingServices.Library.RSService.ListReportsUsingDataSource(String
> >path) at
Microsoft.ReportingServices.WebServer.ReportingService.ListReportsUsingDataSource(String
> >DataSource, CatalogItem[]& Reports) -- End of inner exception stack
> >trace -- at
Microsoft.ReportingServices.WebServer.ReportingService.ListReportsUsingDataSource(String
> >DataSource, CatalogItem[]& Reports)"
> >
> >I have methodically given this user permissions to all of the
relevant
> >folders and files that I can think of, but the only thing that makes
> >this work is making "RSAdminUser" a member of the "Administrators"
> >group. Is it possible that only members of the "Administrators"
group
> >are allowed to execute this method?
> >
> >Is there an alternative solution? What permissions does this
account
> >need to execute this method?
> >
> >Thanks in advance,
> >
> >AmyWhat is the path of the data source in the namespace. Is it nested several
folders deep and have you given the user rights to all items in the path to
the data source?
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"ALD" <amydudley@.webmail.co.za> wrote in message
news:cesoec$hlm@.odak26.prod.google.com...
> Hi Scott,
> Thanks for the input, but this user has been made a member of all of
> the roles defined within Reporting services. i.e "Browser",
> "Publisher","My Reports", "Content Manager". I've tried all
> combinations of these. No joy. The user has to be a member of the
> "Administrators Group" on the machine itself (it appears?).
> Scott Allen wrote:
> > Hi Amy:
> >
> > Reporting services uses roles based authorization, and the default
> > setup only places the local administrator into a role.
> >
> > While RSAdminUser might have rights to access all the files and
> > folders in the reporting services installation, you still have to put
> > the user into a "role". Roles are how RS determines who can browse a
> > folder, who can view a report, who can manage a data source etc.
> >
> > From your reports home page you can go to Site Settings -> Configure
> > site wide security (link is at the bottom). Perhaps you should define
> > a new role for RSAdminUser and grant just enough authorization for
> the
> > user to get the things done you need.
> >
> > Hope this helps,
> >
> > --
> > Scott
> > http://www.OdeToCode.com
> >
> > On 3 Aug 2004 05:04:48 -0700, amydudley@.webmail.co.za (Amy) wrote:
> >
> > >Hi,
> > >
> > >I have set the Reporting WebServices WebService Directory Security
> in
> > >IIS to Windows Authentication. The authentication setting in the
> > >config file is set to "Windows" with Impersonation set to "true".
> > >
> > >I created an account called "RSAdminUser" with which to call the
> > >webservice.
> > >When calling the "ListReportsUsingDataSource" method, after setting
> > >the credentials to this "RSAdminUser", I get the following error:
> > >
> > >"System.Web.Services.Protocols.SoapException: The permissions
> granted
> > >to user 'SERVER\RSAdminUser' are insufficient for performing this
> > >operation. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException:
> > >The permissions granted to user 'SERVER\RSAdminUser' are
> insufficient
> > >for performing this operation. at
> >
>Microsoft.ReportingServices.Library.RSService.ListReportsUsingDataSource(St
ring
> > >path) at
>
Microsoft.ReportingServices.WebServer.ReportingService.ListReportsUsingDataS
ource(String
> > >DataSource, CatalogItem[]& Reports) -- End of inner exception stack
> > >trace -- at
>
Microsoft.ReportingServices.WebServer.ReportingService.ListReportsUsingDataS
ource(String
> > >DataSource, CatalogItem[]& Reports)"
> > >
> > >I have methodically given this user permissions to all of the
> relevant
> > >folders and files that I can think of, but the only thing that makes
> > >this work is making "RSAdminUser" a member of the "Administrators"
> > >group. Is it possible that only members of the "Administrators"
> group
> > >are allowed to execute this method?
> > >
> > >Is there an alternative solution? What permissions does this
> account
> > >need to execute this method?
> > >
> > >Thanks in advance,
> > >
> > >Amy
>