Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sachinbutala
Starting Member
4 Posts |
 Posted - 2004-06-02 : 07:48:07
|
| we are using SQL 2000 with SP 3 Microsoft SQL Server 2000 - 8.00.818 (Intel X86) and now we want to create another instance of sql 2000 on it . our setup cd not containing sp3 is is possible to create an instance and also we want set 1433 for new instance with diffrent ip is it possible |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2004-06-02 : 07:58:13
|
| If I understand your question:Yes, you can have different instances of SQL on different services packs: e.g.\\server1\default SQL2000 SP3 (8.00.818)\\server1\named_instance SQL2000 SP2 (8.00.540 I think)If you are asking if you can service pack the named_instance - yes, but you will need the service pack - download it from :http://www.microsoft.com/sql/downloads/2000/sp3.aspLastly - different IP's on the same box? Hmm - not sure. If you have multiple network cards, you can have different IP's for them. Regards getting SQL to run from those- not sure. I *think* it is possible, but I've never had to try it*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
sachinbutala
Starting Member
4 Posts |
Posted - 2004-06-02 : 08:06:54
|
| thanx for ur reply .. but we are running sql2000 sp3 and now installing sql2000 without any sp. |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-06-02 : 09:00:51
|
| I'm not sure that you can specify an IP address to listen on.-------Moo. :) |
|
|
|
|
|
|
New Instance SQL 2000