Can MSDE and SQL 2000 exist on same box?

Want to Install WSUS with MSDE on a MOM server with SQL2000 SP4. Is
this practical/best practice? Any issues that may arise from this?
Anything that I should look out for? Thanks in advance.
Yes, one will the the 'default' server, and the others will be a named
'instance'. There may be (at times) several different MSDE (or SQL 2005
Express) instances on a server for various applications.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"tc" <tchang73nyc@.yahoo.com> wrote in message
news:1162927224.106887.280150@.h54g2000cwb.googlegr oups.com...
> Want to Install WSUS with MSDE on a MOM server with SQL2000 SP4. Is
> this practical/best practice? Any issues that may arise from this?
> Anything that I should look out for? Thanks in advance.
>

Can I use MDSE instead of SQL 2000 ??

Hey guru's out there I'm attempting to run a test box with mdse instead of sql 2000 with the commerce kit..i get the following error message...when attempting to access iis: The service is installed and running on xp...

HELP

Server Error in '/CommerceVBSDK' Application.

SQL Server does not exist or access denied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.

Source Error:

Line 28: Dim products As ASPNET.StarterKit.Commerce.ProductsDB = New ASPNET.StarterKit.Commerce.ProductsDB()
Line 29:
Line 30: MyList.DataSource = products.GetProductCategories()
Line 31: MyList.DataBind()
Line 32:

Source File: C:\Program Files\ASP.NET Starter Kits\ASP.NET Commerce (VBSDK)\CommerceVBSDK\_Menu.ascx Line: 30

Stack Trace:

