General SQL server 2000 Install Question

[cgl88]

I am using a computer at work that has MS Visual Studio.Net installed. SQL Server developer has not been installed. However, the installation for SQL server won't work because the system "detects a previous installation that requires a reboot." Of course, I reboot but that does not seem to be the problem.

Does anyone know what files I can delete, or change in configuration, or will i have to re-install VB.NET/SQL?!

[DaveKeatley]

If your running on Windows 2000, verify that your running the latest Service Pack.

[cgl88]

Originally posted by DaveKeatley
If your running on Windows 2000, verify that your running the latest Service Pack.

Yup. It is. I have SP3 installed for W2k, and SP1 for VS.NET.

[DaveKeatley]

it's actually a problem with the installer. I've seen it two ways before.

1. Install software in 2000 as user and not relog as user (install pending)

2. Install software in 2000 as user and user doesn't have rights to finish install (should generate error on w2k restart)

I think there's an article in MSFT's Knowledge base, but don't recall.

[cgl88]

Originally posted by DaveKeatley
it's actually a problem with the installer. I've seen it two ways before.

1. Install software in 2000 as user and not relog as user (install pending)

2. Install software in 2000 as user and user doesn't have rights to finish install (should generate error on w2k restart)

I think there's an article in MSFT's Knowledge base, but don't recall.

I think it may be the first case for me. If I tried to log on as another user to "complete" the installation would that work? Or should I simply uninstall vs.net. I should also say SQL Desktop Engine is installed. Does that make a difference?

[techgnome]

See.... this is what happens when not all the info comes out first time......
Yes, having MS SQL DE makes a diff. Basically SQL Server is already installed. The only thing you don't have are the tools. Re-run the install. But this time select to only install the query tools (I forget what the exact name for it is, but it's the option that will install only QA, EM and a couple of other things).

[cgl88]

Originally posted by techgnome
See.... this is what happens when not all the info comes out first time......
Yes, having MS SQL DE makes a diff. Basically SQL Server is already installed. The only thing you don't have are the tools. Re-run the install. But this time select to only install the query tools (I forget what the exact name for it is, but it's the option that will install only QA, EM and a couple of other things).

Sorry about that. I originally posted the message and then tried Vs.net install whereupon I found out that the desktop was installed. I am not familiar with how to access SQL server through the desktop, etc. but I'll play around with it.

Thanks guys, for your help.

[DaveKeatley]

<smacking self in forhead>

Why do I always assume that programmers aren't users when posting questions?

[techgnome]

Originally posted by DaveKeatley
<smacking self in forhead>

Why do I always assume that programmers aren't users when posting questions?

Sometimes that IS the problem. Programmers are users -- usually of the Twinkie or drug variety....

[cgl88]

Originally posted by DaveKeatley
<smacking self in forhead>

Why do I always assume that programmers aren't users when posting questions?

Well, actually I removed the desktop engine but still have the same problem. I suppose I will have to do the development work using the desktop engine Any thoughts?

[cgl88]

Originally posted by techgnome
See.... this is what happens when not all the info comes out first time......
Yes, having MS SQL DE makes a diff. Basically SQL Server is already installed. The only thing you don't have are the tools. Re-run the install. But this time select to only install the query tools (I forget what the exact name for it is, but it's the option that will install only QA, EM and a couple of other things).

I finally had the time to uninstall Visual Studio.NET completely. I try to run SQL server setup but it gives me the same message as saying a previous installation exists and i need to restart.

Should I just re-install VS.NET but select only the query tools, then install SQL server devloper?

[JordanChris]

Are you running Windows 2000 Server? Or Windows 2000 Professional?? If you are running Sever, then you should be able to clear out your old installations, and install SQL Server.

If you are running Professional, then I susect that SQL Server can not be installed, and you will need to use the Desktop / personal variety - as that was designed for use with the desktop operating systems.

[cgl88]

Originally posted by JordanChris
Are you running Windows 2000 Server? Or Windows 2000 Professional?? If you are running Sever, then you should be able to clear out your old installations, and install SQL Server.

If you are running Professional, then I susect that SQL Server can not be installed, and you will need to use the Desktop / personal variety - as that was designed for use with the desktop operating systems.

I am using the desktop version. Perhaps that is the case? Any other opinions?