Can not connect to Database

I recently uninstalled SQL Server due to connection issues I started having. I could start the DB and connect/edit tables in Ent Mgr etc, but all the sudden, none of my code could make DB connections.

So, after reinstalling now nothing works. I cannot even connect in Ent. Manager. I went to Administrative Tools->Services to make sure it was running, and SQLSERVER isn't even listed under services. What happened? Is there another step after installing SQL Server I missed to get the service up and going. Do I need to do something in ODBC connections?

I am on Windows XP with SP2.

TimWell see if SQL Server Manager is running in the system tray. Maybe you didn't set it to start SQL Server on windows startup. Also if you did reinstall I would think your sa password is blank unless you set it during install.|||It is not running in the system tray, and I cannot start SQL Server, because the service does not exist. Setting it to start on windows startup doesn't do anything.

For some reason when I install it, the service component does not get installed.

I get the following error when I try to start SQL Server

--------
Service Control Failure
"An Error 1060 - (The specified service does not exist as an installed service) occured while performing this operation on the MSSQL service"|||Try reinstall with the repair option and make SQL Server Service Auto start, SQL Server will start anytime you start the OS. Hope this helps.

Kind regards,
Gift Peddie|||I do not see where I can install with "repair" mode. That option never comes up.

However, this happens every time I try to install. I get an error window that pops up at the start that say this:

"Microsoft SQL Server Standard Edition server component is not supported on this operating system. Only client components will be available for installation."

I am on Windows XP Service Pack 2. I don't understand though, because I installed it fine on this computer before. But maybe it was before I installed SP 2, I dont know.

Anyone know why this is happening or what I should do?|||Use the original cd you used when installing on that box. And don't try to say that you used that exact cd when you first installed because it's not supported on client operating systems.|||We have the exact same problem
We have the original cd's of the Standard, Developer & Personal editions.
After installing the developers edition on WindowsXP, the service manager app shows in the taskbar, but it will not connect to the sql server|||try installing service pack 3|||hi all

I installing service pack 3 and NO fix't|||XGBoomer, yours is NOT the exact same problem as you actually do have SQL Server installed and it is running.

What exactly do you mean by "it" in "it will not connect to the sql server"? And, are you receiving any error messages?

Terri|||You can only install the developer or MSDE versions on XP. You can't put Enterprise or Standard on the OS. Install developer and you should be good to go. I'm not sure what you've done to your DB's now though. YOu may want to look in the data folder and copy your files to another location, if they are still there. Then if it hoses your data directory at least you will still be able to attach the databases back to the new install.

hth Bruce|||Not quiet the same problem but I have Developer edition on XP Pro/SP2 running for a while now. Out of the blue it won't run ie it starts and then stops straight away. There is another edition of MSDE on the same box that runs fine, and I don't think its the firewall.

Any ideas?

Regards|||Update - I tried the repair function (using the SQL installer) which did the trick. I can't figure out why it happened though.

Regards