473,699 Members | 2,279 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

MSDE and SQL2000 on Win2k3

Hi all,

I have MSDE installed on an HP server as some of the utilities required
a database. I have also subsequently installed SQL 2000 onto this
server which is a windows 2003 box. I know it complains at the start
of the installation but I was under the impression that it would still
work ok, especially with SP3 applied.

I have tried to apply SP3 but it tells me that it is not a SQL2000
instance ad setup will exit?

Also I have noticed that in the directory structure it has used the
dollar sign i.e. mssql$machinena me its the same in Enterprise Manager
\\machinename$I nstanceName. Whats that all about? Its not like that on
any other server!

My plan is to uninstall sql 2k, uninstall HP apps and MSDE and
reinstall SQL 2k. Can anyone explain the above though?

Thanks

Gary

Jul 23 '05 #1
2 1398
Gary,
MSDE is an instance of SQL Server. Since it was the first thing installed,
it is taking up the default instance. I assume when you installed SQL
Server 2000 it installed as a named instance. Both can run on the server at
the same time but it's a little more difficult to manage. Your probably
dealing with HPs volume manager. In my opinion the ability to expand
partitions isn't worth the odd SQL install if this is a database server.

<gd*****@hotmai l.com> wrote in message
news:11******** **************@ g43g2000cwa.goo glegroups.com.. .
Hi all,

I have MSDE installed on an HP server as some of the utilities required
a database. I have also subsequently installed SQL 2000 onto this
server which is a windows 2003 box. I know it complains at the start
of the installation but I was under the impression that it would still
work ok, especially with SP3 applied.

I have tried to apply SP3 but it tells me that it is not a SQL2000
instance ad setup will exit?

Also I have noticed that in the directory structure it has used the
dollar sign i.e. mssql$machinena me its the same in Enterprise Manager
\\machinename$I nstanceName. Whats that all about? Its not like that on
any other server!

My plan is to uninstall sql 2k, uninstall HP apps and MSDE and
reinstall SQL 2k. Can anyone explain the above though?

Thanks

Gary

Jul 23 '05 #2
Hi Danny.

Thanks for the info, I think your right. I have zapped all the HP
stuff and removed all MSDE and SQL and reinstalled SQL and been able to
install sp3.

I can probably still use the Hp tools but point them to SQL.

and yes it is a database server!

Gary

Jul 23 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
3340
by: LizP | last post by:
Hi, guys - looking for a bit of help/advice on moving a database from SQL 7 to SQL 2000. We've a third party application which currently uses a SQL7 database. This database has a number of views which are owned by user INFORMATION_SCHEMA and are set as system tables. This user doesn't actually have a login on the SQL server. We've tried the following to recreate the database on SQL2000, but whatever we try, the views owned by...
10
3846
by: noname | last post by:
MSDE 2000 Release A installed under windows 2000 pro will not communicate with SQL Server Manager nor MS Access on peer computer. Can someone help? Have set DISABLENETWORKPROTOCOLS=0 at install time. Install log shows installation successful.. Control Panel> Admin Tools> Services section shows SQL server instance running.
11
942
by: ptass | last post by:
Hi I've installed win2k3 sp1 on a machine where an openRead on any given file was previously working. After installation, I get a webException as follows... ..message "An exception occurred during a webclient request" .._Hresult = "-2146233079" .._COMPlusExceptionCode ="-532459699" Sorry I don't have the whole error, but this seems to be the only pertinent
3
1166
by: JFB | last post by:
Hi Folks, Does anyone implement an application using vb.net and MSDE 2000? or anyone can help me, please? Can I use in my pc with sql2000 and vb.net to create the all application and them create an MSI file and install the application in the client pc but including MSDE 2000 into the setup? This is a small app and I want to use MSDE 2000 for now, if the data grow I want to use sql2000. Tks in advance and any tip will be appreciate. JFB
3
1339
by: David Lozzi | last post by:
Howdy! I have a question for all you smarties... I have a ASP.Net application running on Windows 2000 Professional and MSDE, same box. While running the application, users will randomly receive a too many connections error or even a simple Page cannot be displayed. I know some of the limitations of MSDE and have managed to fudge my way around them, but what about Win2kPro IIS? I'm thinking it won't let me a host an active application on...
2
1683
by: PointMan | last post by:
i make a project in vs2005 that use ASPNETDB.MDF and use <asp:LoginView ID="LoginView1" runat="server" > server control for vs2005 in this case , i'd like to use hosting service but this hosting company does not support sql2005 that's why i have to use sql2000 so my quetion is how can i migration this for sql2000??
2
1412
by: victor murage | last post by:
hi, i have been trying to migrate an msde database from server a to server b by copying.the data is in mdf form and after copying its bringing a fatal conflict.am using equitrac 3.0 print management solution.how do i transfr this data to eiher msde or to sql2000
0
1727
by: basuritta | last post by:
I am trying to add a SQL2000 subscriptor to a SQL2005 publisher and distributor using the Management Studio. I'm using a non-standard port in both ends, but I have set the port for the TCP/IP protocol to the non-standard port in both the server and client network configuration. I can add the SQL2000 server to the Management Studio console without problems, and even without haveing to specify the port I'm using (as expected)
3
1650
by: igovada | last post by:
Hi I'm trying to install MSDE 2000 on my WIN XP machine using the setup.exe, but it always gives me error saying "set strong sa password" after the message " Please Wait while windows configures Microsoft SQL Server Desktop Engine" I also tried installing it by command line command below, it shows that its configuring and installing software, but disappears in the middle. I see the SqlServer agent installed and also folders inside C:\Program...
0
8700
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8623
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9184
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9048
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
6539
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4635
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3064
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2359
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2014
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.