Cannot install 'SQL Server 2005 Express Edition with Advanced Services'

I tried to install 'SQL Server 2005 Express Edition with Advanced Services'. First, I uninstalled the old version thru Add/Delete Programs in the Control Panel.

My first problem was I didn't have IIS installed on my computer, but, I could not find it in the downloads section.

Then the installation aborted because old version databases were in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data. But, it would not let me delete them, saying that they were being used, even though nothing was running at the time that I tried to delete them.

Hi,

"But, it would not let me delete them, saying that they were being used, even though nothing was running at the time that I tried to delete them."

I guess you still have a SQL Server installed on the system. If you want to install this, there has to be another option in the Add/Remove software panel for this instance. look in the service, if another service is running with SQL Server in its name (depending on the version you are using) you still have one installed.

"My first problem was I didn't have IIS installed on my computer, but, I could not find it in the downloads section."

IIS is part of the Windows installation, it can be installed by choosing the Add/remove Software icon in the control panel, choosing then the "Add/remove Windows Components" and then then "Internet Information Services (IIS).

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

I went into:
Control Panel
Add / Remove Programs
Add / Remove Windows Components

IIS was not one of the options there!

|||Whcih OS version are you using ?

HTH, jens Suessmeyer.

http://www.sqlserver2005.de
|||

Windows XP Home Edition.

|||

IIS is not included within Home Edition, any hack which enables you to use
it, wouldn′t comply with the license agreement within
the EULA.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

I upgraded to Windows XP Professional. I installed IIS.

When I attempt to run my app, I get an error message. I have had this problem occasionally before, the problem is that the SQL Server is not running. I went into Start/Run/c:\sseutil.exe -l. It said "The service MSSQL$SQLExpress" is not started. Would you like to start the service?" I replied "y". It said "Starting service....", but, it just hung there, it never actually succeeded in starting the service.

Before upgrading to XP Pro, my app ran, but, I would frequently have to go into sseutil.exe to start up SQL Server. After upgrading to XP Pro, I cannot get SQL Server to start.

I went into Control Panel/Add remove Programs and tried to uninstall Microsoft SQL Native Client. It said "This installation package cannot be installed by the Windows Installer service. You must install a Windows Service Pack that contains a newer version of the Windows Installer Service."

|||Hi,

if an error occured during the startup process of the SQL Server Service, it is logged in the event log, try to see what happened here and post back the event log entries if you are not familiar with debugging these.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||I un-installed and re-installed SQL Server 2005 Express Edition with Advanced Services. The install appeared to work correctly. My app no longer will run! sseutil.exe says "'MSSQL$SQLExpress' is not started. Would you like to start the service?", when I reply "y", it just hangs and never starts the service!|||Hi,

like I already said, look in the event log which will give you a more detailed information than the service starting message box. There has to be a problem during the start. The problem can vary so for trouleshooting the exact error message will be needed.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de