2010년 3월 12일 금요일

안드로이드에서 IIS의 Windows 통합 인증 (Problem logging into SharePoint site with NTLM Authentication )

LG-KH5200 을 구매하여 이리저리 사용을 해보던중... IIS의 Windows 통합 인증을 사용하는 사이트 접속이 불가능 하여 구글로 여러날을 수소문 하던중 아래와 같은 글을 발견...

역안드로이드만....

 

[펀글]

http://www.google.com/support/forum/p/Android%20Market/thread?tid=4f2b0f6f970f0988&hl=en

 

 

Problem logging into SharePoint site with NTLM Authentication Report abuse
lamiller44
Level 1
11/9/09
I want to get a Droid, but if I'm going to get that phone I need to be able login to my work's SharePoint site (which uses Windows/NTLM authentication).  I tried to do this in the Verizon store using the demo Droid phone but it didn't work

It works properly on my current phone (Motorola Q with Windows Mobile OS), and it obviously works properly from my desktop/laptop computers' browsers.  When I login to the SharePoint site from any browser on my desktop computer, an NTLM popup asks for User ID and Password.  It works a bit differently on my current phone, in which the authentication screen doesn't look like a browser UI but rather looks more like the type of UI that is used when you set up an Exchange connection.

When I try it on the Droid, there is no authentication popup/UI.  I access the SharePoint site in a browser, and then click the "login here" link, but then I'm taken straight to the web page that indicates that my login was unsuccessful.  This is the page that users are normally taken to when their User ID/Password credentials are invalid.

I poked around with the browser's settings on the phone but that didn't work.  I'd assume that if it's not possible to to NTLM/Windows authentication 'out of the box' with the Droid that there would be some type of driver or plug-in that I could purchase/download.  Otherwise this seems to be a pretty major shortfall of the phone (and one that I can't really imagine Google has overlooked).

Has anybody figured this out?

Replies 1 - 14 of 14

gat007
Level 1
11/19/09
i have the same problem too.
No solution until now.
1 of 3 people found this answer helpful. Did you?
Yes
No
Report abuse
lamiller44
Level 1
11/19/09
Unfortunately I wasn't able to wait.  I ended up getting an HTC Touch Pro 2.  Nice device, though it's still on Windows Mobile which I was hoping to get away from.  Oh well, maybe at a future date for me...
1 of 1 people found this answer helpful. Did you?
Yes
No
Report abuse
chrisl1979
Level 1
11/19/09
Same problem here.  Any solutions?
1 of 2 people found this answer helpful. Did you?
Yes
No
Report abuse
JarrettV
Level 1
11/21/09
Would also like a work around for this!
1 of 2 people found this answer helpful. Did you?
Yes
No
Report abuse
hwagner
Level 1
12/28/09
I have contacted firefox and they think that the new Firefox mobile will be able to solve this problem.  Lets hope firefox comes through for us droid users.  Like they have on many other occasions.
1 of 1 people found this answer helpful. Did you?
Yes
No
Report abuse
ismith0072
Level 1
1/7/10
I need to be able to log into SharePoint sites with the Droid.  Having a fast web browser with a big screen is great, but if I can't log into the applications I need for work, the it does me no good.  I'm still on my 30 day trial, here, and the phone is going back if this can't be resolved.
1 of 1 people found this answer helpful. Did you?
Yes
No
Report abuse
lamiller44
Level 1
1/7/10
I was the original poster.  I ended up getting an HTC Touch Pro 2.  I'm pretty happy with it, though I still envy the web features of the Droid.  On the Touch Pro 2 I have the same problem if I use the Opera browser (I ordered it online and didn't learn this until I got it).  However, the phone also comes with IE installed, and fortunately I AM able to login to my SharePoint site using IE.  I'm assuming that you could download IE onto the Droid and then use that browser solely when hitting your SharePoint sites, but you'd have to try it to find out...
0 of 1 people found this answer helpful. Did you?
Yes
No
Report abuse
anair44
Level 1
1/10/10
lamiller44, How did you get IE on your andriod device?  Where did you download this from?   As far as I know there is no IE for andriod.

Thanks
Did you find this answer helpful?
Yes
No
Report abuse
lamiller44
Level 1
1/10/10
anair44: i didn't end up getting the droid. i got  an HTC touch pro 2. it is windows mobile & comes delivered w/opera and IE. i'm not sure if you can even get IE on droid. just a possible suggestion....
Did you find this answer helpful?
Yes
No
Report abuse
anair44
Level 1
1/14/10
Has anyone tried this Android 2.1 Just wondering if this fixes the issue.
1 of 1 people found this answer helpful. Did you?
Yes
No
Report abuse
Carlad
Level 1
1/21/10
Unfortunately the Android 2.1 doesn't solve the problem. Solution anyone?
1 of 1 people found this answer helpful. Did you?
Yes
No
Report abuse
NA101010
Level 1
2/4/10
Just opened a brand new Droid (of my own to evaluate thanks to 30 days).  Also have several users with personal units.

