sqlserver installation issue

Question

sqlserver installation issue

karan457-979314

Ten Centuries

Points: 1001
More actions
March 18, 2009 at 12:36 am

#132408

Hi
In my system i have installed sql2000 and sql2005
if i open sql 2005 in new query select @@version it is showing sql2005 (8.0....)
how can i see sql2000 and sql2005 versions of sqlserver at a time in new query

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Chand00 SSCertifiable Points: 6466 More actions · Answer 1

Hi,

As you had installed both sql2k and sql2k5 in your system. One might be the default instance and another one as named instance. And at a time you can get connect to only one sql server.

[highlight=#ffff11]if i open sql 2005 in new query select @@version it is showing sql2005 (8.0....)[/highlight]

This is entirely false as when you run select @@version for sql 2000 it shows you as sql2000 (8...)

and for sql2005 it shows you sql2005 (9..) as for sql2000 the version starts with 8.0... and for sql 2005 it starts with 9.0... and not sql2005(8.0...) as you had said.

[font="Verdana"]Thanks
Chandra Mohan[/font]

karan457-979314 Ten Centuries Points: 1001 More actions · Answer 2

i found the solution

my system admin installed both sqlserver 2000 & 2005 as default instances

thats why iam getting above issue right

if iam wrong please clear

Chand00 SSCertifiable Points: 6466 More actions · Answer 3

Hi Karan,

You are totally wrong. Even if you system admin tries to install both as default instances sql server wont let you. Run the below query on both the instances

select serverproperty('InstanceName')

if it returns null then it is default instance otherwise it returns the name of the instance if it is a named instance.

Thanks

Chandra Mohan N

[font="Verdana"]Thanks
Chandra Mohan[/font]

karan457-979314 Ten Centuries Points: 1001 More actions · Answer 4

Hi chandra thanks for u r suggession

if i want to install ss 2000 & 2005 on one windows box

q) can i install both as default instance

but

if open ssms in new query

i checked select @@version

iam getting 8.0(i.e sqlserver2000)version only

please claryfy my dougt

if i was wrong pls correct

Perry Whittle SSC Guru Points: 234013 More actions · Answer 5

karan457 (3/19/2009)
if i want to install ss 2000 & 2005 on one windows box
q) can i install both as default instance

no you cant. If you install 1 as a default instance the other would have to be a named instance. Why not un install everything and re install creating 2 named instances that clearly identify the sql2000 and sql2005 instances

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

umar iqbal SSCommitted Points: 1703 More actions · Answer 6

Guys,

you cannot install 2 different version with default instance. Please check BOL. SQL would not let you do that. So fo you. You have to uninstall both sql and then install again. make sure to install sql 2000 first. you can make it default if you want or make it named. after sql 2000 installation is done you should install sql 2005 installation as named instance.

:crazy: :alien:

Umar Iqbal

eng_mgomaa Right there with Babe Points: 796 More actions · Answer 7

eng_mgomaa

Right there with Babe

Points: 796

March 19, 2009 at 10:52 pm

#963309

i am agree 100% with umar iqbal, he is right