473,563 Members | 2,904 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 1392
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
3335
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...
10
3830
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...
3
1162
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...
3
1335
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...
2
1678
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
1409
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
1707
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...
3
1641
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,...
0
7664
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...
0
7583
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...
0
7885
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. ...
0
8106
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...
1
7638
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7948
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5484
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...
0
3642
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
1198
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.