The service did not respond to the start or control request in a timely fashion, you need administrator privileges to be able to start/stop service

Problem:

I was trying to run the SQL 2005 service but it failed and generated the error: “The service did not respond to the start or control request in a timely fashion, you need administrator privileges to be able to start/stop this service. (SQLSAC)”

Cause:

I have searched the even log and found the error: “The file "C:\Program Files\Microsoft SQL Server\MSSQL.3\MSSQL\DATA\mastlog.ldf" is compressed but does not reside in a read-only database or file group. The file must be decompressed.” I did search the web and found that the cause of such error happens because all the files related to the SQL under the path “C:\Program Files\Microsoft SQL Server\MSSQL.3\MSSQL\DATA\” was all compressed. This could happen due to many reasons but in my case it happened because I run the windows disk cleanup to clean temporary and unused files and this service compressed few files and part of them was the SQL data files.

Resolution:

Simply go to the path “C:\Program Files\Microsoft SQL Server\MSSQL.3\MSSQL\DATA\” or any other reported path, then right click and remove the compressed property then try to run the service again and it will work smoothly.
I guess it’s an interesting one and hope this helps too.

Regards,

Hamzeh Ayesh

Filter Listbox Based on Textbox Value

Helloz:

I was trying to filter a Listbox based on the value entered in a textbox filed in ASP.NET application. Wanted to do this on the client side. I have searched the web and found a very useful article and would like to share it since many developers would like to do the same in thier business applications.

Check it out @:
http://forums.asp.net/t/1263755.aspx

Regards,

Hamzeh Ayesh

SharePoint Server 2007 Developer Portal

Hellozzz:

I was browsing the web and found this link http://msdn.microsoft.com/en-us/office/aa905503.aspx
Which is a main reference a SharePoint developer may need, it has lots of useful articles between “Getting Started”, “How Do I”, best practices and others so thought of sharing it. Check it out and enjoy.

Regards,

Hamzeh Ayesh