[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Problem accessing Excel files from Intranet

Posted on 2006-06-05
20
Medium Priority
?
350 Views
Last Modified: 2010-03-19
My Domain users have started experiencing wierd problems accessing files from Intranet. We usually keep forms and other documents shared on Intranet and domain users were able to open and save those documents. Lately when they click on any excel document, it opens in IE window and if they do any change and then try to save it (they click save as), it is asking for domain authentication (connect to the server - and asks for username and password). I tested this on word files but its not doing any such thing on word files. As far as I have noted, its giving this username and password prompt on only excel files. The domain user is logged onto machine with domain user account and IE settings for intranet are set to - automatic logon only in intranet zone. I have anonymous login checked and use windows authentication checked in directory security. All this was working fine until past few days users started complaining about these files. I am able to open, edit and save the file from IE using my domain admin account but not with domain user account. I checked the permissions and security and domain user is given read, write and execute permissions at intetpub folder level so as to propogate to the subfolders.
Any help, advice is appreciated.

Thanks,
Abhi
0
Comment
Question by:altaonemis
  • 9
  • 9
18 Comments
 
LVL 15

Expert Comment

by:nprignano
ID: 16838175
did the files always open in the browser, or did they used to open in Excel?

nprignano
0
 

Author Comment

by:altaonemis
ID: 16842371
Well usually they open it in browser, edit it and then save it to desktop or any other place they like. But now when they click on save as, its asking for login name and password. Sometimes, its asking for user credentials even when you try to access those files/forms. I created some test accounts and tested using those and its asking me for user credentials. But if I hit cancel, it will open the file. If I click on save as, it asks for user credentials but if I hit cancel, it gives me option to save it. This is totally wierd. But this is not happening for administrators - I am able to open, edit and save the file just fine. It never asks for any logon information.  I looked at all the permissions but still I am not able to resolve it.
Thanks for your efforts and help

Abhi
0
 

Author Comment

by:altaonemis
ID: 16938863
Any suggestions?
0
Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

 
LVL 15

Expert Comment

by:nprignano
ID: 16980741
have you checked the file permissions, or just the directory?  have you checked the IIS permissions?

you could try reinstalling IIS.


nprignano
0
 

Author Comment

by:altaonemis
ID: 17003589
I checked everywhere and file/directory/IIS permissions looks fine.
Reinstalling IIS would be a hassle as then I would have to reconfigure all the files and folders associated with it.
Is there any other way of resolving this?

thanks
0
 
LVL 15

Expert Comment

by:nprignano
ID: 17005931
Are you using SharePoint or FrontPage server extensions?
0
 

Author Comment

by:altaonemis
ID: 17020188
sharepoint 2002 is installed on the server
0
 
LVL 15

Expert Comment

by:nprignano
ID: 17022431
are these sharepoint sites or regular html?
0
 

Author Comment

by:altaonemis
ID: 17038146
regular html
0
 
LVL 15

Expert Comment

by:nprignano
ID: 17047563
so you don't use sharepoint at all?  then I would uninstall it from the server.
0
 

Author Comment

by:altaonemis
ID: 17055363
Sharepoint manages that site. We manage that site through sharepoint bt the data on that site is regular HTML.

thanks,

Abhi
0
 
LVL 15

Expert Comment

by:nprignano
ID: 17056035
ok, so then have you checked permissions within the sharepoint administration console?  you can set site-level permissions here, so you need to check these settings.



nprignano
0
 

Author Comment

by:altaonemis
ID: 17062513
yes, i did check permissions there and there it has given browser permission to domain users.
Do you think we need to change it to some other level?
Also do you think that prompting for login information (asking credentials to access file) can be because of slow speed?

Abhi
0
 
LVL 15

Expert Comment

by:nprignano
ID: 17062559
doubt that connection speed has any effect, but depending on the contents of the excel files, you may want to assign higher permissions levels to users through SP admin console - many of the excel files i work with are modified just by opening them, so read access may not be enough.
0
 

Author Comment

by:altaonemis
ID: 17074952
I checked the permission and domain users have modify permissions.
Also some users are getting login credential screen when they try to access excel files or other files. Do you know of any tool or script that can verify IIS as well as files permission on a website?
0
 
LVL 15

Accepted Solution

by:
nprignano earned 500 total points
ID: 17078540
0
 

Author Comment

by:altaonemis
ID: 17085730
I'll give this a try - Thank you very much.
0
 
LVL 15

Expert Comment

by:nprignano
ID: 17086977
your welcome, and i think from now on i will reccomend this to others with similar problems to help the situation along sooner.  Let me know what you find out.

nprignano
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a collection of issues that people face from time to time and possible solutions to those issues. I hope you enjoy reading it.
Tech spooks aren't just for those who are tech savvy, it also happens to those of us running a business. Check out the top tech spooks for business owners.
Viewers will learn how to connect to a wireless network using the network security key. They will also learn how to access the IP address and DNS server for connections that must be done manually. After setting up a router, find the network security…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question