473,837 Members | 1,595 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SQL Server 2000 + 2005 working on same windows 2003 server as seperate instances

Hi all,

I just asked some people to help me out and phone microsoft with the
following information, kindly they refused unless we setup a support
contract with them first, for pre-sales information. (That really does
not sound like good business sense to me - anyway here is our problem,
if anyone could help thanks).

"To tell and ask microsoft:

We will be setting up a microsoft sql server 2000 instance running on a
windows 2003 server.

1) We need to check this can run alongside a microsoft 2003 sql server
(either workgroup or standard edition), on the same machine. Are there
any .dll clashes if we do this? If there are can we run SQL Server
2000, in a virtual machine running windows 2000 professional. (I have a
licenced copy we can use for this).

2) If we run one instance of 2000, and one of 2003 of the sql servers,
can one use the processor licence model, and one use the CAL licence
model."

Thanks for any help, and any idea why they actually force you to use
news groups for pre-sales information?

David

Nov 20 '06 #1
4 3760
David wrote:
Hi all,

I just asked some people to help me out and phone microsoft with the
following information, kindly they refused unless we setup a support
contract with them first, for pre-sales information. (That really does
not sound like good business sense to me - anyway here is our problem,
if anyone could help thanks).

"To tell and ask microsoft:

We will be setting up a microsoft sql server 2000 instance running on
a windows 2003 server.

1) We need to check this can run alongside a microsoft 2003 sql server
(either workgroup or standard edition), on the same machine. Are there
any .dll clashes if we do this? If there are can we run SQL Server
2000, in a virtual machine running windows 2000 professional. (I have
a licenced copy we can use for this).

2) If we run one instance of 2000, and one of 2003 of the sql servers,
can one use the processor licence model, and one use the CAL licence
model."

Thanks for any help, and any idea why they actually force you to use
news groups for pre-sales information?

David
I can't answer the license question, but we ran both SS2K and SS2K5 on a single
server for several months. We just had to use a non-default named instance for
the second instance installed. That means you cannot refer to the non-default
instance by IP address.

Other than being a bitch to later remove the 2K instance and switch the 2K5
instance to the default instance name we had no issues.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Nov 20 '06 #2

Rick Brandt wrote:
David wrote:
Hi all,

I just asked some people to help me out and phone microsoft with the
following information, kindly they refused unless we setup a support
contract with them first, for pre-sales information. (That really does
not sound like good business sense to me - anyway here is our problem,
if anyone could help thanks).

"To tell and ask microsoft:

We will be setting up a microsoft sql server 2000 instance running on
a windows 2003 server.

1) We need to check this can run alongside a microsoft 2003 sql server
(either workgroup or standard edition), on the same machine. Are there
any .dll clashes if we do this? If there are can we run SQL Server
2000, in a virtual machine running windows 2000 professional. (I have
a licenced copy we can use for this).

2) If we run one instance of 2000, and one of 2003 of the sql servers,
can one use the processor licence model, and one use the CAL licence
model."

Thanks for any help, and any idea why they actually force you to use
news groups for pre-sales information?

David

I can't answer the license question, but we ran both SS2K and SS2K5 on a single
server for several months. We just had to use a non-default named instance for
the second instance installed. That means you cannot refer to the non-default
instance by IP address.

Other than being a bitch to later remove the 2K instance and switch the 2K5
instance to the default instance name we had no issues.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Thats just what we wanted to hear thanks (apart from being a bitch to
uninstall - no suprises there).

Could someone please confirm that if both instances are run on
different ports we could do IPAddress:<Uniq ue Portfor both instances.
One instance would be firewalled between another network, so its
important we can do only TCP/IP with an instance, without allowing
named pipes, etc through.

Thanks

David

Nov 20 '06 #3
David,
I've had several 2000 and 2005 SQL instances running on the same
Windows 2003 server without running into dll conflicts. As far as your
licensing options I don't think that will be a problem either, just
something you need to work out with your software vendor.

On Nov 20, 3:57 am, "David" <david.goody... @gmail.comwrote :
Hi all,

I just asked some people to help me out and phone microsoft with the
following information, kindly they refused unless we setup a support
contract with them first, for pre-sales information. (That really does
not sound like good business sense to me - anyway here is our problem,
if anyone could help thanks).

"To tell and ask microsoft:

We will be setting up a microsoft sql server 2000 instance running on a
windows 2003 server.

1) We need to check this can run alongside a microsoft 2003 sql server
(either workgroup or standard edition), on the same machine. Are there
any .dll clashes if we do this? If there are can we run SQL Server
2000, in a virtual machine running windows 2000 professional. (I have a
licenced copy we can use for this).

