Last post Jul 25, 2007 09:27 PM by biobot
Jul 24, 2007 10:54 PM|biobot|LINK
I have made a serious effort to resolve this issue but am not making any progress.
It began while I was attempting to connect to a remote database. The nut of that problem was that I had deleted the default SQL database. I have since reinstalled it. Now, I am unable to start the service, and get this message: "The service did not respond
to the start or control request in a timely fashion, you need administrator priveleges to be able to start/stop this service. (SQLSAC)"
I am trying to do this from the administrator account, so I don't know what the issue is.
Also, when using the IIS management snap-in, I always get the following: "This computer is not running Internet Information Services version 4 or higher."
I am aware that IIS 5.1 or higher is required, but I thought it was native to XP Professional SP2, and although I've reinstalled it, I still get this error.
Any help would be appreciated.
sql server express
Visual Web Developer Express
Jul 25, 2007 01:12 AM|ravipahuja1|LINK
Make sure that you have IIS Admin services is running. See under the services. Try Start->Run->Services.msc then look for IIS Admin Service.
Jul 25, 2007 01:27 PM|biobot|LINK
Thanks for responding. I tried your suggestion, and could not find any reference to IIS under either of the Extended or Standard tabs.
I'm not sure these are related, but as part of the cluster of problems I'm trying to resolve:
I did try to start SQLEXPRESS from Services.msc and got this error:"Windows could not start the SQL Server (SQLEXPRESS) on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor,
and refer to service-specific error code -2146885628."
This is from the log file:
I think the key to this is the fact that a valid certificate could not be found. Having tried to re-install, and still getting this error, I am at a loss as to what to do.
TOP SQL Server 2005
Jul 25, 2007 09:27 PM|biobot|LINK
This entire problem was caused by incorrect methods of removing and re-installing IIS and SQL Server 2005 (SQLEXPRESS version included with Visual Web Developer Express). For those unaware, or those like me who need it repeated, it seems
always uninstall and re-install afterwords; update, repair, upgrade, etc. doesn't work well if at all. In addition uninstalling IIS has a few tricks to it. See the following links for help:
http://support.microsoft.com/kb/325889/en-us for help uninstalling and re-installing IIS
http://support.microsoft.com/kb/908452/en-us for help with SQL Server 2005 installation under Visual Web Developer Express
http://support.microsoft.com/kb/306005/en-us you may need this to re-establish your web sites after re-installing IIS
"A little knowledge is a dangerous thing." Unknown author.
I thought I knew how to install and uninstall too! I could have saved a lot of time, had I realized...