application failed. when clicked on the sqlexpr.exe file.

Hello

I have the sql server 2005 express edition. the software stops during the setup and gives me a "failed" message. All other software of express edition are working fine. I am getting the problem only when I am dealing with sql server 2005 express edition. I made sure to deleate all the old version of sql server. uninstalled all the sql server files which were in my computer prior to download the new one. However I am still in troulbe.

As someone suggested that one should uninstale the sqlmsi file so I did that too. Still samething. Any help please......

Hi,

The event log should give you a clue what happened, eventually during the initial startup of the service.

Make sure that the SQL Server Service could start up properly. In the near püast a often and common error was that the rights provided within the SQL Server service was not priviledged to aquire the sufficient permissions for starting. So either make sure that you are using a account for starting the service which is priviledged to start as a service. Normally, Local System should be enough to start (commonly used), a (for me) better way is (if you have a domain context) is to use a domain account.

Some of the advantages are:

-There is much more security granularity over a domain account than over a system account
-If you later need network ressources you won′t get them with a Local System Account and have to switch to a domain account.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||Thank you very much sir thanks a lot its working now. :) i appreciated your support