Installing asp.net state service
As some how I got my AspNet State service failed to run, its deleted automatically. So there was not such service in my service listing. To get it running again we need it install it.
Following are the commend to install it back:
1. Open you command prompt:
- a) Go to the .net Framework directory [Form me its .NET 4 and 64 bit Win 7]: X:\Windows\Microsoft.NET\Framework64\v4.0.30319>
- b) Run the following commands:
aspnet_regiis.exe –u
aspnet_regiis.exe –i
aspnet_regiis.exe –c
You should now get the service running and can view the list of service services.msc.
Running IIS and Apache in Same Box
I was facing problem to run IIS and Apache simultaneously. After a few tricks here is a way I have found to make it work.
To confirm my box is running on Windows 7 and IIS 7.
Assuming that you have IIS installed and trying to work with Apache and MySql. To do that I downloaded XAMPP. Install it XAMPP.
Now if we follow the following instruction then it should work fine:
1. Open C:\xampp\apache\conf\httpd.conf
a) Look for “Listen 80″, change to “Listen 8080″.
b) Look for “ServerName localhost:80″, change to “ServerName localhost:8080″
There is only one instance of both the search item.
2. Now Open C:\xampp\apache\conf\extra\httpd-ssl.conf
a) Look for “Listen 443″, change to “Listen 4499″
b) Look for “<VirtualHost _default_:443>”, change to “<VirtualHost _default_:4499>”
c) Look for "“ServerName localhost:443″, change to “ServerName localhost:4499″.
Then both IIS and Apache could run on the same box.
Test by following Urls;
1) For IIS : http://localhost/
2) For Apache: http://localhost:8080/xampp/ or http://localhost:8080/phpmyadmin/
Please remember to put port 8080 for Apache running pages.
Cheers. Please let me know if it works for you.
Also you can see: http://blog.wolffmyren.com/2008/07/30/making-xampp-apache-work-with-iis-on-windows-xpvista/
How to Change Login Mode In SQL Server 2005
In Sql server you can login in two mode:
1. Windows Authentication
2. Sql Server Authentication
But you can only access SQL Server in both way by default if you only have selected both the login option when you install the SQL server.
But, If you forgot to select both the option while installing the SQL server, you can edit the option in following way:
1. Right Click on Server instances and view the Properties
2. Form the Property window and list at the left select the “Security” tab:
3. Select the option indicating both the login mode and Click OK.
4. Cheers!! 
