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.
Wednesday, October 31, 2012
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>
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 ;
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
- Launch command Prompt
- type netplwiz
- launch the netplwiz app
- Uncheck "User must enter username and password to use this computer"
- you will be prompted to confirm, with your current password.
Subscribe to:
Posts (Atom)