2) If we run one instance of 2000, and one of 2003 of the sql servers,
can one use the processor licence model, and one use the CAL licence
model."

Thanks for any help, and any idea why they actually force you to use
news groups for pre-sales information?

David
Nov 21 '06 #4
As for your port question, we have successfully done this as well.

On Nov 21, 9:34 am, "Jason Cumberland" <jcumberl...@gm ail.comwrote:
David,
I've had several 2000 and 2005 SQL instances running on the same
Windows 2003 server without running into dll conflicts. As far as your
licensing options I don't think that will be a problem either, just
something you need to work out with your software vendor.

On Nov 20, 3:57 am, "David" <david.goody... @gmail.comwrote :
Hi all,
I just asked some people to help me out and phone microsoft with the
following information, kindly they refused unless we setup a support
contract with them first, for pre-sales information. (That really does
not sound like good business sense to me - anyway here is our problem,
if anyone could help thanks).
"To tell and ask microsoft:
We will be setting up a microsoft sql server 2000 instance running on a
windows 2003 server.
1) We need to check this can run alongside a microsoft 2003 sql server
(either workgroup or standard edition), on the same machine. Are there
any .dll clashes if we do this? If there are can we run SQL Server
2000, in a virtual machine running windows 2000 professional. (I have a
licenced copy we can use for this).
2) If we run one instance of 2000, and one of 2003 of the sql servers,
can one use the processor licence model, and one use the CAL licence
model."
Thanks for any help, and any idea why they actually force you to use
news groups for pre-sales information?
David
Nov 21 '06 #5

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

Similar topics

22
3311
by: EP | last post by:
When running my asp.net hosting service (asp.net without IIS), on server 2003 with IIS not installed, I get the following when trying to process a request. "System.DllNotFoundException: Unable to load DLL (aspnet_isapi.dll)." Of course the dll is able to be found, it's still in the framework directory and for grins I even put it in my service's local directory. This is apparantly server 2003 not allowing asp.net to be run if IIS was not...
17
9242
by: Danieltbt05 | last post by:
just installed SQL server 2000 and using my client , i can't locate the server. I used SQL query analyzer to search but no servers were found. Error message is as below Server : Msg17,level 16, state1 SQL server does not exist or denied access.
9
4977
by: Neil | last post by:
We have an Access 2000 MDB with a SQL 7 back end. We are upgrading SQL Server to SQL 2005, and are considering upgrading to Access 2003. Someone mentioned that they had heard about some incompatibilities between Access 2003 and SQL Server 2005. Anyone hear of anything? And, if so, would staying with Access 2000 be better? Thanks! Neil
9
2706
by: RvGrah | last post by:
After much hair-pulling, I've finally found the answer to a problem that many are fighting with, difficulty connecting from Sql 2005 Server Management or VS2005 to a remote Sql Server running Sql 2000. In my case the server I couldn't reach was across a vpn connection, behind ISA server 2000, (which had port 1433 open). The answer was in this post:...
8
3282
by: M K | last post by:
I am a newbie at C# (VS 2005) and SQL Server(2003). I was able to create a db using my old pc and then copied it to my laptop to my project folder, I cannot connect to it nor can i create a db on my laptop. I belive its an access issue but I don't know what to do. When i go into Enterprise Manager it shows a red dot for (local) and when i try to connect(click) to it i get the following: A connection could nto be established to...
2
6978
by: Jobs | last post by:
Download the JAVA , .NET and SQL Server interview with answers Download the JAVA , .NET and SQL Server interview sheet and rate yourself. This will help you judge yourself are you really worth of attending interviews. If you own a company best way to judge if the candidate is worth of it. http://www.questpond.com/InterviewRatingSheet.zip
14
3050
by: Developer | last post by:
Hello All, i have recently installed VS2005 and was trying to install SQL sever 2000. I have Win XP' SP2. But when I tried installing, it only installed client tools and not the database. Can anyone please help me with this as I want to install SQL server and also wouold be grateful, if you can suggest me any workaround to dealwith this problem.(Like should I install any new OS etc). Any help would be appreciated.
2
3953
by: Neil | last post by:
Has anyone heard of any problems running SQL 7 under Windows Server 2003? We're upgrading to 2003 and are wondering if we can keep SQL 7 with the new OS. Question 2: If we upgrade SQL to SQL 2005, can I run our database in SQL 7 mode? Or would it be better to just convert it to SQL 2005? Thanks! Neil
0
9833
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
10867
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
10562
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...
0
9391
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7803
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
6989
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5666
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
4036
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3122
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.