[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
ASPNET.StarterKit.Commerce.ProductsDB.GetProductCategories()
ASP._Menu_ascx.Page_Load(Object sender, EventArgs e) in C:\Program Files\ASP.NET Starter Kits\ASP.NET Commerce (VBSDK)\CommerceVBSDK\_Menu.ascx:30
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Page.ProcessRequestMain() +731Try creating a blank Database with OSQL and give ASP.NET account DBO permissions in the Database before installing the Commerce Starter kit. Hope this thelps.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde2kwrk/html/msde2000webapp.asp

Kind regards,
Gift Peddie

Can I run SQL db, RS 2000, and Analysis server all on 1 box?

We currently have SERVER A which is just IIS for VS2002 applications(and some
file shares). And SERVER B that has SQL 2000-Enterprise Edition. I would
like to use RS 2000 and Analysis server/BI? Can I have all 3(db, rs, as)
running on one box? If so, what are the requirements? But doesn't RS 2000,
need IIS? Then I would need to install RS on SERVER A. But then SERVER A
would need a SQL Enterprise licenses? So really, RS 2000 is not free?!?!?There is nothing preventing you from having IIS on your SQL Server box. If
you run it all on the same box it is free. Otherwise you are correct, you
have to have another license. One alternative would be to license for
Standard on the IIS box instead of Enterprise if you don't need Enterprise
features.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"fjahnke" <fjahnke@.discussions.microsoft.com> wrote in message
news:935BF15C-10C0-451C-AD14-B7CC8B0BF651@.microsoft.com...
> We currently have SERVER A which is just IIS for VS2002 applications(and
> some
> file shares). And SERVER B that has SQL 2000-Enterprise Edition. I would
> like to use RS 2000 and Analysis server/BI? Can I have all 3(db, rs, as)
> running on one box? If so, what are the requirements? But doesn't RS
> 2000,
> need IIS? Then I would need to install RS on SERVER A. But then SERVER A
> would need a SQL Enterprise licenses? So really, RS 2000 is not free?!?!?|||Thanks Bruce,
This helps! So Standard has RS and AS?
I have always heard that SQL db on IIS is not good. Is that a horsepower
issue?
Speaking of horse power, how would I find out what kind of power I would
need to have everything on one box(IIS, SQL DB, RS and AS)?
With a very limited budget, what configuration/distribution of apps would
you recommend(be it multi-server or big honkin' server)?
thanks,
Fred
"Bruce L-C [MVP]" wrote:
> There is nothing preventing you from having IIS on your SQL Server box. If
> you run it all on the same box it is free. Otherwise you are correct, you
> have to have another license. One alternative would be to license for
> Standard on the IIS box instead of Enterprise if you don't need Enterprise
> features.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "fjahnke" <fjahnke@.discussions.microsoft.com> wrote in message
> news:935BF15C-10C0-451C-AD14-B7CC8B0BF651@.microsoft.com...
> > We currently have SERVER A which is just IIS for VS2002 applications(and
> > some
> > file shares). And SERVER B that has SQL 2000-Enterprise Edition. I would
> > like to use RS 2000 and Analysis server/BI? Can I have all 3(db, rs, as)
> > running on one box? If so, what are the requirements? But doesn't RS
> > 2000,
> > need IIS? Then I would need to install RS on SERVER A. But then SERVER A
> > would need a SQL Enterprise licenses? So really, RS 2000 is not free?!?!?
>
>|||No, I was not talking about AS. I am just talking about whether you put RS
on the same box as your SQL Server. If your box is at least a
multi-processor box with a decent amount of RAM. I have a two processor, 2
Gigs RAM box with SQL Server datamart, IIS and RS running on it. It has no
problem. The datamart is currently about 10 Gig (not that big although one
table in it is up to 80 million rows). How to size a server is a bit of an
art. It really depends on the amount of data, the amount of users, how is it
being used (oltp, datamart, etc). My own experience with SQL Server is it is
a pretty good citizen with how it uses RAM. It will take and give up RAM
depending on the load on the server. I don't have any experience with AS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"fjahnke" <fjahnke@.discussions.microsoft.com> wrote in message
news:540D6453-3DC4-4C0B-A784-926B44AF43CB@.microsoft.com...
> Thanks Bruce,
> This helps! So Standard has RS and AS?
> I have always heard that SQL db on IIS is not good. Is that a horsepower
> issue?
> Speaking of horse power, how would I find out what kind of power I would
> need to have everything on one box(IIS, SQL DB, RS and AS)?
> With a very limited budget, what configuration/distribution of apps
> would
> you recommend(be it multi-server or big honkin' server)?
> thanks,
> Fred
> "Bruce L-C [MVP]" wrote:
>> There is nothing preventing you from having IIS on your SQL Server box.
>> If
>> you run it all on the same box it is free. Otherwise you are correct, you
>> have to have another license. One alternative would be to license for
>> Standard on the IIS box instead of Enterprise if you don't need
>> Enterprise
>> features.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "fjahnke" <fjahnke@.discussions.microsoft.com> wrote in message
>> news:935BF15C-10C0-451C-AD14-B7CC8B0BF651@.microsoft.com...
>> > We currently have SERVER A which is just IIS for VS2002
>> > applications(and
>> > some
>> > file shares). And SERVER B that has SQL 2000-Enterprise Edition. I
>> > would
>> > like to use RS 2000 and Analysis server/BI? Can I have all 3(db, rs,
>> > as)
>> > running on one box? If so, what are the requirements? But doesn't RS
>> > 2000,
>> > need IIS? Then I would need to install RS on SERVER A. But then
>> > SERVER A
>> > would need a SQL Enterprise licenses? So really, RS 2000 is not
>> > free?!?!?
>>|||Thanks again Bruce. This is very helpful. I will search the technet on SQL
OLAP for answers on AS.
Thanks,
Fred
"Bruce L-C [MVP]" wrote:
> No, I was not talking about AS. I am just talking about whether you put RS
> on the same box as your SQL Server. If your box is at least a
> multi-processor box with a decent amount of RAM. I have a two processor, 2
> Gigs RAM box with SQL Server datamart, IIS and RS running on it. It has no
> problem. The datamart is currently about 10 Gig (not that big although one
> table in it is up to 80 million rows). How to size a server is a bit of an
> art. It really depends on the amount of data, the amount of users, how is it
> being used (oltp, datamart, etc). My own experience with SQL Server is it is
> a pretty good citizen with how it uses RAM. It will take and give up RAM
> depending on the load on the server. I don't have any experience with AS.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "fjahnke" <fjahnke@.discussions.microsoft.com> wrote in message
> news:540D6453-3DC4-4C0B-A784-926B44AF43CB@.microsoft.com...
> > Thanks Bruce,
> > This helps! So Standard has RS and AS?
> >
> > I have always heard that SQL db on IIS is not good. Is that a horsepower
> > issue?
> >
> > Speaking of horse power, how would I find out what kind of power I would
> > need to have everything on one box(IIS, SQL DB, RS and AS)?
> >
> > With a very limited budget, what configuration/distribution of apps
> > would
> > you recommend(be it multi-server or big honkin' server)?
> >
> > thanks,
> > Fred
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> There is nothing preventing you from having IIS on your SQL Server box.
> >> If
> >> you run it all on the same box it is free. Otherwise you are correct, you
> >> have to have another license. One alternative would be to license for
> >> Standard on the IIS box instead of Enterprise if you don't need
> >> Enterprise
> >> features.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "fjahnke" <fjahnke@.discussions.microsoft.com> wrote in message
> >> news:935BF15C-10C0-451C-AD14-B7CC8B0BF651@.microsoft.com...
> >> > We currently have SERVER A which is just IIS for VS2002
> >> > applications(and
> >> > some
> >> > file shares). And SERVER B that has SQL 2000-Enterprise Edition. I
> >> > would
> >> > like to use RS 2000 and Analysis server/BI? Can I have all 3(db, rs,
> >> > as)
> >> > running on one box? If so, what are the requirements? But doesn't RS
> >> > 2000,
> >> > need IIS? Then I would need to install RS on SERVER A. But then
> >> > SERVER A
> >> > would need a SQL Enterprise licenses? So really, RS 2000 is not
> >> > free?!?!?
> >>
> >>
> >>
>
>

Can I just use Management Studio for now?

I don't have a SQL dev box to install a full blown CTP on, but I was wondering if it is possible to somehow only install Managememnt Studio on my client to work on SQL 2000 servers?

I downloaded the June CTP and tried to run setup on my client, hoping it would work similarly to the SQL 2000 install and auto recognize that the machine wasn't a server and just install the client tools, but setup generates a WMI error and closes down.

Anyone know if this is possible? I would really like to start using Management Studio to get used to it...

ThanksIt is possible to only install SSMS but you are going to have to install >net Frameworks B2, also you can not use it in production and SSMS does not have full support for SQl2k (can't manage services and some other stuff).

-Euan

Can I install SQL2000 on WinXP?

Hi,
I need to install SQL Server 2000 on a Windows XP box.. is this possible?
if yes, how?
if no... can I only install MSDE?
if yes I have not been able to install MSDE successfully while being able
to specify the sa password... and attach my database...
any help greatly appreciated!!!
MichelleYes you can. You can install either the desktop edition or the developer
edition. More info in this url:
http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.asp
--
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 Programming by Example
"Michelle" <nobody@.email.com> wrote in message
news:OTYOaBo5DHA.1596@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I need to install SQL Server 2000 on a Windows XP box.. is this possible?
> if yes, how?
> if no... can I only install MSDE?
> if yes I have not been able to install MSDE successfully while being
able
> to specify the sa password... and attach my database...
> any help greatly appreciated!!!
> Michelle
>|||I dont think you will be able to install either SQL 2000 Standard or
Enterprise editions. You should however, be able to install the Personal
edition or MSDE...
Cheers,
James Goodman MCSE, MCDBA
http://www.angelfire.com/sports/f1pictures

Can I install SQL2000 on WinXP?

Hi,
I need to install SQL Server 2000 on a Windows XP box.. is this possible?
if yes, how?
if no... can I only install MSDE?
if yes I have not been able to install MSDE successfully while being able
to specify the sa password... and attach my database...
any help greatly appreciated!!!
MichelleYes you can. You can install either the desktop edition or the developer
edition. More info in this url:
http://www.microsoft.com/sql/evalua...000/default.asp
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"Michelle" <nobody@.email.com> wrote in message
news:OTYOaBo5DHA.1596@.TK2MSFTNGP10.phx.gbl...

quote:

---

> Hi,
> I need to install SQL Server 2000 on a Windows XP box.. is this possible?
> if yes, how?
> if no... can I only install MSDE?
> if yes I have not been able to install MSDE successfully while being

---

able

quote:

---

> to specify the sa password... and attach my database...
> any help greatly appreciated!!!
> Michelle
>

---

|||I dont think you will be able to install either SQL 2000 Standard or
Enterprise editions. You should however, be able to install the Personal
edition or MSDE...
Cheers,
James Goodman MCSE, MCDBA
http://www.angelfire.com/sports/f1pictures