Wednesday, October 31, 2012

Windows Authentication prompting for credentials

I created a ASP.Net website with Windows Authentication on IIS7.

When I access the website, IE kept prompting for my network credentials. After some digging around, I found that the issue was coming from Windows Authentication Providers.

1) Launch IIS Manger
2) Select your web application, and double click on Authentication


3) Right Click on Windows Authentication, and select Providers. ( I have Impersonate = "true" set up on my web application, that's why ASP.Net Impersonation is enabled for me)

4) Make sure that the Providers are in the order above. NTLM first and Negotiate second.
5) If the order is reversed, IE will keep prompting you for your network credentials.

Hope this helps.


Thursday, October 25, 2012

How to take a website offline

Quick and easy way is to create a simple html file, and call it app_offline.htm, and paste it to your website root directory. Note that the file has to be named as app_offline.htm

Once IIS finds this file, it stops further processing.

To make your website online, just delete this file or rename this file
 
<!-- Sample app_offline.htm file  -->
<html>
<HEAD><title>Web Site Down for Maintenance</title>
</head>
<body>
<H1>Your custom message blah blah blah</H1>
<BR>
<!--      

    To prevent IE 404 error, I am adding few lines of commented text
  

    <h2>IE Cannot handle files less than 512bytes in size. It works in Firefox and Chrome ...</h2>

    <h2>IE Cannot handle files less than 512bytes in size. It works in Firefox and Chrome ...</h2>

    <h2>IE Cannot handle files less than 512bytes in size. It works in Firefox and Chrome ...</h2>

    <h2>IE Cannot handle files less than 512bytes in size. It works in Firefox and Chrome ...</h2>

    <h2>IE Cannot handle files less than 512bytes in size. It works in Firefox and Chrome ...</h2>

    <h2>IE Cannot handle files less than 512bytes in size. It works in Firefox and Chrome ...</h2>

    <h2>IE Cannot handle files less than 512bytes in size. It works in Firefox and Chrome ...</h2>

    <h2>IE Cannot handle files less than 512bytes in size. It works in Firefox and Chrome ...</h2>

    <h2>IE Cannot handle files less than 512bytes in size. It works in Firefox and Chrome ...</h2>

    <h2>IE Cannot handle files less than 512bytes in size. It works in Firefox and Chrome ...</h2>

    <h2>IE Cannot handle files less than 512bytes in size. It works in Firefox and Chrome ...</h2>

    <h2>IE Cannot handle files less than 512bytes in size. It works in Firefox and Chrome ...</h2>

    <h2>IE Cannot handle files less than 512bytes in size. It works in Firefox and Chrome ...</h2>

-->
</body>
</html>

Oracle:How to create new Temp Tablespace

If you have your Oracle Temp Tablespace set to Auto Grow, you would have noticed TEMP tablespace becoming quite large

On my database , it was around 20GB and I decided to create a new Temp Tablespace and drop the old one.

Log in as SYS

Create a new Temp tablespace TEMP2

Create Temporary tablespace TEMP2 TEMPFILE 'D:\oracle\product\10.2.0\oradata\suppdb\TEMP.DBF' SIZE 500M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;

Make the new Temp tablespace as the default

Alter database default temporary tablespace Temp2;

You can verify it by the SQL below

SELECT Distinct temporary_tablespace from dba_users ;



Now time to drop the old one, You need to first verify if any existing sessions is still using your old TEMP tablespace

SELECT u.USERNAME, u.SESSION_NUM, u.SESSION_ADDR, s.sid,s.serial#,s.schemaname,s.osuser,
s.program,'Alter System Kill Session '''||s.sid||','||s.serial#||''';' Kill_Session
FROM V$SORT_USAGE u, v$session s
where u.session_addr = s.saddr;


You can either kill the sessions, are ask the corresponding users to close out their connection. Once all existing connections are closed/killed, you can drop the old temp tablespace.

 Drop tablespace Temp including contents and datafiles;


Finally Rename the new tablespace from TEMP2 to TEMP

Alter tablespace TEMP2 rename to TEMP;

You can verify it by the SQL below

SELECT Distinct temporary_tablespace from dba_users ;

Tuesday, October 16, 2012

How to remove login password in Windows 8

  1. Launch command Prompt
  2. type netplwiz
  3. launch the netplwiz app
  4. Uncheck "User must enter username and password to use this computer"
  5. you will be prompted to confirm, with your current password.