We looked at Android based phones as a possible standard for our techies, but if they can't access some of our key corporate resources (NTLM), all the bells and whistles in the world won't convince us to continue. (this is with Nexus One, Droid, Eris, etc.)

Love the screen resolution on this thing, and can even live with the quirky zoom function.  But without NTLM support, there's no way I'm going to roll out Android devices for our users.
Did you find this answer helpful?
Yes
No
Report abuse
anair44
Level 1
2/12/10
Has anyone gotten any feedback from Google on this?  Really hate the fact that I have to power up my laptop to do basic things that I could do even from my blackberry.
1 of 1 people found this answer helpful. Did you?
Yes
No
Report abuse
NA101010
Level 1
2/18/10
Still nothing.  I simply cannot believe that there's not more furor over this.   Apparently there's no push to break into the corporate side.

So we have Blackberry, iPhone, WinMo, and even Symbian devices that can get in.  Just not Android.

It's a shame.  I love this screen, but....
Did you find this answer helpful?
Yes
No
Report abuse

2010년 2월 2일 화요일

[참고/오류가이드]Excel.Application 을 사용하여 엑셀 파일 열기에 실패하는 경우 (Can't Open Excel File) 가이드

제    목 :        
Excel.Application 을 사용하여 엑셀 파일 열기에 실패하는 경우 (Can't Open Excel File) 가이드

개    괄 :        
Excel.Application 사용 시 “Can't Open Excel File” 메시지가 나오는 경우에 대한 문제점 분석 과 가이드 입니다.

문 제 점 :        
[문제점]
-        fakepath ::인터넷익스플로러8 업로드오류
[원  인]
-        인터넷 익스플로러 8에서 보안에 관련된 사항이 변경됨

[해결방법]
- 인터넷 익스플로어(IE) 도구메뉴 -> 인터넷 옵션 에서 보안 탭 -> 사용자 지정 수준 클릭
- 보안사항에 대한 설정 중 "파일을 서버에 업 로드 할 때 로컬 디렉토리 경로 포함"  이라는 항목을 사용 안함 으로 되있는 것을 사용으로 변경



[참조 블로그] http://blog.naver.com/tnsk8080?Redirect=Log&logNo=10069423935

문제사항 및 해결방법 :        
위는 IE 자체적으로 보안을 변경하여 해결하는 방법입니다. 이는 IE의 옵션 변경을 하여야 하므로 번거로움이 있습니다. 이에 Max Component 중에 Input File Component 가 있습니다. 이를 이용한 Sample 가이드를 참고 하시기 바랍니다.

[Sample]
-        기본적으로 Max Ansi 버전을 기준으로 설명합니다. 만일 Unicode를 사용하시는 경우 CLSID를 변경 하시면 됩니다.

1.        Input File 컴포넌트 선언

<object id=tb_InputFile classid=CLSID:C722848E-C7EE-4DC6-947E-C2CD49BBA9DE
        style="position:absolute; left:355; top=55; width=110; height=23;visibility=hidden;">
<param name="Text"                value='FileOpen'>
<param name="Enable"        value="true">
</object>

엑셀 업로드 (FileComponent Upload) :
        <input type=button value="엑셀 업로드 (FileComponent Upload)" onClick="Open_File()">


2.        자바 스크립트에서 Open 함수를 사용하여 파일 경로를 얻어옴

< function Open_File() {
                tb_InputFile.Open();

                SetDataHeader(tb_DataSet);
//alert(tb_InputFile.Value);
                //LoadExcelData 옵션처리
                var strExcelFileName = "'"+tb_InputFile.Value+"'"; //파일이름
                var nStartRow = 0; //시작Row
                var nEndRow = 0; //끝Row
                var nReadType = 0; //읽기모드
                var nBlankCount = 3; //공백row개수
                var nLFTOCR = 0; //줄바꿈처리
                var nFireEvent = 1;//이벤트발생
                var nSheetIndex = 1; //Sheet Index 추가

                var stropt = strExcelFileName; //1st
                stropt += "," + nStartRow; //2nd
                stropt += "," + nEndRow; //3rd
                stropt += "," + nReadType; //4th
                stropt += "," + nBlankCount; //5th
                stropt += "," + nLFTOCR; //6th
                stropt += "," + nFireEvent; //7th
                stropt += "," + nSheetIndex //8th

                var obj = document.getElementById("tb_DataSet");

                fn_setTime(txtStart);
                obj.Do("Excel.Application", stropt);
                fn_setTime(txtEnd);

        }
</script>

참고URL : http://www.gauce.com/zboard.php?id=componentFAQ&page=1&sn1=&divpage=1&sn=off&ss=on&sc=on&select_arrange=headnum&desc=asc&no=136