problems in installing sql server 2000 standard edition

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 standard edition.
Which of the above exists in my OS. Or which should I download.

Thanks

You can only install SQL Server full editions (such as Standard, Enterprise, etc) on "server" OSes, such as those listed in your original message. On "client" OSes such as XP, you can only install the client tools to connect to other server machines. Thus in order to install SQL 2000, you will need Windows 2000, 2003, or Vista. Same story with SQL 2005.

Thanks,
Sam Lester (MSFT)

Problems getting to the uninstall tool for SQl Server

Hi everyone,

I was so glad to get SQL Server Standard Edition that I forgot to remove the .Net Framework last. I almost removed all SQl Server files. I tried to remove the remaining files dealing with SQl Server(including add/remove programs) but I can't remove them all. I tried to go to the page to use the unstall tool for SQl Server 2005 but I get is the following:

You are not authorized to view this page
You might not have permission to view this directory or page using the credentials you supplied.
This is the URL that I was sent to: http://go.microsoft.com/fwlink/?LinkId=47598.

Is there any other way to get to this tool?

Thank you

I suspect that was a temporary glitch. Please repost if you still need help here...|||

Hi Paul,

Thank you for your reply. I have sucessfully installed SQL 2005 on my machine.

Problems getting to the uninstall tool for SQl Server

Hi everyone,

I was so glad to get SQL Server Standard Edition that I forgot to remove the .Net Framework last. I almost removed all SQl Server files. I tried to remove the remaining files dealing with SQl Server(including add/remove programs) but I can't remove them all. I tried to go to the page to use the unstall tool for SQl Server 2005 but I get is the following:

You are not authorized to view this page
You might not have permission to view this directory or page using the credentials you supplied.
This is the URL that I was sent to: http://go.microsoft.com/fwlink/?LinkId=47598.

Is there any other way to get to this tool?

Thank you

I suspect that was a temporary glitch. Please repost if you still need help here...|||

Hi Paul,

Thank you for your reply. I have sucessfully installed SQL 2005 on my machine.

sql

Problems (re)installing SQL Server 2005 in WinXP pro

I am attempting to install the Standard edition on a WinXP pro laptop that apparently had this installed before I got it. I Removed, thru Add/Remove, everything related to SQL Server. When I tried to do a fresh install of DB Services, Integration Services and Client tools, Setup Support and the Native Client seems to install ok, the directories get created and some files are put there. The installer stops and sez that the Databases Services and the Workstation Components are already installed, the Details button tells me that the only available option are thru the Add/Remove Programs. There are no entries for the Server or Client Tools on Add/Remove's list.

When I try to start the server it fails with "can't find the Path" reported in an Error Event, likewise I can't start the Management Studio because it can't find a file.

I think that I need to clean everything out to reinstall. I think that the Services are left over from the previous owner. Any suggestions?

joe elsaesser

documentation on manual uninstall process for sql 2005: http://support.microsoft.com/?kbid=909967&SD=tech|||

thank you, Derek. It went very well...

j

|||

if you are satisfied would you please mark an answer.

thanks,

Derek