Showing posts with label links. Show all posts
Showing posts with label links. Show all posts

Wednesday, March 21, 2012

Installing Sql server 8

Can anyone provide me links to install sql server version 8.
Further is sql server 8 and sql server 2000 one and the same

Quote:

Originally Posted by cmrhema

Can anyone provide me links to install sql server version 8.
Further is sql server 8 and sql server 2000 one and the same


Infact I have to add. Both sql server 8 and 2000 are one and the same.
When i install sql server 2000 i have a message
" Microsoft SQL Server 2000 Standard Edition Server Component is not supported on this operating system only client components will be available for installation"

Hence I cannot install properly. I installed only the client componets. Thereafter when I went through Enterprise Manager and tried to establish a connection, I failed. It said server does not exist.

What to do now?

I found out that if one has sql server 2000 standard editon the prerequisties are
Microsoft Windows NT Server 4.0 with Service Pack 5 or later, Windows NT Server 4.0 Enterprise Edition with Service Pack 5 or later, Windows 2000 Server, Windows 2000 Advanced Server, or Windows 2000 Datacenter Server.

I have windows xp professional version on which i am installing sql server.
Which of the above exists in my OS. Or which should I download.

Thanks

Friday, February 24, 2012

Installing SQL 6.5 and 2000 client utilities on the same machine

Can I install the client utilities for Microsoft SQL versions 6.5 and 2000 in the same machine?
Please, provide me with any information or links in this matter.I believe you have to install 6.5 first, then 2k/7 client

The other way around won't work...|||You probably can, although I've never tried. If you have the Client Utilities for SQL-2000, you really don't need the utilities for 6.5 because you can manage a 6.5 server using the 2000 tools.

-PatP|||You sure about that?|||I guess I haven't tried recently, but I think that you can as long as you are running sp6 or later on the 6.5 server... I don't have any 6.5 servers running anymore to verify that though.

-PatP|||Lucky you...

I think I got 1 lion around I can check....